lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/MembershipManage/SuperSmallForm/CashbackInfoSuperSmallForm.cs

using LYFZ.Software.MainBusiness.MembershipManage.SetSmallForm;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.MembershipManage.SuperSmallForm
{
    public partial class CashbackInfoSuperSmallForm : LYFZ.Software.UI.MembershipManage.SuperSmallForm.CashbackInfoSuperSmallForm
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        LYFZ.BLL.BLL_ErpMemberCard mcbll = new BLL.BLL_ErpMemberCard();
        LYFZ.BLL.BLL_ErpMemberCardBackCash mcbcbll = new BLL.BLL_ErpMemberCardBackCash();
        LYFZ.BLL.BLL_ErpMemberCardViceCard bll_ViceCard = new BLL.BLL_ErpMemberCardViceCard();
        LYFZ.BLL.BLL_ErpMemberCardBackCashTakeCash mcbctcbll = new BLL.BLL_ErpMemberCardBackCashTakeCash();

        // <summary>
        /// 登录者姓名
        /// </summary>
        string loginUserName = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_Name;
        /// <summary>
        /// 登录者员工ID
        /// </summary>
        string loginUserID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
        public CashbackInfoSuperSmallForm()
        {
            this.tabControlEx1.SelectedIndexChanged += tabControlEx1_SelectedIndexChanged;
            this.btnDelete.Click += btnDelete_Click;
            this.FormClosing += CashbackInfoSuperSmallForm_FormClosing;
            this.btnDelete.Visible = false;
        }
        /// <summary>
        /// 会员编号
        /// </summary>
        public string StrNumber;
        /// <summary>
        /// 是否保存
        /// </summary>
        public bool IsSaveed = false;
        DataTable tbl = new DataTable();
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void CashbackInfoSuperSmallForm_Load(object sender, EventArgs e)
        {
            LYFZ.Model.Model_ErpMemberCardBackCash model = mcbcbll.GetModel("Mcbc_Number", this.StrNumber);
            if (model.ID > 0)
            {
                this.txtCashBackNumber.Text = model.Mcbc_CashBackNumber.ToString().Trim();
                string[] strSpilt = model.Mcbc_CashBackProportion.Trim().Split(',');
                string StrProportion = "";
                for (int i = 0; i < strSpilt.Length; i++)
                {
                    StrProportion += "(" + (i + 1) + ")." + strSpilt[i].Trim() + "%   ";
                }
                this.txtCashBackProportion.Text = StrProportion;
                this.txtHaveBeenTakenOutAmount.Text = model.Mcbc_AlreadyWithdrawCash.ToString("#,##0.00");
                this.txtHaveReturnedAmount.Text = model.Mcbc_AlreadyCashBack.ToString("#,##0.00");
                this.txtPackagesAmount.Text = model.Mcbc_PackagesMoney.ToString("#,##0.00");
            }
            string StrTableName = "select tb_ErpMemberCardBackCashSet.ID," +
            "Mcb_Number," +
            "Mcb_No," +
            "Mcb_Proportion," +
            "Mcb_IsSpending," +
            "(select Ord_SinceOrderNumber from tb_ErpOrder Where Ord_Number = Mcb_OrderNumber) as Mcb_OrderNumber," +
            "(select top 1 Cus_Name from tempTB_AggregationCustomer Where GP_OrderNumber = Mcb_OrderNumber) AS Cus_Name," +
            "Mcb_SpendingTime," +
            "Mcb_CreateDatetime," +
            "Mcb_CreateName," +
            "Mcb_UpdateDateTime," +
            "Mcb_UpdateName," +
            "Mcb_ViceNumber," +
            "Mcb_CashBackGroup," +
            "Mvc_ViceCardNumber," +
            "Mcb_CashBackAmount " +
            "from tb_ErpMemberCardBackCashSet " +
            "Left Join tb_ErpMemberCardViceCard on Mcb_ViceNumber = Mvc_ViceNumber Where Mcb_Number = '" + this.StrNumber + "' order by Mcb_CashBackGroup DESC,Mcb_No ASC";
            DataTable tbl = orbll.GetView_Custom(StrTableName).Tables[0];
            this.dgvData1.DataColumns("序号,比例,返现金额,返现状态,使用副卡,消费订单,消费日期");
            System.Drawing.Color PowderBlue = this.dgvData1.DataGridViewRowsBackColor_Single();
            for (int i = 0; i < tbl.Rows.Count; i++)
            {
                DataGridViewRow dgvl = new DataGridViewRow();
                DataGridViewCell cell = null;

                if (i > 0)
                {
                    if (tbl.Rows[i]["Mcb_CashBackGroup"].ToString().Trim() != tbl.Rows[i - 1]["Mcb_CashBackGroup"].ToString().Trim())
                    {
                        if (PowderBlue == this.dgvData1.DataGridViewRowsBackColor_Single())
                        { PowderBlue = this.dgvData1.DataGridViewRowsBackColor_Double(); }
                        else
                        { PowderBlue = this.dgvData1.DataGridViewRowsBackColor_Single(); }
                    }
                }
                dgvl.DefaultCellStyle.BackColor = PowderBlue;

                cell = new DataGridViewTextBoxCell();
                cell.Value = tbl.Rows[i]["Mcb_No"].ToString().Trim();
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tbl.Rows[i]["Mcb_Proportion"].ToString().Trim();
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tbl.Rows[i]["Mcb_CashBackAmount"].ToString();
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tbl.Rows[i]["Mcb_IsSpending"].ToString().Trim() == "0" ? "未使用" : tbl.Rows[i]["Mcb_IsSpending"].ToString().Trim() == "1" ? "已返现" : "已失效";
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tbl.Rows[i]["Mvc_ViceCardNumber"].ToString().Trim();
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tbl.Rows[i]["Mcb_OrderNumber"].ToString().Trim() + " " + tbl.Rows[i]["Cus_Name"].ToString().Trim();
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                if (tbl.Rows[i]["Mcb_SpendingTime"].ToString().Trim() == "")
                { cell.Value = ""; }
                else { cell.Value = Convert.ToDateTime(tbl.Rows[i]["Mcb_SpendingTime"]).ToString("yyyy-MM-dd HH:mm"); }
                dgvl.Cells.Add(cell);

                this.dgvData1.Rows.Add(dgvl);
            }
            this.dgvData1.Columns["序号"].Width = 40;
            this.dgvData1.Columns["比例"].Width = 50;
            this.dgvData1.Columns["返现状态"].Width = 60;
            this.dgvData1.Columns["返现金额"].Width = 80;
            this.dgvData1.Columns["消费订单"].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
            this.dgvData1.Columns["消费日期"].Width = 110;

            DataTable tblA = mcbll.GetView_Custom("tb_ErpMemberCardBackCashTakeCash", StrWhere: "Mctc_Number = '" + StrNumber + "'", ShowColumnName: "ID,Mctc_Number,Mctc_PackagesMoney,Mctc_CashAmount,Mctc_UpdateDateTime,dbo.fn_CheckUserIDGetUserName(Mctc_UpdateName) AS Mctc_UpdateName").Tables[0];
            this.dgvData2.DataColumns("序号,ID,套系金额,提现金额,提现日期,经手人", strHideField: "ID,套系金额");
            for (int i = 0; i < tblA.Rows.Count; i++)
            {
                DataGridViewRow dgvl = new DataGridViewRow();
                DataGridViewCell cell = null;

                cell = new DataGridViewTextBoxCell();
                cell.Value = (i + 1);
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tblA.Rows[i]["ID"].ToString().Trim();
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tblA.Rows[i]["Mctc_PackagesMoney"].ToString().Trim();
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tblA.Rows[i]["Mctc_CashAmount"].ToString().Trim();
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = Convert.ToDateTime(tblA.Rows[i]["Mctc_UpdateDateTime"]).ToString("yyyy-MM-dd HH:mm");
                dgvl.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tblA.Rows[i]["Mctc_UpdateName"].ToString().Trim();
                dgvl.Cells.Add(cell);

                this.dgvData2.Rows.Add(dgvl);
            }

            DataTable tbl_ViceCard = mcbll.GetView_Custom("tb_ErpMemberCardViceCard", StrWhere: "Mvc_ViceCardType = '返现副卡' and Mvc_Status != '3' and Mvc_Number = '" + StrNumber + "'", filedOrder: "Mvc_CashBackGroup DESC,ID ASC", ShowColumnName: "Mvc_ViceNumber,Mvc_ViceCardNumber,Mvc_ViceCardType,Mvc_Status,Mvc_Remark,Mvc_CreateDatetime,Mvc_UpdateDateTime").Tables[0];
            string StrColumn = "副卡号,副卡类型,状态,发卡日期,使用日期,副卡编号";
            this.dgvData3.DataColumns(StrColumn, strHideField: "副卡编号");
            PowderBlue = this.dgvData1.DataGridViewRowsBackColor_Single();
            for (int i = 0; i < tbl_ViceCard.Rows.Count; i++)
            {
                DataGridViewRow dgvr = new DataGridViewRow();
                DataGridViewCell cell = null;
                if (i > 0)
                {
                    if (tbl.Rows[i]["Mcb_CashBackGroup"].ToString().Trim() != tbl.Rows[i - 1]["Mcb_CashBackGroup"].ToString().Trim())
                    {
                        if (PowderBlue == this.dgvData1.DataGridViewRowsBackColor_Single())
                        { PowderBlue = this.dgvData1.DataGridViewRowsBackColor_Double(); }
                        else
                        { PowderBlue = this.dgvData1.DataGridViewRowsBackColor_Single(); }
                    }
                }
                dgvr.DefaultCellStyle.BackColor = PowderBlue;

                cell = new DataGridViewTextBoxCell();
                cell.Value = tbl_ViceCard.Rows[i]["Mvc_ViceCardNumber"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tbl_ViceCard.Rows[i]["Mvc_ViceCardType"].ToString().Trim();
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                string StrStatus = tbl_ViceCard.Rows[i]["Mvc_Status"].ToString().Trim() == "0" ? "已注销" : tbl_ViceCard.Rows[i]["Mvc_Status"].ToString().Trim() == "1" ? "正在使用" : "已使用";
                if (!string.IsNullOrEmpty(tbl_ViceCard.Rows[i]["Mvc_Remark"].ToString().Trim()))
                { cell.Value = StrStatus + "_" + tbl_ViceCard.Rows[i]["Mvc_Remark"].ToString().Trim(); }
                else
                { cell.Value = StrStatus; }
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(tbl_ViceCard.Rows[i]["Mvc_CreateDatetime"], "yyyy-MM-dd HH:mm");
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = LYFZ.Command.Command_Validate.DateTimeToString(tbl_ViceCard.Rows[i]["Mvc_UpdateDateTime"], "yyyy-MM-dd HH:mm");
                dgvr.Cells.Add(cell);

                cell = new DataGridViewTextBoxCell();
                cell.Value = tbl_ViceCard.Rows[i]["Mvc_ViceNumber"].ToString().Trim();
                dgvr.Cells.Add(cell);

                this.dgvData3.Rows.Add(dgvr);
            }
        }
        /// <summary>
        /// 选项卡选择
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void tabControlEx1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (this.tabControlEx1.SelectedIndex == 1 || this.tabControlEx1.SelectedIndex == 2)
            { this.btnDelete.Visible = true; }
            else
            { this.btnDelete.Visible = false; }
        }
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnDelete_Click(object sender, EventArgs e)
        {
            if (this.tabControlEx1.SelectedIndex == 1)
            {
                if (this.dgvData2.Rows.Count > 0 && this.dgvData2.CurrentRow.Index >= 0)
                {
                    DateTime StrTime = new DateTime();
                    string StrUserID = LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.LoginUserModel.User_EmployeeID;
                    List<Helper.CommandInfo> clist = new List<Helper.CommandInfo>();
                    LYFZ.Model.Model_ErpMemberCardBackCashTakeCash modeltc = mcbctcbll.GetModel(Convert.ToInt32(this.dgvData2.CurrentRow.Cells["ID"].Value));
                    if (modeltc.Mctc_CashAmountAudit.Trim() == "已审核")
                    { MessageBoxCustom.Show("返现已审核，不能删除！"); return; }

                    clist.Add(mcbctcbll.GetDeleteCommandInfo("ID", "=", modeltc.ID));

                    LYFZ.Model.Model_ErpMemberCardBackCash model = mcbcbll.GetModel("Mcbc_Number", modeltc.Mctc_Number);
                    model.Mcbc_AlreadyWithdrawCash = model.Mcbc_AlreadyWithdrawCash - Convert.ToDecimal(this.dgvData2.CurrentRow.Cells["提现金额"].Value);
                    model.Mcbc_UpdateDateTime = StrTime;
                    model.Mcbc_UpdateName = StrUserID;
                    clist.Add(mcbcbll.GetUpdateCommandInfo(model));

                    if (clist.Count > 0)
                    {
                        LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(EnumPublic.SystemLogsType.删除会员副卡记录, "删除会员副卡"+ modeltc.Mctc_Number + " 的提现记录，提现金额："+ this.dgvData2.CurrentRow.Cells["提现金额"].Value, loginUserID, loginUserName);
                        if (MessageBoxCustom.Show("你确定要删除吗？删除后，删除金额会退回卡里！", "温馨提示", MessageBoxButtons.YesNo) == DialogResult.No)
                        { return; }
                        if (LYFZ.BLL.BaseBllOperate.ExecuteSqlTran(clist) <= 0)
                        { MessageBoxCustom.Show("提现失败"); return; }
                        this.IsSaveed = true;
                        MessageBoxCustom.Show("提现成功");
                        this.CashbackInfoSuperSmallForm_Load(this, null);
                    }
                }
            }
            else if (this.tabControlEx1.SelectedIndex == 2)
            {
                if (this.dgvData3.Rows.Count > 0 && this.dgvData3.CurrentRow.Index >= 0)
                {
                    LYFZ.Model.Model_ErpMemberCardViceCard model = bll_ViceCard.GetModel("Mvc_ViceNumber", this.dgvData3.CurrentRow.Cells["副卡编号"].Value.ToString().Trim());
                    if (model.Mvc_Status.Trim() == "0")
                    { MessageBoxCustom.Show("此副卡已注销，不能删除！"); return; }
                    if (model.Mvc_Status.Trim() == "2")
                    { MessageBoxCustom.Show("此副卡已使用，不能删除！"); return; }
                    if (!LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.MemberManage, LYFZ.CustomAttributes.OperatingAuthority.Member_ViceCardDelete))
                    { MessageBoxCustom.Show("您无权限删除副卡！"); return; }
                    if (MessageBoxCustom.Show("您确定要删除 副卡：" + this.dgvData3.CurrentRow.Cells["副卡号"].Value.ToString().Trim() + " 吗？", "温馨提示", MessageBoxButtons.YesNo) == DialogResult.No)
                    { return; }
                    if (!bll_ViceCard.Delete(model.ID))
                    { MessageBoxCustom.Show("删除失败！"); return; }
                    else
                    {
                        LYFZ.BLL.BLL_ErpSystemLogs.WriteSystemLog(EnumPublic.SystemLogsType.删除会员副卡记录, "删除会员副卡" + this.dgvData3.CurrentRow.Cells["副卡号"].Value.ToString().Trim() + " ", loginUserID,loginUserName);
                        MessageBoxCustom.Show("删除成功！"); this.CashbackInfoSuperSmallForm_Load(this, null);
                    }
                }
            }
        }
        /// <summary>
        /// 关闭窗体后发生事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void CashbackInfoSuperSmallForm_FormClosing(object sender, FormClosingEventArgs e)
        {
            GoldManagementSmallForm frm1 = (GoldManagementSmallForm)this.Owner;
            frm1.RefreshParentForm = IsSaveed;
        }
    }
}