protected void Page_Load(object sender, EventArgs e) { this.GetBillExAttrControl1.TableName = "officedba.SubSellBack"; if (!Page.IsPostBack) { //新建修改门店销售退货单模块ID hidModuleID.Value = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSELLBACKADD; //HidDeptID.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString(); //DeptDeptID.Text = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptName; DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString()); if (dt != null) { if (dt["ID"] != null && dt["ID"].ToString() != "") { HidDeptID.Value = dt["ID"].ToString(); } else { HidDeptID.Value = "0"; } DeptDeptID.Text = dt["DeptName"].ToString(); } else { HidDeptID.Value = "0"; } } }
public static bool ConfirmSubStorageIn(SubStorageInModel Model, string DetailProductID, string DetailSendCount, string DetailUnitPrice, string DetailBatchNo, string length) { try { bool succ = false; LogInfoModel logModel = InitLogInfo(Model.InNo); logModel.Element = ConstUtil.LOG_PROCESS_CONFIRM; logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINIT; succ = SubStorageDBHelper.ConfirmSubStorageIn(Model, DetailProductID, DetailSendCount, DetailUnitPrice, DetailBatchNo, length); if (!succ) { logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } else { logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } LogDBHelper.InsertLog(logModel); return(succ); } catch (System.Exception ex) { throw ex; } }
public static bool UpdateSubStorageIn(SubStorageInModel model, string DetailProductID, string DetailSendCount, string DetailUsedUnitID, string DetailUsedUnitCount, string DetailUsedPrice, string DetailExRate, string DetailBatchNo, string length, string no, Hashtable htExtAttr) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; if (model.ID <= 0) { return(false); } try { bool succ = false; LogInfoModel logModel = InitLogInfo(no); logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //设置模块ID 模块ID请在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINIT; succ = SubStorageDBHelper.UpdateSubStorageIn(model, DetailProductID, DetailSendCount, DetailUsedUnitID, DetailUsedUnitCount, DetailUsedPrice, DetailExRate, DetailBatchNo, length, no, htExtAttr); if (!succ) { logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } else { logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } LogDBHelper.InsertLog(logModel); return(succ); } catch (System.Exception ex) { throw ex; } }
public static bool InsertSubStorageIn(SubStorageInModel model, string DetailProductID, string DetailSendCount, string DetailUsedUnitID, string DetailUsedUnitCount, string DetailUsedPrice, string DetailExRate, string DetailBatchNo, string length, out string ID, Hashtable htExtAttr) { try { bool succ = false; LogInfoModel logModel = InitLogInfo(model.InNo); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //设置模块ID 模块ID请在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINIT; succ = SubStorageDBHelper.InsertSubStorageIn(model, DetailProductID, DetailSendCount, DetailUsedUnitID, DetailUsedUnitCount, DetailUsedPrice, DetailExRate, DetailBatchNo, length, out ID, htExtAttr); if (!succ) { logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } else { logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } LogDBHelper.InsertLog(logModel); return(succ); } catch (System.Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { CompanyCD = UserInfo.CompanyCD; this.txtIndentityID.Value = this.intMasterSubStorageInID.ToString(); if (!Page.IsPostBack) { // 批次 BatchRuleControl1.CodingType = ConstUtil.CODING_RULE_TYPE_ZERO; BatchRuleControl1.ItemTypeID = ConstUtil.CODING_RULE_BATCH_NO; hidModuleID.Value = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINITLIST; UserID.Value = UserInfo.EmployeeID.ToString(); UserName.Value = UserInfo.EmployeeName; SystemTime.Value = DateTime.Now.ToString("yyyy-MM-dd"); txtCreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); txtModifiedDate.Text = DateTime.Now.ToString("yyyy-MM-dd"); txtCreator.Value = UserInfo.EmployeeID.ToString(); UserInfoUtil userInfo = UserInfo; usernametemp.Value = userInfo.UserName; txtCreatorReal.Value = userInfo.EmployeeName; datetemp.Value = DateTime.Now.ToString("yyyy-MM-dd"); txtCreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); txtModifiedUserID.Value = UserInfo.UserID.ToString(); txtModifiedUserIDReal.Value = UserInfo.UserID.ToString(); txtModifiedDate2.Value = DateTime.Now.ToString("yyyy-MM-dd"); txtModifiedUserID2.Value = UserInfo.UserID.ToString(); DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(UserInfo.DeptID.ToString()); if (dt != null) { HidDeptID.Value = dt["ID"].ToString(); HidDeptID2.Value = dt["ID"].ToString(); txtDeptName.Text = dt["DeptName"].ToString(); } btnGetGoods.Visible = userInfo.IsBarCode; unbtnGetGoods.Visible = userInfo.IsBarCode; #region 门店入库单单据规则 CodingRuleControl1.CodingType = ConstUtil.CODING_RULE_SUBSTORE; CodingRuleControl1.ItemTypeID = ConstUtil.CODING_RULE_SUBSTORE_SUBSTORAGEIN; #endregion if (userInfo.IsMoreUnit) { txtIsMoreUnit.Value = "1"; BasicUnitTd.Visible = true; BasicNumTd.Visible = true; } else { txtIsMoreUnit.Value = "0"; BasicUnitTd.Visible = false; BasicNumTd.Visible = false; } } //小数点位数 hidSelPoint.Value = UserInfo.SelPoint; }
/// <summary> /// 门店销售数量产品分析-导出明细 /// </summary> /// <param name="CompanyCD"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="DeptID"></param> /// <param name="OrderBy"></param> /// <returns></returns> public static DataTable GetSubSellListByProduct(string CompanyCD, string BeginDate, string EndDate, string ProductID, string DeptID) { SqlCommand comm = SubStorageDBHelper.GetSubSellInfoByProduct(CompanyCD, BeginDate, EndDate, ProductID, DeptID); //执行查询 return(SqlHelper.ExecuteSearch(comm)); }
/// <summary> /// 门店销售数量产品分析-查看详细信息 /// </summary> /// <param name="CompanyCD"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="ProductID"></param> /// <param name="DeptID"></param> /// <param name="OrderBy"></param> /// <param name="PageIndex"></param> /// <param name="PageCount"></param> /// <param name="TotalCount"></param> /// <returns></returns> public static DataTable GetSubSellDetailByProduct(string CompanyCD, string BeginDate, string EndDate, string ProductID, string DeptID, string OrderBy, int PageIndex, int PageCount, ref int TotalCount) { SqlCommand comm = SubStorageDBHelper.GetSubSellInfoByProduct(CompanyCD, BeginDate, EndDate, ProductID, DeptID); //执行查询 return(SqlHelper.PagerWithCommand(comm, PageIndex, PageCount, OrderBy, ref TotalCount)); }
/// <summary> /// 门店销售额按部门分析-导出明细 /// </summary> /// <param name="CompanyCD"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="DeptID"></param> /// <param name="OrderBy"></param> /// <returns></returns> public static DataTable GetSubSellList(string CompanyCD, string BeginDate, string EndDate, string DeptID) { SqlCommand comm = SubStorageDBHelper.SelectSubSellOrder(CompanyCD, BeginDate, EndDate, DeptID, ""); //执行查询 return(SqlHelper.ExecuteSearch(comm)); }
protected void Page_Load(object sender, EventArgs e) { hidCompanyCD.Value = UserInfo.CompanyCD; if (!IsPostBack) { string ID = Request.QueryString["ID"]; if ((ID == "0") || (ID == "") || (ID == null)) {//新建页面 BindOrderNo(); #region 绑定销售分店 DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(UserInfo.DeptID.ToString()); if (dt != null) { hidDeptID.Value = dt["ID"].ToString(); txtDeptName.Value = dt["DeptName"].ToString(); } else { hidDeptID.Value = ""; txtDeptName.Value = ""; } #endregion BindUserInfo(); //下单日期缺省为当前日期 txtOrderDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); btnGetGoods.Visible = UserInfo.IsBarCode; unbtnGetGoods.Visible = UserInfo.IsBarCode; } if (UserInfo.IsMoreUnit) { txtIsMoreUnit.Value = "1"; BasicUnitTd.Visible = true; BasicNumTd.Visible = true; } else { txtIsMoreUnit.Value = "0"; BasicUnitTd.Visible = false; BasicNumTd.Visible = false; } BindCurrencyType(); BindOrderMethod(); BindTakeType(); BindPayType(); BindMoneyType(); BindCarrayType(); BindStorage(); //小数点位数 hidSelPoint.Value = UserInfo.SelPoint; } }
public static DataTable SelectStorageProduct(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string StorageID, string ProductID, string ProductName, string BatchNo) { try { return(SubStorageDBHelper.SelectStorageProduct(pageIndex, pageCount, orderBy, ref TotalCount, StorageID, ProductID, ProductName, BatchNo)); } catch (Exception ex) { throw ex; } }
public static DataTable Details(int ID, string DeptID) { try { return(SubStorageDBHelper.Details(ID, DeptID)); } catch { return(null); } }
public static DataTable SubStorageIn(int ID) { try { return(SubStorageDBHelper.SubStorageIn(ID)); } catch { return(null); } }
protected void Page_Load(object sender, EventArgs e) { userInfo = SessionUtil.Session["UserInfo"] as UserInfoUtil; // 小数位数 _selPoint = int.Parse(userInfo.SelPoint); if (!Page.IsPostBack) { DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString()); if (dt != null) { HidDeptID.Value = dt["ID"].ToString(); } } }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; SubSellCustInfoModel model = new SubSellCustInfoModel(); model.CompanyCD = companyCD; model.DeptID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString(); DataRow dt1 = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString()); if (dt1 != null) { model.DeptID = dt1["ID"].ToString(); } model.CustName = hiddenOrderCustName.Value; model.CustTel = hiddenOrderCustTel.Value; model.CustMobile = hiddenOrderCustMobile.Value; model.CustAddr = hiddenOrderCustAddr.Value; int TotalCount = 0; string myOrder = " ID asc"; if (this.hiddenOrder.Value != "0") { string[] myOrder1 = this.hiddenOrder.Value.Split('_'); if (myOrder1[1] == "a") { myOrder = myOrder1[0] + " asc "; } else { myOrder = myOrder1[0] + " desc "; } } DataTable dt = SubSellOrderBus.GetAllCustInfo(model, "out", 1, 1, myOrder, ref TotalCount); //导出标题 string headerTitle = "客户名称|客户电话|客户手机号|客户地址"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "CustName|CustTel|CustMobile|CustAddr"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "分店客户列表"); }
/// <summary> /// 门店销售数量产品分析 /// </summary> /// <param name="Querytime"></param> /// <returns></returns> public static DataTable GetSubSellInfoByProduct(DateTime Querytime, DateTime QueryEndtime, string DepID) { if (Querytime == null) { return(null); } string strCompanyCD = string.Empty; try { strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; } catch { } return(SubStorageDBHelper.GetSubSellInfoByProduct(Querytime, QueryEndtime, strCompanyCD, DepID)); }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { string orderString = hidOrderby.Value.Trim(); //排序 string order = "DESC"; //排序:升序 string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "CreateDate"; //要排序的字段,如果为空,默认为"ID" if (orderString.EndsWith("_a")) { order = "ASC";//排序:降序 } if (string.IsNullOrEmpty(hidPageCount.Value.Trim())) { } else { int pageCount = int.Parse(hidPageCount.Value.Trim()); //每页显示记录数 int pageIndex = int.Parse(hidPageIndex.Value.Trim()); //当前页 int skipRecord = (pageIndex - 1) * pageCount; //跳过记录数 string day = txtStartPlanDate.Value.Trim(); int TotalCount = 0; UserInfoUtil user = ((UserInfoUtil)SessionUtil.Session["UserInfo"]); string _deptID = ""; DataRow dtSong = SubStorageDBHelper.GetSubDeptFromDeptID(user.DeptID.ToString()); if (dtSong != null) { _deptID = dtSong["ID"].ToString(); } orderBy = orderBy + " " + order; DataTable dt = SubDayEndBus.SelectDayInfo(pageIndex, pageCount, orderBy, ref TotalCount, day, _deptID); //导出标题 string headerTitle = "日期|物品编号|品名|规格|批次|门店|入库总数量|出库总数量|当日结存量"; string[] header = headerTitle.Split('|'); //导出标题所对应的列字段名称 string columnFiled = "DailyDate|ProductNo|ProductName|Specification|BatchNo|DeptName|InTotal|OutTotal|TodayCount"; string[] field = columnFiled.Split('|'); XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "库存日结列表"); } }
/// <summary> /// 根据销售时间,产品编号生成报表(打印) /// </summary> /// <param name="Querytime"></param> /// <param name="strCompanyCD"></param> /// <param name="ProID"></param> /// <returns></returns> public static DataTable GetSubProductSellInfo(DateTime Querytime, DateTime Endtime, string proid, string ordercolumn, string ordertype) { if (Querytime == null) { return(null); } string strCompanyCD = string.Empty; try { strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; } catch { strCompanyCD = "AAAAAA"; } return(SubStorageDBHelper.GetSubProductSellInfo(Querytime, Endtime, strCompanyCD, proid, ordercolumn, ordertype)); }
/// <summary> /// 收款员业务明细(打印) /// </summary> /// <param name="?"></param> /// <returns></returns> public static DataTable GetSellerBusDetail(DateTime Querytime, DateTime Endtime, string Dept, string Seller, string ordercolumn, string ordertype) { if (Querytime == null) { return(null); } string strCompanyCD = string.Empty; try { strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; } catch { strCompanyCD = "AAAAAA"; } return(SubStorageDBHelper.GetSellerBusDetail(Querytime, Endtime, strCompanyCD, Dept, Seller, ordercolumn, ordertype)); }
/// <summary> /// 收款员业务明细(查询) /// </summary> /// <param name="?"></param> /// <returns></returns> public static DataTable GetSellerBusDetail(DateTime Querytime, DateTime Endtime, string Dept, string Seller, int pageIndex, int pageCount, string OrderBy, ref int totalCount) { if (Querytime == null) { return(null); } string strCompanyCD = string.Empty; try { strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; } catch { strCompanyCD = "AAAAAA"; } return(SubStorageDBHelper.GetSellerBusDetail(Querytime, Endtime, strCompanyCD, Dept, Seller, pageIndex, pageCount, OrderBy, ref totalCount)); }
protected void Page_Load(object sender, EventArgs e) { this.GetBillExAttrControl1.TableName = "officedba.SubSellOrder"; if (!IsPostBack) { DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString()); if (dt != null) { hidDeptID.Value = dt["ID"].ToString(); DeptName.Value = dt["DeptName"].ToString(); } else { hidDeptID.Value = "0"; DeptName.Value = ""; } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //分店期初库存录入模块ID hidModuleID.Value = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINIT; UserInfoUtil userInfo = ((UserInfoUtil)SessionUtil.Session["UserInfo"]); //HidDeptID.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString(); DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString()); if (dt != null) { HidDeptID.Value = dt["ID"].ToString(); } } this.GetBillExAttrControl1.TableName = "officedba.SubStorageIn"; //小数点位数 hidSelPoint.Value = UserInfo.SelPoint; }
public static bool DeleteSubStorageIn(string IDs, string InNos, string CompanyCD) { var BIANHAO = InNos.Replace("'", "");//此方法当编号规则里不存在'时可以 LogInfoModel logModel = InitLogInfo(BIANHAO); logModel.Element = ConstUtil.LOG_PROCESS_DELETE; //设置模块ID 模块ID请在ConstUtil中定义,以便维护 logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINITLIST; ArrayList lstDelete = new ArrayList(); SqlCommand deletePri = SubStorageDBHelper.DeleteSubStorageIn(IDs); lstDelete.Add(deletePri); SqlCommand deleteDeteil = SubStorageDBHelper.DeleteSubStorageInDetail(InNos, CompanyCD); lstDelete.Add(deleteDeteil); bool isSucc = SqlHelper.ExecuteTransWithArrayList(lstDelete); string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; logModel.Remark = remark; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; logModel.Remark = remark; } LogDBHelper.InsertLog(logModel); return(isSucc); }
/// <summary> /// 批量导入数据 /// </summary> /// <param name="dt">数据集</param> /// <param name="userInfo">登录信息</param> /// <returns></returns> public static bool ImportData(DataTable dt, UserInfoUtil userInfo) { return(SubStorageDBHelper.ImportData(dt, userInfo)); }
/// <summary> /// 门店销数量走势-导出 /// </summary> /// <param name="CompanyCD"></param> /// <param name="Method"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="DeptID"></param> /// <param name="OrderBy"></param> /// <param name="XValue"></param> /// <returns></returns> public static DataTable GetSubSellCountTenDetailOut(string CompanyCD, string Method, string BeginDate, string EndDate, string DeptID, string OrderBy, string XValue) { SqlCommand comm = SubStorageDBHelper.GetSubSellCountTenDetail(CompanyCD, Method, BeginDate, EndDate, DeptID, OrderBy, XValue); return(SqlHelper.ExecuteSearch(comm)); }
/// <summary> /// 门店销数量走势-查看明细 /// </summary> /// <param name="CompanyCD"></param> /// <param name="Method"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="DeptID"></param> /// <param name="OrderBy"></param> /// <param name="XValue"></param> /// <returns></returns> public static DataTable GetSubSellCountTenDetail(string CompanyCD, string Method, string BeginDate, string EndDate, string DeptID, string OrderBy, string XValue, int PageIndex, int PageCount, ref int TotalCount) { SqlCommand comm = SubStorageDBHelper.GetSubSellCountTenDetail(CompanyCD, Method, BeginDate, EndDate, DeptID, OrderBy, XValue); return(SqlHelper.PagerWithCommand(comm, PageIndex, PageCount, OrderBy, ref TotalCount)); }
/// <summary> /// 门店销数量走势 /// </summary> /// <param name="CompanyCD"></param> /// <param name="Method"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="DeptID"></param> /// <returns></returns> public static DataTable GetSubSellCountTen(string CompanyCD, string Method, string BeginDate, string EndDate, string DeptID) { return(SubStorageDBHelper.GetSubSellCountTen(CompanyCD, Method, BeginDate, EndDate, DeptID)); }
protected void LoadPrintInfo() { PrintParameterSettingModel pModel = new PrintParameterSettingModel(); pModel.CompanyCD = UserInfo.CompanyCD; pModel.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SUBSTORAGE); pModel.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SUBSTORAGEIN; /*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/ string[,] aBase = { { "{ExtField1}", "ExtField1" }, { "{ExtField2}", "ExtField2" }, { "{ExtField3}", "ExtField3" }, { "{ExtField4}", "ExtField4" }, { "{ExtField5}", "ExtField5" }, { "{ExtField6}", "ExtField6" }, { "{ExtField7}", "ExtField7" }, { "{ExtField8}", "ExtField8" }, { "{ExtField9}", "ExtField9" }, { "{ExtField10}", "ExtField10" }, { "入库单编号", "InNo" }, { "入库单主题", "Title" }, { "分店名称", "DeptName" }, { "制单人", "CreatorName" }, { "制单日期", "CreateDate" }, { "单据状态", "BillStatusName" }, { "确认人", "ConfirmorName" }, { "确认日期", "ConfirmDate" }, { "最后更新人", "ModifiedUserID" }, { "最后更新日期", "ModifiedDate" }, { "备注", "Remark" }, }; string[,] aDetail = { { "序号", "SortNo" }, { "物品编号", "ProductNo" }, { "物品名称", "ProductName" }, { "批次", "BatchNo" }, { "规格", "standard" }, { "单位", "UnitName" }, { "入库数量", "SendCount" } }; if (_isMoreUnit) {// 启用多计量单位 aDetail = new string[, ] { { "序号", "SortNo" }, { "物品编号", "ProductNo" }, { "物品名称", "ProductName" }, { "批次", "BatchNo" }, { "规格", "standard" }, { "基本单位", "UnitName" }, { "基本数量", "SendCount" }, { "单位", "UsedUnitName" }, { "入库数量", "UsedUnitCount" } }; } #region 扩展属性 DataTable dtExtTable = TableExtFieldsBus.GetAllList(UserInfo.CompanyCD, "", "officedba.SubStorageIn"); int countExt = 0; for (int i = 0; i < dtExtTable.Rows.Count; i++) { aBase[i, 0] = dtExtTable.Rows[i]["EFDesc"].ToString(); countExt++; } #endregion DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(pModel); DataTable dt = SubStorageBus.SubStorageIn(intID); string deptID = UserInfo.DeptID.ToString(); DataRow dtDeptID = SubStorageDBHelper.GetSubDeptFromDeptID(UserInfo.DeptID.ToString()); if (dtDeptID != null) { deptID = dtDeptID["ID"].ToString(); } DataTable dtDetail = SubStorageBus.Details(intID, deptID); dtDetail.Columns.Add("SortNo", typeof(string)); for (int i = 0; i < dtDetail.Rows.Count; i++) { dtDetail.Rows[i]["SortNo"] = i + 1; } string strBaseFields = ""; string strDetailFields = ""; if (dbPrint.Rows.Count > 0) { isSeted.Value = "1"; strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString(); strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString(); } else { isSeted.Value = "0"; strBaseFields = GetDefaultFields(aBase); /*基本信息字段+扩展信息字段*/ if (countExt > 0) { for (int i = 0; i < countExt; i++) { strBaseFields += "|ExtField" + (i + 1); } } strDetailFields = GetDefaultFields(aDetail); } #region 主表信息 if (!string.IsNullOrEmpty(strBaseFields)) { tableBase.InnerHtml = WritePrintPageTable("分店期初库存", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, true); } #endregion #region 明细信息 if (!string.IsNullOrEmpty(strDetailFields)) { tableDetail.InnerHtml = WritePrintPageTable("分店期初库存", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, false); } #endregion }
protected void Page_Load(object sender, EventArgs e) { this.txtIndentityID.Value = this.intMasterSubSellBackID.ToString(); CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; if (!Page.IsPostBack) { hidModuleID.Value = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSELLBACKLIST; BinddrpCurrencyType(); //绑定币种 BinddrpStorageID(); //绑定仓库 UserInfoUtil userInfo = ((UserInfoUtil)SessionUtil.Session["UserInfo"]); hidCompanyCD.Value = userInfo.CompanyCD; UserID.Value = userInfo.EmployeeID.ToString(); UserName.Value = userInfo.EmployeeName; SystemTime.Value = DateTime.Now.ToString("yyyy-MM-dd"); SystemTime2.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); txtCreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); txtCreator.Value = userInfo.EmployeeID.ToString(); usernametemp.Value = userInfo.UserName; txtCreatorReal.Value = userInfo.EmployeeName; datetemp.Value = DateTime.Now.ToString("yyyy-MM-dd"); txtCreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); txtModifiedDate.Text = DateTime.Now.ToString("yyyy-MM-dd"); txtModifiedDate2.Value = DateTime.Now.ToString("yyyy-MM-dd"); txtModifiedUserID2.Value = userInfo.UserID.ToString(); txtModifiedUserID.Value = userInfo.UserID.ToString(); txtModifiedUserIDReal.Value = userInfo.UserID.ToString(); DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(userInfo.DeptID.ToString()); if (dt != null) { HidDeptID.Value = dt["ID"].ToString(); HidDeptID2.Value = dt["ID"].ToString(); txtDeptName.Text = dt["DeptName"].ToString(); } //计量单位 if (UserInfo.IsMoreUnit) { txtIsMoreUnit.Value = "1"; BasicUnitTd.Visible = true; BasicNumTd.Visible = true; } else { txtIsMoreUnit.Value = "0"; BasicUnitTd.Visible = false; BasicNumTd.Visible = false; } btnGetGoods.Visible = userInfo.IsBarCode; unbtnGetGoods.Visible = userInfo.IsBarCode; //小数点位数 hidSelPoint.Value = UserInfo.SelPoint; #region 门店销售退货单据规则 CodingRuleControl1.CodingType = ConstUtil.CODING_RULE_SUBSTORE; CodingRuleControl1.ItemTypeID = ConstUtil.CODING_RULE_SUBSTORE_SUBSELLBACK; usernametemp.Value = userInfo.UserName; datetemp.Value = DateTime.Now.ToString("yyyy-MM-dd"); #endregion } }
/// <summary> /// 绑定门店仓库 /// </summary> /// <returns>DataTable</returns> public static DataTable GetdrpStorageName() { DataTable dt = SubStorageDBHelper.GetdrpStorageName(); return(dt); }