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;
}
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);
}
