protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageInOtherModel model = new StorageInOtherModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string EnterDateStart = string.Empty;
string EnterDateEnd = string.Empty;
model.InNo = txtInNo.Value;
model.Title = txtTitle.Value;
model.DeptID = txtDeptID.Value;
model.BillStatus = sltBillStatus.Value;
model.Executor = txtExecutorID.Value;
model.Taker = txtTakerID.Value;
model.Checker = txtCheckerID.Value;
EnterDateStart = txtEnterDateStart.Value;
EnterDateEnd = txtEnterDateEnd.Value;
string StorageID = sltStorageID.SelectedValue;
string orderBy = txtorderBy.Value;
string BatchNo = txtBatchNo.Value;
model.ProjectID = HidProjectID.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
DataTable dt = StorageInOtherBus.GetStorageInOtherTableBycondition(BatchNo, model, StorageID, EnterDateStart, EnterDateEnd, orderBy);
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "交货人", "验收人", "入库部门", "入库人", "入库日期", "入库原因", "入库数量", "入库金额", "摘要", "单据状态" },
new string[] { "InNo", "Title", "TakerName", "CheckerName", "InPutDept", "ExecutorName", "EnterDate", "ReasonTypeName", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
"其他入库列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "交货人", "验收人", "入库部门", "入库人", "入库日期", "入库原因", "入库数量", "摘要", "单据状态" },
new string[] { "InNo", "Title", "TakerName", "CheckerName", "InPutDept", "ExecutorName", "EnterDate", "ReasonTypeName", "CountTotal", "Summary", "BillStatusName" },
"其他入库列表");
}
}
