private void Query() { DetailReportQueryModel model = new DetailReportQueryModel(); model.StartTime = dateTimePickerStart.Value; model.FinishTime = dateTimePickerFinish.Value; model.SN = textBoxSN.Text.Trim(); model.Source = comboBoxSource.SelectedText; if (comboBoxStore.SelectedValue != null) { DataRow dr = ((System.Data.DataRowView)comboBoxStore.SelectedValue).Row; model.StoreId = dr["ID"].ToString(); } DetailReportAction action = new DetailReportAction(); DataTable dt = action.Query(model); Bind(dt); }
public DataTable Query(DetailReportQueryModel model) { String sql = "SELECT B.ID, B.SN, B.RUNNINGNO, B.EXCTIME, B.EXCSOURCE, B.NETPAY,B.PAYABLE, B.HANDLING, B.STATUE, B.BANKRUNNINGNO FROM `BUSINESS_TRANSFLOW` B "; if (model.StoreId != null && model.StoreId != Guid.Empty.ToString()) { sql += String.Format( " INNER JOIN `BPSYS_STORESN` N ON B.`SN`= N.`CODE` " + " INNER JOIN `BPSYS_STORE` S ON S.`ID`= N.`STOREID` " + " WHERE 1=1 AND S.`ID`= '{0}' ", model.StoreId); if (!String.IsNullOrEmpty(model.SN)) { sql += String.Format(" AND N.CODE='{0}'", model.SN); } } else { sql += " WHERE 1=1 "; } if (!String.IsNullOrEmpty(model.Source)) { sql += String.Format(" AND B.EXCSOURCE='{0}'", model.Source); } if (model.StartTime.HasValue && model.FinishTime.HasValue) { sql += String.Format(" AND B.EXCTIME BETWEEN '{0}' AND '{1}' ", model.StartTime.Value.ToString(TIME_FORMAT), model.FinishTime.Value.ToString(TIME_FORMAT)); } DataTable dt = new DataTable(); using (DataBaseProcess process = new DataBaseProcess()) { dt = process.Query(sql); } return(dt); }