public HandlingResult Clear(ReportClearModel model)
{
HandlingResult result = new HandlingResult();
Boolean wherecluse = false;
// SELECT F.*FROM BUSINESS_TRANSFLOW F
//INNER
// JOIN BPSYS_STORESN SN ON SN.CODE = F.RUNNINGNO
// INNER
// JOIN BPSYS_STORE S ON S.ID = SN.STOREID
//WHERE F.EXCTIME BETWEEN '2015-11-30 17:00:00' AND '2015-12-01 19:00:00'
//AND F.SN = '89'
//AND F.EXCSOURCE = '微信'
//AND SN.NAME = '子店1'
//AND S.ID = ''
String delsql = " DELETE FROM BUSINESS_TRANSFLOW WHERE EXISTS ";
String insertsql = " INSERT INTO BUSINESS_TRANSFLOWT ";
String closql = " SELECT F.* FROM BUSINESS_TRANSFLOW F ";
closql += " INNER JOIN BPSYS_STORESN SN ON SN.CODE = F.RUNNINGNO ";
closql += " INNER JOIN BPSYS_STORE S ON S.ID = SN.STOREID ";
closql += " WHERE 1=1 ";
if (model.StoreId != null && model.StoreId != Guid.NewGuid())
{
closql += String.Format(" AND S.ID='{0}' ", model.StoreId);
}
if (model.StartTime.HasValue && model.FinishTime.HasValue)
{
closql += String.Format(" AND F.EXCTIME BETWEEN '{0}' AND '{1}'",
model.StartTime.Value.ToString(TIME_FORMAT), model.FinishTime.Value.ToString(TIME_FORMAT));
}
if (!String.IsNullOrEmpty(model.SN))
{
closql += String.Format(" F.SN={0}", model.SN);
}
if (!String.IsNullOrEmpty(model.SNName))
{
closql += String.Format(" SN.NAME={0}", model.SNName);
}
if (!String.IsNullOrEmpty(model.Source))
{
closql += String.Format(" F.EXCSOURCE={0}", model.Source);
}
insertsql += closql;
delsql += string.Format("(SELECT 1 FROM ( {0} ) T WHERE BUSINESS_TRANSFLOW.ID=T.ID)", closql);
using (DataBaseProcess process = new DataBaseProcess())
{
result.MsgNumber = process.Exec(insertsql);
result.MsgNumber = process.Exec(delsql);
}
result.Successed = result.MsgNumber > 0;
return(result);
}
private void Clear()
{
//TODO button enable
ReportClearModel model = new ReportClearModel();
model.StartTime = dateTimePickerStart.Value;
model.FinishTime = dateTimePickerFinish.Value;
model.SN = textBoxSN.Text.TrimStart().TrimEnd();
model.SNName = textBoxSNName.Text.TrimStart().TrimEnd();
model.Source = comboBoxSource.SelectedText;
model.StoreId = comboBoxStore.SelectedIndex >= 0
? Guid.Parse(comboBoxStore.SelectedValue.ToString())
: Guid.Empty;
ReportClearAction action = new ReportClearAction();
HandlingResult result = action.Clear(model);
//TODO message
}
