/// 获取经销商信息 /// <summary> /// 获取经销商信息 /// </summary> /// <param name="msg"></param> /// <param name="data"></param> /// <returns></returns> private bool GetDealerInfo(out string msg, out string data) { msg = ""; data = ""; Dictionary <string, string> dic = new Dictionary <string, string>(); //查询客户信息 int totalCount; DataTable dt = BLL.DealerInfo.Instance.GetMemberInfo("", MemberCode.Trim(), "", "", 1, 1, out totalCount); if (dt != null && dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; dic.Add("name", "'" + dr["name"].ToString() + "'"); dic.Add("CustID", "'" + dr["CustID"].ToString() + "'"); dic.Add("CustName", "'" + dr["CustName"].ToString() + "'"); dic.Add("MemberCode", "'" + dr["MemberCode"].ToString() + "'"); } else { dic.Add("name", "''"); dic.Add("CustID", "''"); dic.Add("CustName", "''"); dic.Add("MemberCode", "''"); } //转json data = BLL.Util.DictionaryToJson(dic); return(true); }
private void DataBinds() { if (!string.IsNullOrEmpty(MemberName.Trim()) || !string.IsNullOrEmpty(CustId.Trim()) || !string.IsNullOrEmpty(MemberCode.Trim())) { DataTable dt = null; int totalCount = 0; if (!string.IsNullOrEmpty(MemberName.Trim()) && NeedMemeberCode == "1") { dt = BLL.DealerInfo.Instance.GetMemberInfo(MemberName.Trim(), "", CustId.Trim(), "", PageCommon.Instance.PageIndex, PageSize, out totalCount); } else { dt = BLL.DealerInfo.Instance.GetMemberInfo(MemberName.Trim(), MemberCode.Trim(), CustId.Trim(), "", PageCommon.Instance.PageIndex, PageSize, out totalCount); } if (dt != null && dt.Rows.Count > 0) { try { repterFriendCustMappingList.DataSource = dt; repterFriendCustMappingList.DataBind(); } catch (Exception ex) { BLL.Loger.Log4Net.Error(ex.StackTrace); } } litPagerDown.Text = PageCommon.Instance.LinkStringByPost(GetWhere(), GroupLength, totalCount, PageSize, PageCommon.Instance.PageIndex, 1); } }
public bool SameAs(XRoadService service) { return(XRoadInstance.Equals(service.XRoadInstance) && MemberClass.Equals(service.MemberClass) && MemberCode.Equals(service.MemberCode) && ServiceCode.Equals(service.ServiceCode) && string.Equals(SubsystemCode, service.SubsystemCode) && string.Equals(ServiceVersion, service.ServiceVersion)); }
public Result Find(int docNum) { Action find = delegate { var sqlBuilder = new StringBuilder(); sqlBuilder.AppendFormat("SELECT * FROM `OR` WHERE DOC_NUM = ?DOC_NUM"); var sqlParam = new SqlParameter("?DOC_NUM", docNum); DataTable result = DatabaseController.ExecuteSelectQuery(sqlBuilder.ToString(), sqlParam); ResetProperties(); VoucherNumber = docNum; string cashOnHandCode = GlobalSettings.CodeOfCashOnHand; string timeDepositCode = GlobalSettings.CodeOfTimeDeposit; int index = 0; foreach (DataRow dataRow in result.Rows) { if (index == 0) { VoucherDate = DataConverter.ToDateTime(dataRow["DOC_DATE"]); MemberCode = DataConverter.ToString(dataRow["MEM_CODE"]); IsCancelled = MemberCode.ToUpper().Contains("CANCEL"); CollectorName = DataConverter.ToString(dataRow["COLLECTOR"]); } index++; string accountCode = DataConverter.ToString(dataRow["ACC_CODE"]); decimal credit = DataConverter.ToDecimal(dataRow["CREDIT"]); if (accountCode != cashOnHandCode) { SetAccountCode(index, accountCode); SetCreditAmount(index, credit); if (accountCode == timeDepositCode) { TimeDepositDetail = TimeDepositDetails.ExtractFromDataRow(dataRow); } } else { CashAndCheckDenomimation = CashAndCheckBreakDown.ExtractFromDataRow(dataRow); } } //UpdateTotalAmount(); }; return(ActionController.InvokeAction(find)); }
private void btnMemberAdd_Click(object sender, System.EventArgs e) { try { if (cmbMember.SelectedItem == null) { throw new BusinessException("会员参数设置", "请选择会员类型"); } if (cmbMemberType.SelectedItem == null) { throw new BusinessException("会员参数设置", "请选择参数类型"); } string strSql = "select * from tbMemberCode where cnvcMemberName ='" + cmbMember.Text + "' and cnvcMemberType='" + cmbMemberType.Text + "'"; DataTable dtMemberCode = Helper.Query(strSql); if (dtMemberCode.Rows.Count > 0) { throw new BusinessException("会员参数设置", "【会员类型+参数类型】已存在"); } if (txtMemberValue.Text.Trim().Length == 0) { throw new BusinessException("会员参数设置", "请输入参数值"); } if (!(txtMemberValue.Text.Equals(ConstApp.Free_Time_NoLimit) || txtMemberValue.Text.Equals(ConstApp.YesNo_No) || txtMemberValue.Text.Equals(ConstApp.YesNo_Yes))) { int.Parse(txtMemberValue.Text); if (int.Parse(txtMemberValue.Text) < 0) { throw new BusinessException("会员参数设置", "请输入正数"); } } MemberCode memberCode = new MemberCode(); memberCode.cnvcMemberName = cmbMember.Text; memberCode.cnvcMemberType = cmbMemberType.Text; memberCode.cnvcMemberValue = txtMemberValue.Text; MemberManageFacade memberManage = new MemberManageFacade(); memberManage.AddMemberCode(memberCode); MessageBox.Show(this, "会员参数添加成功!", "会员参数设置", MessageBoxButtons.OK, MessageBoxIcon.Information); cmbMember_ValueChanged(null, null); ynhrMemberManage.BusinessFacade.SysInit.LoadPara(Login.constApp); } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message + "\n参数异常,请核查", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btnMemberDelete_Click(object sender, System.EventArgs e) { try { DialogResult strRet = MessageBox.Show(this, "是否删除?", "会员参数设置", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (strRet == DialogResult.Yes) { UltraGridRow row = this.ultraGrid2.ActiveRow; if (null == row) { throw new BusinessException("会员参数设置", "请选择会员参数"); } if (cmbMember.SelectedItem == null) { throw new BusinessException("会员参数设置", "请选择会员类型"); } if (cmbMemberType.SelectedItem == null) { throw new BusinessException("会员参数设置", "请选择参数类型"); } string strSql = "select * from tbMemberCode where cnvcMemberName ='" + cmbMember.Text + "' and cnvcMemberType='" + cmbMemberType.Text + "'"; DataTable dtMemberCode = Helper.Query(strSql); if (dtMemberCode.Rows.Count == 0) { throw new BusinessException("会员参数设置", "【会员类型+参数类型】不存在"); } MemberCode memberCode = new MemberCode(); memberCode.cnnMemberCodeID = int.Parse(row.Cells["cnnMemberCodeID"].Value.ToString()); MemberManageFacade memberManage = new MemberManageFacade(); memberManage.DeleteMemberCode(memberCode); MessageBox.Show(this, "会员参数删除成功!", "会员参数设置", MessageBoxButtons.OK, MessageBoxIcon.Information); cmbMember_ValueChanged(null, null); ynhrMemberManage.BusinessFacade.SysInit.LoadPara(Login.constApp); } } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message, "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private string GetWhere() { string where = ""; string query = Request.Url.Query; if ((!MemberName.Equals("")) || MemberName != null) { where += "&MemberName=" + BLL.Util.EscapeString(MemberName); } if ((!MemberCode.Equals("")) || MemberCode != null) { where += "&MemberCode=" + BLL.Util.EscapeString(MemberCode); } if ((!CustId.Equals("")) || CustId != null) { where += "&CustId=" + BLL.Util.EscapeString(CustId); } where += "&nmc=1&random=" + (new Random()).Next().ToString(); return(where); }
public static void LoadPara(ConstApp ca) { ca.dtNameCode = SqlHelper.ExecuteDataTable(CommandType.Text, "select * from tbNameCode"); ca.dtMemberCode = SqlHelper.ExecuteDataTable(CommandType.Text, "select * from tbMemberCode"); ca.alMemberType.Clear(); ca.alEnterpriseType.Clear(); ca.alProduct.Clear(); ca.alTrade.Clear(); ca.alInMoneyDiscount.Clear(); DataRow[] drMemberTypes = ca.dtNameCode.Select("cnvcType='" + ConstApp.MemberType + "'"); foreach (DataRow drMemberType in drMemberTypes) { NameCode nameCode = new NameCode(drMemberType); ca.alMemberType.Add(nameCode.cnvcValue); } DataRow[] drEnterpriseTypes = ca.dtNameCode.Select("cnvcType='" + ConstApp.EnterpriseType + "'"); foreach (DataRow drEnterpriseType in drEnterpriseTypes) { NameCode nameCode = new NameCode(drEnterpriseType); ca.alEnterpriseType.Add(nameCode.cnvcValue); } DataRow[] drProducts = ca.dtNameCode.Select("cnvcType='" + ConstApp.Product + "'"); foreach (DataRow drProduct in drProducts) { NameCode nameCode = new NameCode(drProduct); ca.alProduct.Add(nameCode.cnvcValue); } DataRow[] drTrades = ca.dtNameCode.Select("cnvcType='" + ConstApp.Trade + "'"); foreach (DataRow drTrade in drTrades) { NameCode nameCode = new NameCode(drTrade); ca.alTrade.Add(nameCode.cnvcValue); } //ЁДж╣уш©ш DataRow[] drInMoneyDiscounts = ca.dtNameCode.Select("cnvcType='" + ConstApp.InMoneyDiscount + "'"); foreach (DataRow drInMoneyDiscount in drInMoneyDiscounts) { NameCode nameCode = new NameCode(drInMoneyDiscount); ca.alInMoneyDiscount.Add(nameCode.cnvcValue); } DataRow[] drJobBookDates = ca.dtNameCode.Select("cnvcType='" + ConstApp.BookDate + "'"); if (drJobBookDates.Length > 0) { NameCode nameCode = new NameCode(drJobBookDates[0]); ca.iBookDate = int.Parse(nameCode.cnvcValue); } DataRow[] drTishis = ca.dtNameCode.Select("cnvcType='" + ConstApp.tishi + "'"); if (drTishis.Length > 0) { NameCode nameCode = new NameCode(drTishis[0]); ca.iTishi = int.Parse(nameCode.cnvcValue); } DataRow[] drTouchFlash = ca.dtNameCode.Select("cnvcType='" + ConstApp.TouchFlash + "'"); if (drTouchFlash.Length > 0) { NameCode nameCode = new NameCode(drTouchFlash[0]); ca.iTouchFlash = int.Parse(nameCode.cnvcValue); } DataRow[] drTouchBookBeginDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.TouchBookBeginDate + "'"); if (drTouchBookBeginDate.Length > 0) { NameCode nameCode = new NameCode(drTouchBookBeginDate[0]); ca.dTouchBookBeginDate = nameCode.cnvcValue; } DataRow[] drTouchBookEndDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.TouchBookEndDate + "'"); if (drTouchBookEndDate.Length > 0) { NameCode nameCode = new NameCode(drTouchBookEndDate[0]); ca.dTouchBookEndDate = nameCode.cnvcValue; } DataRow[] drTouchSignInBeginDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.TouchSignInBeginDate + "'"); if (drTouchSignInBeginDate.Length > 0) { NameCode nameCode = new NameCode(drTouchSignInBeginDate[0]); ca.dTouchSignInBeginDate = nameCode.cnvcValue; } DataRow[] drTouchSignInEndDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.TouchSignInEndDate + "'"); if (drTouchSignInEndDate.Length > 0) { NameCode nameCode = new NameCode(drTouchSignInEndDate[0]); ca.dTouchSignInEndDate = nameCode.cnvcValue; } DataRow[] drJobBeginDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.JobListBeginDate + "'"); if (drJobBeginDate.Length > 0) { NameCode nameCode = new NameCode(drJobBeginDate[0]); ca.strJobBeginDate = nameCode.cnvcValue; } DataRow[] drJobEndDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.JobListEndDate + "'"); if (drJobEndDate.Length > 0) { NameCode nameCode = new NameCode(drJobEndDate[0]); ca.strJobEndDate = nameCode.cnvcValue; } DataRow[] drJobBookingBeginDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.JobBookingListBeginDate + "'"); if (drJobBookingBeginDate.Length > 0) { NameCode nameCode = new NameCode(drJobBookingBeginDate[0]); ca.strJobBookingBeginDate = nameCode.cnvcValue; } DataRow[] drJobBookingEndDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.JobBookingListEndDate + "'"); if (drJobBookingEndDate.Length > 0) { NameCode nameCode = new NameCode(drJobBookingEndDate[0]); ca.strJobBookingEndDate = nameCode.cnvcValue; } DataRow[] drJobRemainBeginDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.JobRemainListBeginDate + "'"); if (drJobRemainBeginDate.Length > 0) { NameCode nameCode = new NameCode(drJobRemainBeginDate[0]); ca.strJobRemainBeginDate = nameCode.cnvcValue; } DataRow[] drJobRemainEndDate = ca.dtNameCode.Select("cnvcType='" + ConstApp.JobRemainListEndDate + "'"); if (drJobRemainEndDate.Length > 0) { NameCode nameCode = new NameCode(drJobRemainEndDate[0]); ca.strJobRemainEndDate = nameCode.cnvcValue; } DataRow[] drInMoneySetting = ca.dtNameCode.Select("cnvcType='" + ConstApp.InMoneySetting + "'"); if (drInMoneySetting.Length > 0) { NameCode nameCode = new NameCode(drInMoneySetting[0]); ca.bInMoneyDonate = nameCode.cnvcValue == "1"?true:false; } DataRow[] drCardTypes = ca.dtNameCode.Select("cnvcType='" + ConstApp.CardType + "'"); if (drCardTypes.Length > 0) { NameCode nameCode = new NameCode(drCardTypes[0]); ca.strCardType = nameCode.cnvcValue; } //zhh 20140611 DataRow[] drCardTypeL6s = ca.dtNameCode.Select("cnvcType='" + ConstApp.CardType_L6 + "'"); if (drCardTypeL6s.Length > 0) { NameCode nameCode = new NameCode(drCardTypeL6s[0]); ca.strCardTypeL6Name = nameCode.cnvcValue; } DataRow[] drCardTypeL8s = ca.dtNameCode.Select("cnvcType='" + ConstApp.CardType_L8 + "'"); if (drCardTypeL8s.Length > 0) { NameCode nameCode = new NameCode(drCardTypeL8s[0]); ca.strCardTypeL8Name = nameCode.cnvcValue; } ca.htFree.Clear(); ca.htBookDate.Clear(); ca.htDisabledDate.Clear(); ca.htDisabledDateMinAmount.Clear(); ca.htMemberDiscount.Clear(); ca.htMemberSeats.Clear(); ca.htDept.Clear(); ca.htMemberFee.Clear(); DataRow[] drFreeTypes = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.FreeType + "'"); foreach (DataRow drFreeType in drFreeTypes) { MemberCode memberCode = new MemberCode(drFreeType); ca.htFree.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataRow[] drBookDates = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.BookDate + "'"); foreach (DataRow drBookDate in drBookDates) { MemberCode memberCode = new MemberCode(drBookDate); ca.htBookDate.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataRow[] drDisabledDates = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.DisabledDate + "'"); foreach (DataRow drDisabledDate in drDisabledDates) { MemberCode memberCode = new MemberCode(drDisabledDate); ca.htDisabledDate.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } //zhh 20130315 DataRow[] drDisabledDateMinAmounts = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.DisabledDateMinAmount + "'"); foreach (DataRow drDisabledDateMinAmount in drDisabledDateMinAmounts) { MemberCode memberCode = new MemberCode(drDisabledDateMinAmount); ca.htDisabledDateMinAmount.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } //end zhh 20130315 DataRow[] drMemberDiscounts = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.MemberDiscount + "'"); foreach (DataRow drMemberDiscount in drMemberDiscounts) { MemberCode memberCode = new MemberCode(drMemberDiscount); ca.htMemberDiscount.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataRow[] drMemberSeats = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.MemberSeats + "'"); foreach (DataRow drMemberSeat in drMemberSeats) { MemberCode memberCode = new MemberCode(drMemberSeat); ca.htMemberSeats.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataRow[] drMemberFees = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.MemberFee + "'"); foreach (DataRow drMemberFee in drMemberFees) { MemberCode memberCode = new MemberCode(drMemberFee); ca.htMemberFee.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataTable dtDept = SqlHelper.ExecuteDataTable(CommandType.Text, "select * from tbDept"); foreach (DataRow drDept in dtDept.Rows) { Dept dept = new Dept(drDept); ca.htDept.Add(dept.cnnDeptID, dept); } //zhh 2014-06-06 ca.htIsJob.Clear(); DataRow[] drIsJobs = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.IsJob + "'"); foreach (DataRow drIsJob in drIsJobs) { MemberCode memberCode = new MemberCode(drIsJob); ca.htIsJob.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } ca.htIsMemberFee.Clear(); DataRow[] drIsMemberFees = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.IsMemberFee + "'"); foreach (DataRow drIsMemberFee in drIsMemberFees) { MemberCode memberCode = new MemberCode(drIsMemberFee); ca.htIsMemberFee.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } ca.htIsInMoney.Clear(); DataRow[] drIsInMoneys = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.IsInMoney + "'"); foreach (DataRow drIsInMoney in drIsInMoneys) { MemberCode memberCode = new MemberCode(drIsInMoney); ca.htIsInMoney.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } ca.htIsProduct.Clear(); DataRow[] drIsProducts = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.IsProduct + "'"); foreach (DataRow drIsProduct in drIsProducts) { MemberCode memberCode = new MemberCode(drIsProduct); ca.htIsProduct.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } ca.htIsProductSelect.Clear(); DataRow[] drIsProductSelects = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.IsProductSelect + "'"); foreach (DataRow drIsProductSelect in drIsProductSelects) { MemberCode memberCode = new MemberCode(drIsProductSelect); ca.htIsProductSelect.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } ca.htIsFeeType.Clear(); DataRow[] drIsFeeTypes = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.IsFeeType + "'"); foreach (DataRow drIsFeeType in drIsFeeTypes) { MemberCode memberCode = new MemberCode(drIsFeeType); ca.htIsFeeType.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } ca.htIsDisabledDate.Clear(); DataRow[] drIsDisabledDates = ca.dtMemberCode.Select("cnvcMemberType='" + ConstApp.IsDisabledDate + "'"); foreach (DataRow drIsDisabledDate in drIsDisabledDates) { MemberCode memberCode = new MemberCode(drIsDisabledDate); ca.htIsDisabledDate.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } }
private void btnMemberModify_Click(object sender, System.EventArgs e) { try { UltraGridRow row = this.ultraGrid2.ActiveRow; if (null == row) { throw new BusinessException("会员参数设置", "请选择会员参数"); } if (cmbMember.SelectedItem == null) { throw new BusinessException("会员参数设置", "请选择会员类型"); } if (cmbMemberType.SelectedItem == null) { throw new BusinessException("会员参数设置", "请选择参数类型"); } string strType = row.Cells["cnvcMemberType"].Value.ToString(); string strValue = row.Cells["cnvcMemberValue"].Value.ToString(); if (strType != cmbMemberType.Text) { throw new BusinessException("会员参数设置", "参数类型不能修改"); } string strSql = "select * from tbMemberCode where cnvcMemberName ='" + cmbMember.Text + "' and cnvcMemberType='" + cmbMemberType.Text + "'"; DataTable dtMemberCode = Helper.Query(strSql); if (dtMemberCode.Rows.Count == 0) { throw new BusinessException("会员参数设置", "【会员类型+参数类型】不存在"); } if (txtMemberValue.Text.Trim().Length == 0) { throw new BusinessException("会员参数设置", "请输入参数值"); } if (!txtMemberValue.Text.Equals(ConstApp.Free_Time_NoLimit)) { int.Parse(txtMemberValue.Text); if (int.Parse(txtMemberValue.Text) < 0) { throw new BusinessException("会员参数设置", "请输入正数"); } if (strValue == txtMemberValue.Text) { throw new BusinessException("会员参数设置", "请修改参数值"); } } MemberCode memberCode = new MemberCode(dtMemberCode); memberCode.cnnMemberCodeID = int.Parse(row.Cells["cnnMemberCodeID"].Value.ToString()); memberCode.cnvcMemberType = cmbMemberType.Text; memberCode.cnvcMemberValue = txtMemberValue.Text; MemberManageFacade memberManage = new MemberManageFacade(); memberManage.ModifyMemberCode(memberCode); MessageBox.Show(this, "会员参数修改成功!", "会员参数设置", MessageBoxButtons.OK, MessageBoxIcon.Information); cmbMember_ValueChanged(null, null); ynhrMemberManage.BusinessFacade.SysInit.LoadPara(Login.constApp); } catch (BusinessException bex) { MessageBox.Show(this, bex.Message, bex.Type, MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (System.Exception ex) { MessageBox.Show(this, ex.Message + "\n参数异常,请核查", "系统错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public void LoadPara() { SqlConnection conn = null; //SqlTransaction trans = null; try { conn = ConnectionPool.BorrowConnection(); dtNameCode = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbNameCode"); dtMemberCode = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbMemberCode"); alMemberType.Clear(); alEnterpriseType.Clear(); alProduct.Clear(); alTrade.Clear(); DataRow[] drMemberTypes = dtNameCode.Select("cnvcType='" + MemberType + "'"); foreach (DataRow drMemberType in drMemberTypes) { NameCode nameCode = new NameCode(drMemberType); alMemberType.Add(nameCode.cnvcValue); } DataRow[] drEnterpriseTypes = dtNameCode.Select("cnvcType='" + EnterpriseType + "'"); foreach (DataRow drEnterpriseType in drEnterpriseTypes) { NameCode nameCode = new NameCode(drEnterpriseType); alEnterpriseType.Add(nameCode.cnvcValue); } DataRow[] drProducts = dtNameCode.Select("cnvcType='" + Product + "'"); foreach (DataRow drProduct in drProducts) { NameCode nameCode = new NameCode(drProduct); alProduct.Add(nameCode.cnvcValue); } DataRow[] drTrades = dtNameCode.Select("cnvcType='" + Trade + "'"); foreach (DataRow drTrade in drTrades) { NameCode nameCode = new NameCode(drTrade); alTrade.Add(nameCode.cnvcValue); } DataRow[] drJobBookDates = dtNameCode.Select("cnvcType='" + BookDate + "'"); if (drJobBookDates.Length > 0) { NameCode nameCode = new NameCode(drJobBookDates[0]); iBookDate = int.Parse(nameCode.cnvcValue); } DataRow[] drTishis = dtNameCode.Select("cnvcType='" + tishi + "'"); if (drTishis.Length > 0) { NameCode nameCode = new NameCode(drTishis[0]); iTishi = int.Parse(nameCode.cnvcValue); } DataRow[] drTouchFlash = dtNameCode.Select("cnvcType='" + TouchFlash + "'"); if (drTouchFlash.Length > 0) { NameCode nameCode = new NameCode(drTouchFlash[0]); iTouchFlash = int.Parse(nameCode.cnvcValue); } DataRow[] drTouchBookBeginDate = dtNameCode.Select("cnvcType='" + TouchBookBeginDate + "'"); if (drTouchBookBeginDate.Length > 0) { NameCode nameCode = new NameCode(drTouchBookBeginDate[0]); dTouchBookBeginDate = nameCode.cnvcValue; } DataRow[] drTouchBookEndDate = dtNameCode.Select("cnvcType='" + TouchBookEndDate + "'"); if (drTouchBookEndDate.Length > 0) { NameCode nameCode = new NameCode(drTouchBookEndDate[0]); dTouchBookEndDate = nameCode.cnvcValue; } DataRow[] drTouchSignInBeginDate = dtNameCode.Select("cnvcType='" + TouchSignInBeginDate + "'"); if (drTouchSignInBeginDate.Length > 0) { NameCode nameCode = new NameCode(drTouchSignInBeginDate[0]); dTouchSignInBeginDate = nameCode.cnvcValue; } DataRow[] drTouchSignInEndDate = dtNameCode.Select("cnvcType='" + TouchSignInEndDate + "'"); if (drTouchSignInEndDate.Length > 0) { NameCode nameCode = new NameCode(drTouchSignInEndDate[0]); dTouchSignInEndDate = nameCode.cnvcValue; } htFree.Clear(); htBookDate.Clear(); htDisabledDate.Clear(); htMemberDiscount.Clear(); htMemberSeats.Clear(); htDept.Clear(); htMemberFee.Clear(); DataRow[] drFreeTypes = dtMemberCode.Select("cnvcMemberType='" + FreeType + "'"); foreach (DataRow drFreeType in drFreeTypes) { MemberCode memberCode = new MemberCode(drFreeType); htFree.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataRow[] drBookDates = dtMemberCode.Select("cnvcMemberType='" + BookDate + "'"); foreach (DataRow drBookDate in drBookDates) { MemberCode memberCode = new MemberCode(drBookDate); htBookDate.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataRow[] drDisabledDates = dtMemberCode.Select("cnvcMemberType='" + DisabledDate + "'"); foreach (DataRow drDisabledDate in drDisabledDates) { MemberCode memberCode = new MemberCode(drDisabledDate); htDisabledDate.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataRow[] drMemberDiscounts = dtMemberCode.Select("cnvcMemberType='" + MemberDiscount + "'"); foreach (DataRow drMemberDiscount in drMemberDiscounts) { MemberCode memberCode = new MemberCode(drMemberDiscount); htMemberDiscount.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataRow[] drMemberSeats = dtMemberCode.Select("cnvcMemberType='" + MemberSeats + "'"); foreach (DataRow drMemberSeat in drMemberSeats) { MemberCode memberCode = new MemberCode(drMemberSeat); htMemberSeats.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataRow[] drMemberFees = dtMemberCode.Select("cnvcMemberType='" + MemberFee + "'"); foreach (DataRow drMemberFee in drMemberFees) { MemberCode memberCode = new MemberCode(drMemberFee); htMemberFee.Add(memberCode.cnvcMemberName, memberCode.cnvcMemberValue); } DataTable dtDept = SqlHelper.ExecuteDataTable(conn, CommandType.Text, "select * from tbDept"); foreach (DataRow drDept in dtDept.Rows) { Dept dept = new Dept(drDept); htDept.Add(dept.cnnDeptID, dept); } } catch (BusinessException bex) //业务异常 { //事务回滚 //trans.Rollback(); //LogAdapter.WriteBusinessException(bex); throw new BusinessException(bex.Type, bex.Message); } catch (SqlException sex) //数据库异常 { //事务回滚 //trans.Rollback(); //LogAdapter.WriteDatabaseException(sex); throw new BusinessException("数据库异常", sex.Message); } catch (Exception ex) //其他异常 { //事务回滚 //trans.Rollback(); //LogAdapter.WriteFeaturesException(ex); throw new BusinessException("其它异常", ex.Message); } finally { ConnectionPool.ReturnConnection(conn); } }