Esempio n. 1
0
        /// <summary>
        /// 绑定树形菜单
        /// </summary>
        private void BindTree()
        {
            VipSoft.BLL.CardLevel level = new VipSoft.BLL.CardLevel();
            listLevel = level.GetList("");
            TreeNode rootNode = new TreeNode("所有会员");
            rootNode.Name = "all_Level";
            foreach (DataRow dr in listLevel.Tables[0].Rows)
            {
                TreeNode node = new TreeNode(dr["LevelName"].ToString());
                node.Name = "level_" + dr["ID"].ToString();
                rootNode.Nodes.Add(node);
            }
            this.treeView_Class.Nodes.Add(rootNode);
            TreeNode rootNode_State = new TreeNode("所有会员");
            rootNode_State.Name = "all_state";

            TreeNode node1 = new TreeNode("正常");
            node1.Name = "state_" + ((int)CardState.Normal);
            rootNode_State.Nodes.Add(node1);

            TreeNode node2 = new TreeNode("锁定");
            node2.Name = "state_" + ((int)CardState.Locked);
            rootNode_State.Nodes.Add(node2);

            TreeNode node3 = new TreeNode("挂失");
            node3.Name = "state_" + ((int)CardState.Lossed);
            rootNode_State.Nodes.Add(node3);

            this.treeView_Class.Nodes.Add(rootNode_State);
            this.treeView_Class.ExpandAll();
        }
Esempio n. 2
0
 private void button_Delete_Click(object sender, EventArgs e)
 {
     if (this.dataGridView_List.SelectedRows.Count != 1)
     {
         MessageBox.Show("删除记录,请先选择需要删除的行。");
         return;
     }
     VipSoft.BLL.CardLevel level = new VipSoft.BLL.CardLevel();
     DataGridViewRow row = this.dataGridView_List.SelectedRows[0];
     string ID = row.Cells["ID"].Value.ToString();
     DataTable lst = level.GetListC(int.Parse(ID));
     if (lst.Rows.Count > 0)
     {
         MessageBox.Show("对不起,当前等级已有会员信息,不能删除此等级!");
         return;
     }
     else
     {
         DialogResult res = MessageBox.Show("确定要删除当前等级么?删除可能会影响到该等级会员卡的使用。", "警告", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2);
         if (res.ToString() == "OK")
         {
             level.Delete(int.Parse(row.Cells["ID"].Value.ToString()));
             // 记录日志
             VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog();
             log.Add(new VipSoft.Model.SysLog(PublicState.Master,"会员等级管理",
                 string.Format("删除会员等级(ID:{0}名称:{1}所需积分:{2}兑换比例:{3}折扣比例:{4})", row.Cells["ID"].Value.ToString(), row.Cells["LevelName"].Value.ToString(),
                 row.Cells["NeedPoint"].Value.ToString(), row.Cells["Point"].Value.ToString(), row.Cells["Percent"].Value.ToString()),DateTime.Now));
             // 提示
             MessageBox.Show("数据已成功删除。");
             // 重新绑定
             BindList();
         }
     }
 }
        private void RechargeMoneyReport_Load(object sender, EventArgs e)
        {
            this.dateTimePicker_Start.Text = DateTime.Now.ToShortDateString();
            this.comboBox_Sign_Money.SelectedIndex = 0;

            // 会员等级
            DataTable dtLevel = new VipSoft.BLL.CardLevel().GetAllList().Tables[0];

            this.comboBox_Level.Items.Add(new DictionaryEntry("所有等级", "0"));
            foreach (DataRow dr in dtLevel.Rows)
                this.comboBox_Level.Items.Add(new DictionaryEntry(dr["LevelName"].ToString(), dr["ID"].ToString()));

            this.comboBox_Level.DisplayMember = "Key";
            this.comboBox_Level.ValueMember = "Value";
            this.comboBox_Type.Items.Add(new DictionaryEntry("所有类型", "-1"));
            this.comboBox_Type.Items.Add(new DictionaryEntry("卡片付费初始化", "0"));
            this.comboBox_Type.Items.Add(new DictionaryEntry("储值卡现金充值", "1"));
            this.comboBox_Type.Items.Add(new DictionaryEntry("储值卡银联充值", "6"));
            this.comboBox_Type.Items.Add(new DictionaryEntry("记次卡现金充次", "2"));
            this.comboBox_Type.Items.Add(new DictionaryEntry("记次卡银联充次", "7"));
            this.comboBox_Type.Items.Add(new DictionaryEntry("储值卡扣款", "3"));
            this.comboBox_Type.Items.Add(new DictionaryEntry("积分返余额", "4"));
            this.comboBox_Type.Items.Add(new DictionaryEntry("卡片余额初始化", "5"));
            this.comboBox_Type.DisplayMember = "Key";
            this.comboBox_Type.ValueMember = "Value";

            this.comboBox_Sign_Money.SelectedIndex = 0;
        }
 void BindList()
 {
     this.dgvRechargeList.Rows.Clear();
     DataTable dt = new VipSoft.BLL.RechargeLog().GetReportList(QueryCondition()).Tables[0];
     foreach (DataRow dr in dt.Rows)
     {
         VipSoft.Model.CardLevel LevelModel=new VipSoft.BLL.CardLevel().GetModel(int.Parse(dr["LevelID"].ToString()));
         this.dgvRechargeList.Rows.Add(dr["CardID"].ToString(), dr["MemName"].ToString(), LevelModel.LevelName, dr["Type"].ToString() == "0" ? "卡片付费初始化" : dr["Type"].ToString() == "1" ? "储值卡现金充值" : dr["Type"].ToString() == "2" ? "记次卡现金充次" : dr["Type"].ToString() == "3" ? "储值卡扣款" : dr["Type"].ToString() == "5" ? "卡片余额初始化" : dr["Type"].ToString() == "6" ? "储值卡银联充值" : dr["Type"].ToString() == "7" ? "计次卡银联充次" : "积分返余额", dr["Money"].ToString(), dr["CreateTime"].ToString(), dr["GiveMoney"].ToString(), dr["Remark"].ToString());
     }
 }
Esempio n. 5
0
 /// <summary>
 /// 加载卡片等级
 /// </summary>
 private void LoadCardLevel()
 {
     VipSoft.BLL.CardLevel level = new VipSoft.BLL.CardLevel();
     DataSet ds = level.GetAllList();
     this.LevelID.DataSource = ds.Tables[0];
     this.LevelID.DisplayMember = "LevelName";
     this.LevelID.ValueMember = "ID";
 }
Esempio n. 6
0
        private void button_Manage_Click(object sender, EventArgs e)
        {
            if (!CheckInput())
                return;
            VipSoft.BLL.CardLevel cardL = new VipSoft.BLL.CardLevel();

            string needP = this.textBox_needpoint.Text;
            VipSoft.Model.CardLevel level = new VipSoft.Model.CardLevel();
            level.LevelName=this.textBox_LevelName.Text;
            level.NeedPoint=int.Parse(needP);
            level.Point=int.Parse(this.textBox_Point.Text);
            level.Percent=decimal.Parse(this.textBox_Percent.Text);
            if (this.label_Flag.Text == "add")
            {
                if (cardL.Exists(this.textBox_LevelName.Text))
                {
                    MessageBox.Show("等级名称重复,请重新输入!");
                    this.textBox_LevelName.Text = "";
                    this.textBox_LevelName.Focus();
                    return;
                }
                cardL.Add(level);
                // 记录日志
                VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog();
                log.Add(new VipSoft.Model.SysLog(PublicState.Master,"会员等级管理",
                    string.Format("新增会员等级(名称{0}:所需积分{1}:兑换比例{2}:折扣比例{3}:)", this.textBox_LevelName.Text, needP, this.textBox_Point.Text, this.textBox_Percent.Text), DateTime.Now));
                // 提示
                MessageBox.Show("新等级录入成功。");
                // 文本框数据清空

                this.textBox_LevelName.Text = "";
                this.textBox_Percent.Text = "";
                this.textBox_Point.Text = "";

                this.textBox_needpoint.Text = "";
            }
            // 编辑
            else
            {
                level.ID = int.Parse(this.label_Flag.Text);
                cardL.Update(level);
                // 记录日志
                VipSoft.BLL.SysLog log = new VipSoft.BLL.SysLog();
                log.Add(new VipSoft.Model.SysLog(PublicState.Master,"会员等级管理",
                    string.Format("编辑会员等级(ID:{0}名称:{1}所需积分:{2}兑换比例:{3}折扣比例:{4})", this.label_Flag.Text, this.textBox_LevelName.Text, needP, this.textBox_Point.Text, this.textBox_Percent.Text),
                    DateTime.Now));
                // 提示
                MessageBox.Show("等级修改成功。");
            }
            // 绑定数据
            BindList();
        }
Esempio n. 7
0
        private void OrderReport_Load(object sender, EventArgs e)
        {
            this.comboBox_PayType.Items.Add(new DictionaryEntry("所有类型", ""));
            this.comboBox_PayType.Items.Add(new DictionaryEntry("储值卡余额消费", "1"));
            this.comboBox_PayType.Items.Add(new DictionaryEntry("现金消费", "2"));
            this.comboBox_PayType.Items.Add(new DictionaryEntry("信用卡支付", "3"));
            this.comboBox_PayType.Items.Add(new DictionaryEntry("代金券支付", "4"));
            this.comboBox_PayType.Items.Add(new DictionaryEntry("联合支付", "5"));
            this.comboBox_PayType.DisplayMember = "Key";
            this.comboBox_PayType.ValueMember = "Value";
            this.comboBox_G_PayType.Items.Add(new DictionaryEntry("所有类型", ""));
            this.comboBox_G_PayType.Items.Add(new DictionaryEntry("储值卡余额消费", "1"));
            this.comboBox_G_PayType.Items.Add(new DictionaryEntry("现金消费", "2"));
            this.comboBox_G_PayType.Items.Add(new DictionaryEntry("联合消费", "3"));
            this.comboBox_G_PayType.DisplayMember = "Key";
            this.comboBox_G_PayType.ValueMember = "Value";

            // 会员等级
            DataTable dtLevel = new VipSoft.BLL.CardLevel().GetAllList().Tables[0];
            this.comboBox_CardLevel.Items.Add(new DictionaryEntry("所有等级", "0"));
            foreach (DataRow dr in dtLevel.Rows)
                this.comboBox_CardLevel.Items.Add(new DictionaryEntry(dr["LevelName"].ToString(), dr["ID"].ToString()));
            this.comboBox_CardLevel.DisplayMember = "Key";
            this.comboBox_CardLevel.ValueMember = "Value";

            this.comboBox_B_CardLevel.Items.Add(new DictionaryEntry("所有等级", "0"));
            foreach (DataRow dr in dtLevel.Rows)
                this.comboBox_B_CardLevel.Items.Add(new DictionaryEntry(dr["LevelName"].ToString(), dr["ID"].ToString()));
            this.comboBox_B_CardLevel.DisplayMember = "Key";
            this.comboBox_B_CardLevel.ValueMember = "Value";

            this.comboBox_P_CardLevel.Items.Add(new DictionaryEntry("所有等级", "0"));
            foreach (DataRow dr in dtLevel.Rows)
                this.comboBox_P_CardLevel.Items.Add(new DictionaryEntry(dr["LevelName"].ToString(), dr["ID"].ToString()));
            this.comboBox_P_CardLevel.DisplayMember = "Key";

            this.comboBox_P_CardLevel.ValueMember = "Value";

            DataTable dtClass;
            // 产品分类
            dtClass = new VipSoft.BLL.GoodsClass().GetList("ShopID="+PublicState.Master.ShopID).Tables[0];
            Function.BindGoodsClass(this.comboBox_G_Class, dtClass);
            Function.BindGoodsClass(this.comboBox_M_Class, dtClass);
            DataTable dt = (DataTable)this.comboBox_G_Class.DataSource;
            this.comboBox_G_Class.DataSource = dt;
            this.comboBox_M_Class.DataSource = dt;

            this.comboBox_Sign.SelectedIndex = 0;
            this.comboBox_B_Sign.SelectedIndex = 0;
            this.comboBox_OrderType.SelectedIndex = 0;
            this.comboBox_PayType.SelectedIndex = 0;
            this.comboBox_G_Sign.SelectedIndex = 0;
            this.comboBox_G_OrderType.SelectedIndex = 0;
            this.comboBox_G_PayType.SelectedIndex = 0;
            this.comboBox_G_Class.SelectedIndex = 0;
            this.comboBox_M_Sign.SelectedIndex = 0;
            this.comboBox_M_OrderType.SelectedIndex = 0;
            this.comboBox_M_Class.SelectedIndex = 0;
            this.comboBox_P_Sign.SelectedIndex = 0;

            this.dateTimePicker_Start.Text = DateTime.Now.ToShortDateString();
            this.dateTimePicker_End.Text = DateTime.Now.ToShortDateString();
            this.dateTimePicker_G_Start.Text = DateTime.Now.ToShortDateString();
            this.dateTimePicker_G_End.Text = DateTime.Now.ToShortDateString();
            this.dateTimePicker_M_Start.Text = DateTime.Now.ToShortDateString();
            this.dateTimePicker_M_End.Text = DateTime.Now.ToShortDateString();
            this.dateTimePicker_B_Start.Text = DateTime.Now.ToShortDateString();
            this.dateTimePicker_P_Start.Text = DateTime.Now.ToShortDateString();
            this.dateTimePicker_P_End.Text = DateTime.Now.ToShortDateString();

            this.maskedTextBox_B_Start.Text = "00:00:00";
            this.maskedTextBox_P_Start.Text = "00:00:00";
            this.maskedTextBox_P_End.Text = "00:00:00";
            this.maskedTextBox_B_End.Text = "23:59:59";
            this.maskedTextBox_End.Text = "23:59:59";
            this.maskedTextBox_G_Start.Text = "00:00:00";
            this.maskedTextBox_G_End.Text = "23:59:59";
            this.maskedTextBox_M_Start.Text = "00:00:00";
            this.maskedTextBox_M_End.Text = "23:59:59";
            this.maskedTextBox5.Text = "00:00:00";
        }
Esempio n. 8
0
 /// <summary>
 /// 根据等级编号得到该等级的折扣率(1表示不打折)
 /// </summary>
 public static int LevelIDToPoint(int levelID)
 {
     List<VipSoft.Model.CardLevel> listLevel = new VipSoft.BLL.CardLevel().GetModelList("");
     foreach (VipSoft.Model.CardLevel level in listLevel)
     {
         if (level.ID == levelID)
             return (int)level.Point;
     }
     return 0;
 }
Esempio n. 9
0
 /// <summary>
 /// 根据等级编号得到该等级的折扣率(1表示不打折)
 /// </summary>
 public static decimal LevelIDToPercent(int levelID)
 {
     List<VipSoft.Model.CardLevel> listLevel = new VipSoft.BLL.CardLevel().GetModelList("");
     foreach (VipSoft.Model.CardLevel level in listLevel)
     {
         if (level.ID == levelID)
             return (decimal)level.Percent;
     }
     return 1M;
 }
Esempio n. 10
0
 /// <summary>
 /// 将等级编号转换为名称
 /// </summary>
 public static string LevelIDToName(int levelID)
 {
     List<VipSoft.Model.CardLevel> listLevel = new VipSoft.BLL.CardLevel().GetModelList("");
     foreach (VipSoft.Model.CardLevel level in listLevel)
     {
         if (level.ID == levelID)
             return level.LevelName;
     }
     return "";
 }