/// 获取经销商信息
/// <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);
}
}
