public static void BindNameCodeType(UltraComboEditor cmbType)
{
ArrayList alMemberCode = new ArrayList();
alMemberCode.Add(ConstApp.MemberType);
alMemberCode.Add(ConstApp.EnterpriseType);
alMemberCode.Add(ConstApp.BookDate);
alMemberCode.Add(ConstApp.Trade);
alMemberCode.Add(ConstApp.Product);
//alMemberCode.Add(ConstApp.ValueAddedServices);
alMemberCode.Add(ConstApp.tishi);
alMemberCode.Add(ConstApp.TouchFlash);
alMemberCode.Add(ConstApp.TouchBookBeginDate);
alMemberCode.Add(ConstApp.TouchBookEndDate);
alMemberCode.Add(ConstApp.TouchSignInBeginDate);
alMemberCode.Add(ConstApp.TouchSignInEndDate);
alMemberCode.Add(ConstApp.JobListBeginDate);
alMemberCode.Add(ConstApp.JobListEndDate);
alMemberCode.Add(ConstApp.JobBookingListBeginDate);
alMemberCode.Add(ConstApp.JobBookingListEndDate);
alMemberCode.Add(ConstApp.JobRemainListBeginDate);
alMemberCode.Add(ConstApp.JobRemainListEndDate);
alMemberCode.Add(ConstApp.NetBookBeforeDate);
//alMemberCode.Add(ConstApp.CardType);
cmbType.SetDataBinding(alMemberCode, null);
}
public static void BindMember(UltraComboEditor cmbMember)
{
ArrayList alMember = new ArrayList();
alMember.Add("会员");
alMember.Add("非会员");
cmbMember.SetDataBinding(alMember, null);
}
/// <summary>
/// 绑定会员参数类型
/// </summary>
/// <param name="cmbMemberCode"></param>
public static void BindMemberCode(UltraComboEditor cmbMemberCode, string strMember)
{
ArrayList alMemberCode = new ArrayList();
if (strMember == ConstApp.MemberType)
{
alMemberCode.Add(ConstApp.FreeType);
alMemberCode.Add(ConstApp.BookDate);
alMemberCode.Add(ConstApp.DisabledDate);
alMemberCode.Add(ConstApp.DisabledDateMinAmount);
alMemberCode.Add(ConstApp.MemberDiscount);
alMemberCode.Add(ConstApp.MemberSeats);
alMemberCode.Add(ConstApp.MemberFee);
alMemberCode.Add(ConstApp.BookTimes);
alMemberCode.Add(ConstApp.PointsBK);
alMemberCode.Add(ConstApp.PointsCZ);
alMemberCode.Add(ConstApp.PointsXF);
alMemberCode.Add(ConstApp.PointsJF);
alMemberCode.Add(ConstApp.IsJob);
alMemberCode.Add(ConstApp.IsMemberFee);
alMemberCode.Add(ConstApp.IsInMoney);
alMemberCode.Add(ConstApp.IsProduct);
alMemberCode.Add(ConstApp.IsProductSelect);
alMemberCode.Add(ConstApp.IsFeeType);
alMemberCode.Add(ConstApp.IsDisabledDate);
DataTable dtProduct = Query("select * from tbNameCode where cnvcType = '" + ConstApp.Product + "' order by cnvcValue");
foreach (DataRow drProduct in dtProduct.Rows)
{
NameCode namceCode = new NameCode(drProduct);
if (!alMemberCode.Contains(namceCode.cnvcValue))
{
alMemberCode.Add(namceCode.cnvcValue);
}
}
//DataTable dtProduct = Query("select * from tbNameCode where cnvcType = '" + ConstApp.ValueAddedServices + "' order by cnvcValue");
//foreach (DataRow drProduct in dtProduct.Rows)
//{
// NameCode namceCode = new NameCode(drProduct);
// if (!alMemberCode.Contains(namceCode.cnvcValue))
// {
// alMemberCode.Add(namceCode.cnvcValue);
// }
//}
}
if (strMember == ConstApp.Product)
{
alMemberCode.Add(ConstApp.ProductPrice);
alMemberCode.Add(ConstApp.ProductDiscount);
alMemberCode.Add(ConstApp.ProductPoints);
}
cmbMemberCode.SetDataBinding(alMemberCode, null);
}
public static void BindSales(UltraComboEditor cmbSales)
{
string strsql = "select cnvcSales from tbSales ";
DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, strsql);
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
al.Add(dr[0]);
}
cmbSales.SetDataBinding(al, null);
}
public static void BindSales(UltraComboEditor cmbSales, string strOperId)
{
string strsql = string.Format(@"select a.cnvcSales from tbSales a
join tbOperDept b on a.cnnDeptID=b.cnnDeptID
where b.cnnOperID={0}", strOperId);
DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, strsql);
ArrayList al = new ArrayList();
foreach (DataRow dr in dt.Rows)
{
al.Add(dr[0]);
}
cmbSales.SetDataBinding(al, null);
}
public static void BindNameCodeProductType(UltraComboEditor cmbType)
{
ArrayList alMemberCode = new ArrayList();
//alMemberCode.Add(ConstApp.MemberType);
//alMemberCode.Add(ConstApp.EnterpriseType);
//alMemberCode.Add(ConstApp.BookDate);
//alMemberCode.Add(ConstApp.Trade);
alMemberCode.Add(ConstApp.Product);
//alMemberCode.Add(ConstApp.tishi);
//alMemberCode.Add(ConstApp.TouchFlash);
//alMemberCode.Add(ConstApp.TouchBookBeginDate);
//alMemberCode.Add(ConstApp.TouchBookEndDate);
//alMemberCode.Add(ConstApp.TouchSignInBeginDate);
//alMemberCode.Add(ConstApp.TouchSignInEndDate);
cmbType.SetDataBinding(alMemberCode, null);
}
/// <summary>
/// 绑定充值折扣
/// </summary>
/// <param name="cmbDiscount"></param>
public static void BindInMoneyDiscount(UltraComboEditor cmbDiscount)
{
cmbDiscount.SetDataBinding(Login.constApp.alInMoneyDiscount, null);
}
public static void BindProduct(UltraComboEditor cmbProduct)
{
cmbProduct.SetDataBinding(Login.constApp.alProduct, null);
}
///<summary>
///绑定企业性质
///</summary>
/// <param name="cmbTrade"></param>
public static void BindEnterpriseType(UltraComboEditor cmbEnterpriseType)
{
cmbEnterpriseType.SetDataBinding(Login.constApp.alEnterpriseType, null);
}
///<summary>
///绑定会员资格
///</summary>
///<param name="cmbTrade"></param>
public static void BindMemberRight(UltraComboEditor cmbMemberRight)
{
cmbMemberRight.SetDataBinding(Login.constApp.alMemberType, null);
}
///<summary>
///绑定行业
///</summary>
///<param name="cmbTrade"></param>
public static void BindTrade(UltraComboEditor cmbTrade)
{
cmbTrade.SetDataBinding(Login.constApp.alTrade, null);
}
