RuiTengJb/ICSSoft.AppSln/ICSSoft.Frame.APP/Report/FormICSSOPriceSheetEditAdd.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Windows.Forms;
using DevExpress.XtraEditors;
using ICSSoft.Base.Config.AppConfig;
using ICSSoft.Base.Config.DBHelper;
using ICSSoft.Base.ReferForm.AppReferForm;
using ICSSoft.Frame.Data.Entity;
using ICSSoft.Frame.Data.BLL;

namespace ICSSoft.Frame.APP
{
    public partial class FormICSSOPriceSheetEditAdd : DevExpress.XtraEditors.XtraForm
    {
        string VRow = "";
        String guid = "";
        string SoCode = "";
        XS001_0001_E001_2020 entity = new XS001_0001_E001_2020();
        private DataTable dtNewRcards = null;

        #region 构造函数
        public FormICSSOPriceSheetEditAdd()
        {
            InitializeComponent();
        }
        public FormICSSOPriceSheetEditAdd(String id,string socode)
        {
            InitializeComponent();
            guid = id;
            SoCode = socode;
        }
        #endregion

        #region 关闭 退出
        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        #endregion

        #region 移动窗体
        private const int WM_NCHITTEST = 0x84;
        private const int HTCLIENT = 0x1;
        private const int HTCAPTION = 0x2;
        //首先必须了解Windows的消息传递机制，当有鼠标活动消息时， 
        //系统发送WM_NCHITTEST 消息给窗体作为判断消息发生地的根据。 nchittest
        //假如你点击的是标题栏，窗体收到的消息值就是 HTCAPTION ， 
        //同样地，若接受到的消息是 HTCLIENT，说明用户点击的是客户区，也就是鼠标消息发生在客户区。 

        //重写窗体，使窗体可以不通过自带标题栏实现移动
        protected override void WndProc(ref Message m)
        {
            //当重载窗体的 WndProc 方法时，可以截获 WM_NCHITTEST 消息并改些该消息， 
            //当判断鼠标事件发生在客户区时，改写改消息，发送 HTCAPTION 给窗体， 
            //这样，窗体收到的消息就时 HTCAPTION ，在客户区通过鼠标来拖动窗体就如同通过标题栏来拖动一样。 
            //注意：当你重载 WndProc 并改写鼠标事件后，整个窗体的鼠标事件也就随之改变了。 
            switch (m.Msg)
            {
                case WM_NCHITTEST:
                    base.WndProc(ref m);
                    if ((int)m.Result == HTCLIENT)
                        m.Result = (IntPtr)HTCAPTION;
                    return;
            }
            //拦截双击标题栏、移动窗体的系统消息  
            if (m.Msg != 0xA3)
            {
                base.WndProc(ref m);
            }
        }
        #endregion
       
        #region 取消
        private void can_Click(object sender, EventArgs e)
        {
            this.Close();
        }
        #endregion

        #region 页面加载
        private void FormICSINVENTORYEditAdd_Load(object sender, EventArgs e)
        {

            if (guid != "")
            {
                decimal sumsinglemoney = 0;
                lblTitle.Text = "单据维护";
                DataTable body = ICSSOPriceSheetBLL.GetDetailList(guid, AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"));
                grvDetail.DataSource = body;
                dtNewRcards = body;
                //grdDetail.BestFitColumns();
                txtSOCode.Enabled = false;
                checkAll.Enabled = false;
                checkAll.Checked = true;
                init();
                loadop();
                foreach (DataRow dr in body.Rows)
                {
                    if (body.Rows.Count > 0)
                    {
                        txtSOCode.EditValue = dr["IDs"].ToString().Trim();
                        txtCode.Text = dr["ID"].ToString().Trim();
                        txtSOType.Text = dr["cSoType"].ToString().Trim();
                        txtCusName.Text = dr["cCusName"].ToString().Trim();
                        txtInvCode.Text = dr["InvCodes"].ToString().Trim();
                        txtInvName.Text = dr["InvName"].ToString().Trim();
                        txtNumber.Text = dr["iNum"].ToString().Trim();
                        txtDNumber.Text = dr["cInvStd"].ToString().Trim();
                        txtWeight.Text = dr["iWeight"].ToString().Trim();
                        txtOpQuire.Text = dr["cinvtype"].ToString().Trim();
                        txtdDate.Text = dr["dDate"].ToString().Trim();
                        txtSumSingleMoney.Text = dr["iPrice"].ToString().Trim();
                    }
                }
                for (int i = 0; i < grdDetail.RowCount; i++)
                {
                    if (grdDetail.GetRowCellValue(i, colSingleMoney).ToString() == "")
                    {
                        sumsinglemoney = sumsinglemoney + 0; 
                    }
                    else
                    {
                        sumsinglemoney = sumsinglemoney + Convert.ToDecimal(grdDetail.GetRowCellValue(i, colSingleMoney).ToString());
                        txtSumMoney.Text = Convert.ToString(sumsinglemoney);
                    }
                }
            }
            else
            {
                lblTitle.Text = "单据新增";
                txtCode.Text = ICSSOPriceSheetBLL.GetOutInNo(AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"));
                init();
            }
        }
        #endregion

        #region 初始化查询条件
        private void init()
        {
            #region 销售订单号
            string sql = @"SELECT DISTINCT a.cSOCode 销售订单号,b.cInvCode 存货编码, b.cdefine24 工艺要求,
                            (CASE WHEN isnull(c.cSOCode,'')=''   THEN '未维护' ELSE '已维护' END ) as 状态,
                            a.cSOCode+b.cInvCode+ISNULL(b.cdefine24, '') as ID
                            FROM SO_SOMain  a with(nolock) 
                            LEFT JOIN SO_SODetails  b with(nolock) on b.cSOCode=a.cSOCode
                            left JOIN dbo.XS001_0001_E001_2020 c with(nolock) ON a.cSOCode=c.cSOCode  and isnull(b.cinvcode,'')=isnull(c.cinvcode,'') 
                            and isnull(b.cdefine24,'')=isnull(c.cinvtype,'')
                            WHERE a.dDate>='2020-08-01' ";
            sql = string.Format(sql, AppConfig.WorkPointCode);
            if (!checkAll.Checked)
            {
                sql += " AND c.cSOCode is null";
            }
            else
            {
                sql += " AND 1=1 ";
            }
            DataTable dt = DBHelper.ExecuteDataset(AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"), CommandType.Text, sql).Tables[0];
            txtSOCode.Properties.ValueMember = "ID";
            txtSOCode.Properties.DisplayMember = "销售订单号";
            txtSOCode.Properties.DataSource = dt;
            txtSOCode.Properties.NullText = "";//空时的值    
            //txtSOCode.Properties.View.Columns["ID"].Visible = false; //隐藏列
            txtSOCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
            txtSOCode.Properties.ValidateOnEnterKey = true;//回车确认  
            txtSOCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
            txtSOCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容 
            //自适应宽度
            txtSOCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
            #endregion

            #region 存货编码
            string sqls = @"SELECT DISTINCT cInvCode as 存货编码,cInvName as 存货名称,cInvStd as 图号  FROM Inventory";
            DataTable dts = DBHelper.ExecuteDataset(AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"), CommandType.Text, sqls).Tables[0];
            txtcInvCode.Properties.ValueMember = "存货编码";
            txtcInvCode.Properties.DisplayMember = "存货编码";
            txtcInvCode.Properties.DataSource = dts;
            txtcInvCode.Properties.NullText = "";//空时的值    
            //txtSOCode.Properties.View.Columns["ID"].Visible = false; //隐藏列
            txtcInvCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
            txtcInvCode.Properties.ValidateOnEnterKey = true;//回车确认  
            txtcInvCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
            txtcInvCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容 
            //自适应宽度
            txtcInvCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
            #endregion
        }
        #endregion
      
        #region 销售订单号
        private void txtSOCode_EditValueChanged(object sender, EventArgs e)
        {
            try
            {
                string Code = txtSOCode.Text;
                string socode = "";
                string invcode="";
                string invtype="";
                #region 判断销售订单号是否维护
                GridLookUpEdit edit = sender as GridLookUpEdit;
                if (edit.EditValue != null && edit.EditValue.ToString() != "" && edit.EditValue.ToString() != "nulltext")
                {
                    var o = edit.Properties.GetRowByKeyValue(edit.EditValue);
                    if (o is DataRowView)
                    {
                        DataRowView RowView = o as DataRowView;
                        socode = RowView.Row["销售订单号"].ToString();
                        invcode = RowView.Row["存货编码"].ToString();
                        invtype = RowView.Row["工艺要求"].ToString();
                    }
                }
                string sqlso = @"SELECT cSOCode FROM XS001_0001_E001_2020 WHERE cSOCode='{0}' AND cInvCode='{1}' AND cinvtype='{2}'";
                sqlso = string.Format(sqlso, Code, invcode, invtype);
                DataTable dtso = DBHelper.ExecuteDataset(AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"), CommandType.Text, sqlso).Tables[0];
                if (dtso != null && dtso.Rows.Count > 0&&guid=="")
                {
                    ICSBaseSimpleCode.AppshowMessageBox("该销售订单号已经维护，不能选择!!!");
                    init();
                    return;
                }
                #endregion
                #region 查询
                string sql = @"select 
                                a.ddate 销售订单日期,
                                a.cSOCode 销售订单号,
                                d.cSTName 销售类型,
                                a.cCusName 客户名称,
                                b.cInvCode 存货编码,
                                b.cinvname  存货名称,
                                c.cinvstd 图号,
                                b.cdefine24 工艺要求,
                                CAST(isnull(SUM(b.iquantity),0) as NUMERIC(10,2)) 数量,
                                CAST(isnull(sum(b.iNum),0) as NUMERIC(10,2)) 重量,
                                CAST(isnull(SUM(b.iNatSum),0)/isnull(SUM(b.iquantity),0) as NUMERIC(18,6)) as 产品单价
                                from SO_SOMain  a with(nolock)
                                inner join  SO_SODetails  b with(nolock) on b.cSOCode=a.cSOCode
                                inner join inventory c with(nolock) on c.cinvcode=b.cinvcode
                                inner join SaleType d with(nolock) on d.cstcode=a.cstcode
                                WHERE a.dDate>='2020-08-01' AND a.cSOCode='{0}' and b.cInvCode='{1}' and ISNULL(b.cdefine24, '')='{2}'
                                group by a.cSOCode,a.cCusName,b.cInvCode,b.cinvname,
                                b.cdefine24,c.cinvstd,d.cSTName,a.ddate";
                sql = string.Format(sql, Code,invcode,invtype, AppConfig.WorkPointCode);
                DataTable dt = DBHelper.ExecuteDataset(AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"), CommandType.Text, sql).Tables[0];
                if (dt != null && dt.Rows.Count > 0)
                {             
                    txtCusName.Text = dt.Rows[0]["客户名称"].ToString();
                    txtSOType.Text = dt.Rows[0]["销售类型"].ToString();
                    txtNumber.Text = dt.Rows[0]["数量"].ToString();
                    txtInvCode.Text = dt.Rows[0]["存货编码"].ToString();
                    txtInvName.Text = dt.Rows[0]["存货名称"].ToString();
                    txtDNumber.Text = dt.Rows[0]["图号"].ToString();
                    txtWeight.Text = dt.Rows[0]["重量"].ToString();
                    txtOpQuire.Text = dt.Rows[0]["工艺要求"].ToString();
                    txtdDate.Text = dt.Rows[0]["销售订单日期"].ToString();
                    txtSumSingleMoney.Text = dt.Rows[0]["产品单价"].ToString();                                      
                    #region 新增时带出默认工序
                    if (guid == "")
                    {
                        string sqlop = @"select DISTINCT
                                        'Y' as isSelect,
                                        a.cSOCode as SOCode,
                                        '' as SORow,
                                        --1 as SORow,
                                        b.cInvCode InvCode,
                                        b.cinvname  InvName,
                                        c.cinvstd DNumber,
                                        '材料费' as QuotationItem,
                                        'CL' OpCode,
                                        '' as SingleMoney,
                                        '' as Memo
                                        from dbo.SO_SOMain  a with(nolock)
                                        inner join  dbo.SO_SODetails  b with(nolock) on b.cSOCode=a.cSOCode
                                        inner join dbo.inventory c with(nolock) on c.cinvcode=b.cinvcode
                                        WHERE b.cInvCode='{0}' and a.cSOCode='{2}'
                                        UNION ALL
                                        select DISTINCT
                                        'Y' as isSelect,
                                        a.cSOCode as SOCode,
                                        '' as SORow,
                                        --row_number() OVER (ORDER BY a.cSCCode)+1 as  SORow,
                                        b.cInvCode InvCode,
                                        b.cinvname  InvName,
                                        c.cinvstd DNumber,
                                        f.OPDESC as QuotationItem,
                                        f.OPCODE as OpCode,
                                        '' as SingleMoney,
                                        '' as Memo
                                        from dbo.SO_SOMain  a with(nolock)
                                        inner join dbo.SO_SODetails  b with(nolock) on b.cSOCode=a.cSOCode
                                        inner join dbo.inventory c with(nolock) on c.cinvcode=b.cinvcode
                                        -- INNER JOIN [{1}].[ICSMES_YTSys].dbo.ICSITEM2ROUTE  d ON b.cInvCode=d.itemcode
                                        -- INNER JOIN [{1}].[ICSMES_YTSys].dbo.ICSITEMROUTE2OP e ON d.ROUTECODE=e.ROUTECODE
                                        -- INNER JOIN [{1}].[ICSMES_YTSys].dbo.ICSOP f ON  e.OPID=f.ID
                                        INNER JOIN(
                                        select
                                        distinct 
                                        a.OPCODE,d.OPDESC,e.cInvCode
                                        from [{1}].[ICSMES_YTSys].dbo.ICSITEMROUTE2OPLot a with(nolock)
                                        inner join [{1}].[ICSMES_YTSys].dbo.ICSOP d with(nolock) on d.OPCODE=a.OPCODE
                                        inner join [{1}].[ICSMES_YTSys].dbo.ICSITEMLot b with(nolock) on b.LotNO=a.LotNo
                                        inner join [{1}].[ICSMES_YTSys].dbo.icsmo c with(nolock) on c.MOCODE=b.TransNO and c.MOSEQ=b.TransLine 
                                        left join
                                        (select 
                                        DISTINCT
                                        b.cSOCode,b.cInvCode,cDefine24
                                        from dbo.SO_SOMain  a with(nolock)
                                        inner join  dbo.SO_SODetails  b with(nolock) on b.cSOCode=a.cSOCode
                                        where a.dDate>'2020-08-01 00:00:00.000'
                                        ) e on e.cSOCode=c.ORDERNO and e.cinvcode=a.ITEMCODE and e.cdefine24=c.REMOITEMDESC
                                        where e.cSOCode='{2}'
                                        )f  on f.cInvCode=b.cInvCode 
                                        WHERE b.cInvCode='{0}' and a.cSOCode='{2}'";
                        #region 获取MES地址
                        string sqlip = "SELECT DBIpAddress FROM Sys_DataBase WHERE DBSourceName='SYS'";
                        sqlip = string.Format(sqlip, AppConfig.AppConnectString);
                        DataTable dtip = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sqlip).Tables[0];
                        #endregion
                        sqlop = string.Format(sqlop, txtInvCode.Text, dtip.Rows[0]["DBIpAddress"].ToString(), txtSOCode.Text);
                        DataTable dtop = DBHelper.ExecuteDataset(AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"), CommandType.Text, sqlop).Tables[0];
                        grvDetail.DataSource = dtop;
                        dtNewRcards = dtop;
                        //grdDetail.BestFitColumns();
                    }
                    #endregion
                    loadop();
                }
                #endregion
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.ToString());
            }
        }
        #endregion

        #region 加载工序
        private void loadop()
        {
            #region 工序代码
            string sqls = @"SELECT DISTINCT opcode as [工序代码],OPDESC as [工序名称]  FROM ICSOP WHERE WorkPoint='{0}'";
            sqls = string.Format(sqls, AppConfig.WorkPointCode);
            DataTable dts = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sqls).Tables[0];
            txtOPCode.Properties.ValueMember = "工序代码";
            txtOPCode.Properties.DisplayMember = "工序代码";
            txtOPCode.Properties.DataSource = dts;
            txtOPCode.Properties.NullText = "";//空时的值    
            txtOPCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体  
            txtOPCode.Properties.ValidateOnEnterKey = true;//回车确认  
            txtOPCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard  
            txtOPCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容 
            //自适应宽度
            txtOPCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
            #endregion
        }
        #endregion

        #region 工序代码
        private void txtOPCode_EditValueChanged(object sender, EventArgs e)
        {
            try
            {
                GridLookUpEdit edit = sender as GridLookUpEdit;
                if (edit.EditValue != null && edit.EditValue.ToString() != "" && edit.EditValue.ToString() != "nulltext")
                {
                    var o = edit.Properties.GetRowByKeyValue(edit.EditValue);
                    if (o is DataRowView)
                    {
                        DataRowView RowView = o as DataRowView;
                        //赋值
                        txtOPName.Text = RowView.Row["工序名称"].ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.ToString());
            }
        }
        #endregion

        #region 新增工序
        private void btnAdd_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtSOCode.Text == "")
                {
                    ICSBaseSimpleCode.AppshowMessageBox("销售订单号不能为空!");
                    return;
                }
                if (txtOPName.Text == "")
                {
                    ICSBaseSimpleCode.AppshowMessageBox("工序名不能为空!");
                    return;
                }
                #region 判断工序不能重复添加
                for (int i = 0; i < grdDetail.RowCount; i++)
                {
                    if (txtOPName.Text.Equals(grdDetail.GetRowCellValue(i, colQuotationItem).ToString()))
                    {
                        ICSBaseSimpleCode.AppshowMessageBox("工序:" + txtOPName.Text + ",在第" + Convert.ToInt32(i + 1) + "行已维护!");
                        return;
                    }
                }
                #endregion
                if (grdDetail.RowCount > 0)
                {
                    DataRow[] isRow = dtNewRcards.Select("QuotationItem= '材料费'");
                    if (isRow != null || isRow.Length > 0)
                    {
                        DataRow row = dtNewRcards.NewRow();
                        row["isSelect"] = "Y";
                        row["SOCode"] = txtSOCode.Text;//销售订单号
                        row["SORow"] = dtNewRcards.Rows.Count + 1;
                        row["InvCode"] = txtInvCode.Text;
                        row["InvName"] = txtInvName.Text;
                        row["DNumber"] = txtDNumber.Text;//图号
                        row["QuotationItem"] = txtOPName.Text;//报价项目
                        row["OpCode"] = txtOPCode.Text;//工序
                        if (guid == "")
                        {
                            row["SingleMoney"] = "";
                        }
                        else
                        {
                            row["SingleMoney"] = 0;
                        }
                        row["Memo"] = txtMemo.Text;
                        dtNewRcards.Rows.Add(row);
                        grvDetail.DataSource = dtNewRcards;
                        //grdDetail.BestFitColumns();
                    }
                }
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.ToString());
            }
        }
        #endregion

        #region 保存
        private void btnSave_Click(object sender, EventArgs e)
        {
            DevExpress.Utils.WaitDialogForm _wait = new DevExpress.Utils.WaitDialogForm("正在查找...请稍等...");
            try
            {
                _wait.Show();
                List<XS001_0001_E001_2020> SoMainList = new List<XS001_0001_E001_2020>();
                List<XS001_0001_E002_2020> SoDetailLIist = new List<XS001_0001_E002_2020>();
                XS001_0001_E001_2020 SoMain = new XS001_0001_E001_2020();
                SoMain.ID = txtCode.Text;//单据号
                if (guid != "")
                {
                    SoMain.cSOCode = SoCode;//销售订单号
                }
                else
                {
                    SoMain.cSOCode = txtSOCode.Text;//销售订单号
                }
                SoMain.cCusName = txtCusName.Text;//客户名称
                SoMain.cSoType = txtSOType.Text;//销售类型
                SoMain.iNum = Convert.ToDecimal(txtNumber.Text);//数量
                if (txtSumSingleMoney.Text == "")
                {
                    SoMain.iPrice = 0;
                }
                else
                {
                    SoMain.iPrice = Convert.ToDecimal(txtSumSingleMoney.Text);//产品单价
                }
                SoMain.cInvCode = txtInvCode.Text;//存货编码
                SoMain.cInvName = txtInvName.Text;//存货名称
                SoMain.cInvStd = txtDNumber.Text;//图号
                SoMain.cinvtype = txtOpQuire.Text;//工艺要求
                SoMain.iWeight = Convert.ToDecimal(txtWeight.Text);//重量
                SoMain.cMake = AppConfig.UserName;//维护人
                SoMain.dMakeTime = AppConfig.GetSeverDateTime("yyyy-MM-dd HH:mm:ss");//维护时间
                SoMain.dDate = Convert.ToDateTime(txtdDate.Text);//销售订单日期
                SoMainList.Add(SoMain);
                for (int i = 0; i < grdDetail.RowCount; i++)
                {
                    if (grdDetail.GetRowCellValue(i, colisSelect).ToString() == "Y")
                    {
                        XS001_0001_E002_2020 SoDetail = new XS001_0001_E002_2020();
                        SoDetail.RefMainID = txtCode.Text;//单据号
                        if (guid == "")
                        {
                            SoDetail.RefRowID = Convert.ToString(i + 1);//行号
                        }
                        else
                        {
                            SoDetail.RefRowID = grdDetail.GetRowCellValue(i, colSORow).ToString();//行号
                        }
                        SoDetail.cInvCode = grdDetail.GetRowCellValue(i, colInvCode).ToString();//存货编码
                        SoDetail.cInvName = grdDetail.GetRowCellValue(i, colInvName).ToString();//存货名称
                        SoDetail.cInvStd = grdDetail.GetRowCellValue(i, colDNumber).ToString();//图号
                        SoDetail.cItem = grdDetail.GetRowCellValue(i, colQuotationItem).ToString();//报价项目
                        SoDetail.XS001_0001_E001_PK = Convert.ToString(grdDetail.GetRowCellValue(i, colOpCode).ToString());//工序
                        if (string.IsNullOrWhiteSpace(grdDetail.GetRowCellValue(i, colSingleMoney).ToString()))
                        {
                            SoDetail.iPrice = 0;
                        }
                        else
                        {
                            SoDetail.iPrice = Convert.ToDecimal(grdDetail.GetRowCellValue(i, colSingleMoney).ToString());//含税单价
                        }
                        SoDetail.UAP_VoucherTransform_Rowkey = txtMemo.Text;//备注
                        SoDetailLIist.Add(SoDetail);
                    }
                }
                if (SoMainList.Count <= 0)
                {
                    _wait.Close();
                    ICSBaseSimpleCode.AppshowMessageBox("请选择数据!!!");
                    return;
                }
                ICSSOPriceSheetBLL.Add(SoMainList, SoDetailLIist, AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"));
                _wait.Close();
                ICSBaseSimpleCode.AppshowMessageBox("保存成功");
                this.Close();
                FormICSINVENTORYEditAdd_Load(null,null);
            }
            catch (Exception ex)
            {
                _wait.Close();
                ICSBaseSimpleCode.AppshowMessageBox(ex.ToString());
            }
        }
        #endregion

        #region 删除
        private void btnDelete_Click(object sender, EventArgs e)
        {
            grdDetail.PostEditor();
            this.Validate();
            if (grdDetail.RowCount == 0)
                return;
            string code = "";
            string row = "";
            if (grdDetail.GetRowCellValue(grdDetail.FocusedRowHandle, colQuotationItem).ToString() == "材料费" && grdDetail.GetRowCellValue(grdDetail.FocusedRowHandle, colSORow).ToString() == "1")
            {
                ICSBaseSimpleCode.AppshowMessageBox("第一行材料费数据不能删除!!!");
                return;
            }
            for (int i = 0; i < grdDetail.RowCount; i++)
            {
                if (grdDetail.GetRowCellValue(i, colisSelect).ToString() == "Y")
                {
                    code = grdDetail.GetRowCellValue(i, colSOCode).ToString();
                    row = grdDetail.GetRowCellValue(i, colSORow).ToString();
                }
            }
            if (code=="")
            {
                ICSBaseSimpleCode.AppshowMessageBox("请选择数据！");
                return;
            }
            if (ICSBaseSimpleCode.AppshowMessageBoxRepose("确定删除该行信息吗？删除后无法恢复，确定吗？") != DialogResult.OK)
                return;
            try
            {
                ICSSOPriceSheetBLL.deleteDetailInfo(code, row, AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"));
                ICSBaseSimpleCode.AppshowMessageBox(0, "删除成功");
                FormICSINVENTORYEditAdd_Load(null,null);
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.ToString());
            }
        }
        #endregion

        #region 删除窗体行
        private void repositoryItemButtonEdit4_Click(object sender, EventArgs e)
        {
            if (grdDetail.GetRowCellValue(grdDetail.FocusedRowHandle, colQuotationItem).ToString() == "材料费" && grdDetail.GetRowCellValue(grdDetail.FocusedRowHandle, colSORow).ToString()=="1")
            {
                ICSBaseSimpleCode.AppshowMessageBox("第一行材料费数据不能删除!!!");
                return;
            }
            grdDetail.DeleteRow(grdDetail.FocusedRowHandle);
        }
        #endregion

        #region 双击
        private void grdDetail_DoubleClick(object sender, EventArgs e)
        {
            if (grdDetail.FocusedRowHandle < 0)
            {
                return;
            }
            for (int i = 0; i < grdDetail.RowCount; i++)
            {
                grdDetail.SetRowCellValue(i, colisSelect, "");
            }
            if (grdDetail.FocusedColumn == colisSelect)
            {
                if (grdDetail.GetRowCellValue(grdDetail.FocusedRowHandle, colisSelect).ToString() == "")
                {
                    grdDetail.SetRowCellValue(grdDetail.FocusedRowHandle, colisSelect, "Y");
                }
                else
                {
                    grdDetail.SetRowCellValue(grdDetail.FocusedRowHandle, colisSelect, "");
                }
            }
            string code = "";
            string row = "";
            for (int i = 0; i < grdDetail.RowCount; i++)
            {
                if (grdDetail.GetRowCellValue(i, colisSelect).ToString() == "Y")
                {
                    code = grdDetail.GetRowCellValue(i, colSOCode).ToString();
                    row = grdDetail.GetRowCellValue(i, colSORow).ToString();
                }
            }
            DataTable dt = ICSSOPriceSheetBLL.GetDetailInfo(code, row, AppConfig.GetDataBaseConnectStringByKey("[DB.ERP]"));
            foreach (DataRow dr in dt.Rows)
            {
                txtOPCode.Text = dr["XS001_0001_E001_PK"].ToString().Trim();
                txtOPName.Text = dr["XS001_0001_E002_PK"].ToString().Trim();
                txtMemo.Text = dr["UAP_VoucherTransform_Rowkey"].ToString().Trim();
                txtOPCode.Enabled = false;
                txtMemo.Enabled = false;
            }
        }
        #endregion

        #region 计算含税单价
        private void grdDetail_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
        {
            try
            {
                if (e.Column.FieldName == "SingleMoney")
                {
                    decimal singlemoney=0;
                    decimal summoney = 0;
                    if (string.IsNullOrWhiteSpace(grdDetail.GetRowCellValue(e.RowHandle, colSingleMoney).ToString()))
                    {
                        singlemoney = 0;
                    }
                    else
                    {
                        singlemoney = Convert.ToDecimal(grdDetail.GetRowCellValue(e.RowHandle, colSingleMoney).ToString());
                    }
                    if (txtSumMoney.Text == "0.00")
                    {
                        txtSumMoney.Text = Convert.ToString(0 + singlemoney);
                    }
                    else
                    {
                        for (int i = 0; i < grdDetail.RowCount; i++)
                        {
                            if (string.IsNullOrWhiteSpace(grdDetail.GetRowCellValue(i, colSingleMoney).ToString()))
                            {
                                summoney += 0;
                            }
                            else
                            {
                                summoney += Convert.ToDecimal(grdDetail.GetRowCellValue(i, colSingleMoney).ToString());
                            }
                        }
                        txtSumMoney.Text = Convert.ToString(summoney);
                    } 
                }
            }
            catch (Exception ex)
            {

                MessageBox.Show(ex.Message);
            }
        }
        #endregion

        #region 显示全部
        private void checkAll_Click(object sender, EventArgs e)
        {
            init();
            grvDetail.DataSource = null;
            txtSOCode.Text = "";
            txtSumSingleMoney.Text = "";
            txtdDate.Text = "";
            txtOpQuire.Text = "";
            txtCusName.Text = "";
            txtSOType.Text = "";
            txtNumber.Text = "";
            txtInvCode.Text = "";
            txtInvName.Text = "";
            txtDNumber.Text = "";
            txtWeight.Text = "";
            txtOPCode.Text = "";
            txtOPName.Text = "";
            txtMemo.Text = "";
        }
        #endregion

        private void txtSOCode_QueryPopUp(object sender, System.ComponentModel.CancelEventArgs e)
        {
            txtSOCode.Properties.View.Columns["ID"].Visible = false; //隐藏列
        }

        #region 新增存货编码
        private void btnAddInvName_Click(object sender, EventArgs e)
        {
            try
            {
                if (txtcInvCode.Text == "")
                {
                    ICSBaseSimpleCode.AppshowMessageBox("存货编码不能为空!");
                    return;
                }
                if (grdDetail.RowCount > 0)
                {
                    DataRow[] isRow = dtNewRcards.Select("QuotationItem= '材料费'");
                    if (isRow != null || isRow.Length > 0)
                    {
                        DataRow row = dtNewRcards.NewRow();
                        row["isSelect"] = "Y";
                        row["SOCode"] = txtSOCode.Text;//销售订单号
                        row["SORow"] = dtNewRcards.Rows.Count + 1;
                        row["InvCode"] = txtcInvCode.Text;//存货编码
                        row["InvName"] = txtcInvName.Text;//存货名称
                        row["DNumber"] = txtcInvstd.Text;//图号
                        row["QuotationItem"] = "材料费";//报价项目
                        row["OpCode"] = "CL";//工序
                        if (guid == "")
                        {
                            row["SingleMoney"] = "";
                        }
                        else
                        {
                            row["SingleMoney"] = 0;
                        }
                        row["Memo"] = "";
                        for (int i = 0; i < grdDetail.RowCount; i++)
                        {
                            if (grdDetail.GetRowCellValue(i, colInvCode).ToString().Equals(txtcInvCode.Text) && row["QuotationItem"].Equals(grdDetail.GetRowCellValue(i, colQuotationItem).ToString()))
                            {
                                ICSBaseSimpleCode.AppshowMessageBox("存货编码:" + txtcInvCode.Text + ",报价项目:材料费,在第" + Convert.ToInt32(i + 1) + "行已维护!");
                                return;
                            }
                        }
                        dtNewRcards.Rows.Add(row);
                        grvDetail.DataSource = dtNewRcards;
                        //grdDetail.BestFitColumns();
                    }
                }
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.ToString());
            }
        }
        #endregion

        #region 存货编码改变
        private void txtcInvCode_EditValueChanged(object sender, EventArgs e)
        {
            try
            {
                GridLookUpEdit edit = sender as GridLookUpEdit;
                if (edit.EditValue != null && edit.EditValue.ToString() != "" && edit.EditValue.ToString() != "nulltext")
                {
                    var o = edit.Properties.GetRowByKeyValue(edit.EditValue);
                    if (o is DataRowView)
                    {
                        DataRowView RowView = o as DataRowView;
                        txtcInvName.Text = RowView.Row["存货名称"].ToString();
                        txtcInvstd.Text = RowView.Row["图号"].ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                ICSBaseSimpleCode.AppshowMessageBox(ex.ToString());
            }
        }
        #endregion
    }
}