protected void LoadPrintInfo() { PrintParameterSettingModel model = new PrintParameterSettingModel(); model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SUBSTORAGE); model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SUBSTORAGECUST; SubSellCustInfoModel modelCust = new SubSellCustInfoModel(); modelCust.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; modelCust.ID = this.intCustID.ToString(); #region 1.初始化 取基本信息及明细信息的字段以及对应的标题 /*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/ string[,] aBase = { { "客户名称", "CustName" }, { "客户联系电话", "CustTel" }, { "客户手机号", "CustMobile" }, { "客户地址", "CustAddr" }, }; #endregion #region 2.所设的打印模板设置 DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model); DataTable dtCust = SubSellOrderBus.GetOneData(this.intCustID); string strBaseFields = ""; if (dbPrint.Rows.Count > 0) { #region 设置过打印模板设置时 直接取出表里设置的值 isSeted.Value = "1"; strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString(); #endregion } else { #region 未设置过打印模板设置 默认显示所有的 isSeted.Value = "0"; /*未设置过打印模板设置时,默认显示的字段 基本信息字段*/ for (int m = 0; m < aBase.Length / 2; m++) { strBaseFields = strBaseFields + aBase[m, 1] + "|"; } #endregion /*两种都可以*/ } #endregion #region 3.输出主表信息 if (!string.IsNullOrEmpty(strBaseFields)) { tableBase.InnerHtml = WritePrintPageTable("客户", strBaseFields.TrimEnd('|'), "", aBase, aBase, dtCust, dtCust, true); } #endregion }
/// <summary> /// 添加分店客户 /// </summary> /// <param name="model"></param> /// <returns></returns> public static bool SubStorageCustAdd(SubSellCustInfoModel model) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; try { bool result = false; LogInfoModel logModel = InitLogInfo(model.CustName); logModel.Element = ConstUtil.LOG_PROCESS_INSERT; result = SubSellOrderDBHelper.SubStorageCustAdd(model); if (!result) { logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } else { logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; model.ID = IDIdentityUtil.GetIDIdentity("officedba.SubSellCustInfo").ToString(); } LogDBHelper.InsertLog(logModel); return(result); } catch (Exception ex) { WriteSystemLog(userInfo, ex); return(false); } }
public static DataTable GetCustInfo(SubSellCustInfoModel SubSellCustInfoM) { try { SqlCommand comm = SubSellOrderDBHelper.GetCustInfo(SubSellCustInfoM); return(SqlHelper.ExecuteSearch(comm)); } catch (Exception ex) { throw ex; } }
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, "分店客户列表"); }
public static bool UpdateCust(SubSellCustInfoModel model) { return(SubSellOrderDBHelper.UpdateCust(model)); }
/// <summary> /// 检索客户 /// </summary> /// <param name="model"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="OrderBy"></param> /// <param name="TotalCount"></param> /// <returns></returns> public static DataTable GetAllCustInfo(SubSellCustInfoModel model, string Method, int pageIndex, int pageSize, string OrderBy, ref int TotalCount) { return(SubSellOrderDBHelper.GetAllCust(model, Method, pageIndex, pageSize, OrderBy, ref TotalCount)); }
//需要插入客户 public static bool ConfirmSubSellOrder(string ID, string No, SubSellCustInfoModel SubSellCustInfoM) { ArrayList lstConfirm = new ArrayList(); //单据确认人,确认时间,单据状态,业务状态 SqlCommand Confirm = SubSellOrderDBHelper.ConfirmSubSellOrder(ID); lstConfirm.Add(Confirm); //新增客户信息 SqlCommand AddCust = SubSellOrderDBHelper.InsertCustInfo(SubSellCustInfoM); lstConfirm.Add(AddCust); //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; /* * 定义日志内容变量 * 增删改相关的日志,需要输出操作日志,该类型日志插入到数据库 * 其他的 如出现异常时,需要输出系统日志,该类型日志保存到日志文件 */ //执行插入操作 try { isSucc = SqlHelper.ExecuteTransWithArrayList(lstConfirm); } catch (Exception ex) { //输出日志 WriteSystemLog(userInfo, ex); } //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } LogInfoModel logModel = InitLogInfo(No); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_CONFIRM; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return(isSucc); }