protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
StorageAdjustModel model = new StorageAdjustModel();
model.CompanyCD = companyCD;
model.Title = this.txtSubject.Text.Trim();
model.AdjustNo = this.txtReportNo.Text.Trim();
model.StorageID = int.Parse(this.hiddenStorageID.SelectedValue);
model.BillStatus = BillStatus.Value;
string theBeginTime = this.BeginTime.Value;
string theEndTime = this.EndTime.Value;
model.Executor = int.Parse(hiddenExecutor.Value);
model.DeptID = int.Parse(hiddenDeptID.Value);
model.ReasonType = int.Parse(ddlReason.SelectedValue);
string theFlowStatus = FlowStatus.Value;
int TotalCount = 0;
string EFIndex = Request.QueryString["EFIndex"];
string EFDesc = Request.QueryString["EFDesc"];
GetBillExAttrControl2.ExtIndex = EFIndex;
GetBillExAttrControl2.ExtValue = EFDesc;
GetBillExAttrControl2.SetExtControlValue();
model.Attachment = " ID Desc";
if (this.hiddenOrder.Value != "0")
{
string[] myOrder = this.hiddenOrder.Value.Split('_');
if (myOrder[1] == "a")
{
model.Attachment = myOrder[0] + " asc ";
}
else
{
model.Attachment = myOrder[0] + " desc ";
}
}
model.Creator = -100;
model.Confirmor = -100;
string BatchNo = this.txtBatchNo.Value.ToString();
model.BatchNo = BatchNo;
DataTable dt = StorageAdjustBus.GetAllAdjust(model, EFIndex, EFDesc, theBeginTime, theEndTime, theFlowStatus, ref TotalCount);
//导出标题
string headerTitle = "单据编号|单据主题|仓库|经办人|部门|调整时间|调整原因|单据状态|审批状态";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "AdjustNo|Title|StorageName|EmployeeName|DeptName|AdjustDate|CodeName|BillStatus|FlowStatus";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "日常调整单列表");
}
catch
{ }
}
protected void Page_Load(object sender, EventArgs e)
{
FlowApply1.BillTypeFlag = ConstUtil.CODING_RULE_Storage_NO;
FlowApply1.BillTypeCode = ConstUtil.CODING_RULE_StoAdjust_NO;
HiddenPoint.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).SelPoint; //小数位
HiddenMoreUnit.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit.ToString(); //是否启用多计量单位
if (!IsPostBack)
{
ddlInStorage.Attributes.Add("onchange", "DoChange()");
checkNo.CodingType = ConstUtil.CODING_RULE_Storage_NO;
checkNo.ItemTypeID = ConstUtil.CODING_RULE_StoAdjust_NO;
//控制条码扫描
if (!((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsBarCode)
{
btnGetGoods.Visible = false;
}
#region 初始化
int EmployeeId = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID;
string Company = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string UserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).UserID;
txtCloseDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtCloser.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName;
txtCloserReal.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName;
txtCloser.Value = EmployeeId.ToString();
txtConfirmor.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName;
txtConfirmDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
tbCreater.Text = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeName;
txtCreateDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
txtModifiedUserID.Text = UserID.ToString();
txtModifiedDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
ddlInStorage.DataSource = StorageAdjustBus.GetStorageInfo();
ddlInStorage.DataTextField = "StorageName";
ddlInStorage.DataValueField = "ID";
ddlInStorage.DataBind();
//ddlInStorage.Items.Insert(0, new ListItem("--请选择--", "0"));
ddlReasonType.DataSource = StorageAdjustBus.GetReason("3");
ddlReasonType.DataTextField = "CodeName";
ddlReasonType.DataValueField = "ID";
ddlReasonType.DataBind();
ddlReasonType.Items.Insert(0, new ListItem("--请选择--", "0"));
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//扩展属性
GetBillExAttrControl2.TableName = "officedba.StorageAdjust";
string EFIndex = Request.QueryString["EFIndex"];
string EFDesc = Request.QueryString["EFDesc"];
GetBillExAttrControl2.ExtIndex = EFIndex;
GetBillExAttrControl2.ExtValue = EFDesc;
GetBillExAttrControl2.SetExtControlValue();
ddlReason.DataSource = StorageAdjustBus.GetReason("3");
ddlReason.DataTextField = "CodeName";
ddlReason.DataValueField = "ID";
ddlReason.DataBind();
ddlReason.Items.Insert(0, new ListItem("--请选择--", "0"));
hiddenStorageID.DataSource = StorageAdjustBus.GetStorageInfo();
hiddenStorageID.DataTextField = "StorageName";
hiddenStorageID.DataValueField = "ID";
hiddenStorageID.DataBind();
hiddenStorageID.Items.Insert(0, new ListItem("--请选择--", "0"));
}
}
