protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageInProcessModel model = new StorageInProcessModel();
string EnterDateStart = string.Empty;
string EnterDateEnd = string.Empty;
string StorageID = string.Empty;
string FromBillNo = string.Empty;
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.InNo = txtInNo.Value;
model.Title = txtTitle.Value;
model.ProcessDept = txtDeptProcessID.Value;
model.DeptID = txtDeptID.Value;
model.BillStatus = sltBillStatus.Value;
model.Executor = txtExecutorID.Value;
model.Processor = txtProcessorID.Value;
EnterDateStart = txtEnterDateStart.Value;
EnterDateEnd = txtEnterDateEnd.Value;
StorageID = ddlStorageID.SelectedValue;
string BatchNo = txtBatchNo.Value;
FromBillNo = txtFromBillID.Value;
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
DataTable dt = StorageInProcessBus.GetStorageInProcessTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, StorageID, FromBillNo, orderBy);
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "生产任务单", "加工类别", "加工单位", "生产负责人", "部门", "入库人", "入库时间", "入库数量", "入库金额", "摘要", "单据状态" },
new string[] { "InNo", "Title", "TaskNo", "ProcessType", "ProcessDeptName", "Processor", "InPutDeptName", "Executor", "EnterDate", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
"生产完工入库列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "生产任务单", "加工类别", "加工单位", "生产负责人", "部门", "入库人", "入库时间", "入库数量", "摘要", "单据状态" },
new string[] { "InNo", "Title", "TaskNo", "ProcessType", "ProcessDeptName", "Processor", "InPutDeptName", "Executor", "EnterDate", "CountTotal", "Summary", "BillStatusName" },
"生产完工入库列表");
}
}
