| | |
|---|
| | | InitializeComponent(); |
|---|
| | | dateTimePicker1.Text = DateTime.Now.AddDays(-7).ToString(); |
|---|
| | | dateTimePicker2.Text = DateTime.Now.ToString(); |
|---|
| | | comboBox1.SelectedItem = "å
¨é¨"; |
|---|
| | | oWeb.Url = SCM.ClsPub1.WEBSURL; |
|---|
| | | } |
|---|
| | | public frmBillQueryCondition_Base frmCondition; |
|---|
| | |
|---|
| | | whereBuilder.Append(" and e.FNUMBER like ''%"+textBox1.Text+"%''"); |
|---|
| | | if (!string.IsNullOrEmpty(textBox2.Text)) |
|---|
| | | whereBuilder.Append(" and c.HMaterName like ''%"+textBox2.Text+"%''"); |
|---|
| | | if (comboBox1.Text == "å·²æ£éª") |
|---|
| | | whereBuilder.Append(" and c.HMaterName is not null"); |
|---|
| | | else if(comboBox1.Text=="æªæ£éª") |
|---|
| | | whereBuilder.Append(" and c.HMaterName is null"); |
|---|
| | | var execSql = "exec "+ViewName+" '"+whereBuilder+"'"; |
|---|
| | | DataSet DSet = oWeb.getDataSetBySQL(execSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | //çæé¦è¡æ é¢ |
|---|
