MES_Client/TGMES/Core.StlMes.Client.SaleOrder/ReviewForm/frmInsidePriceCarry.cs

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;
using CoreFS.CA06;
using Core.StlMes.Client.SaleOrder;
using System.Collections;
using Core.Mes.Client.Comm.Control;
using Core.StlMes.Client.SaleComm;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Tool;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.SaleOrder.ReviewForm;
using Core.StlMes.Client.SaleOrder.Dialog;
using Core.Mes.Client.Comm;
using Infragistics.Win;
using System.Text.RegularExpressions;

namespace Core.StlMes.Client.SaleOrder
{
    public partial class frmInsidePriceCarry : FrmBase
    {
        public frmInsidePriceCarry()
        {
            InitializeComponent();
            this.IsLoadUserView = true;
        }

        private void frmInsidePriceCarry_Load(object sender, EventArgs e)
        {
            DateTime Today = DateTime.Now;
            this.date_starte.DateTime = Today.Date.AddMonths(-1);
            this.date_end.DateTime = DateTime.Today;
            GridHelper.SetColumnsActivateAndColor(efforder_seq.Rows.Band, "CARRY_USE");
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "doQuery":
                    doQuery();
                    break;
                case "doSaveCarry":
                    doSaveCarry();
                    break;
                case "doClose":
                    this.Close();
                    break;
            }
        }

        private void doSaveCarry()
        {
            if (gffect_oder.ActiveRow == null)
                return;
            try
            {
                efforder_seq.UpdateData();
            }
            catch { }
            string ordPk = gffect_oder.ActiveRow.Cells["ORD_PK"].Value.ToString();
            ArrayList parm = new ArrayList();
            foreach (UltraGridRow row in efforder_seq.Rows)
            {
                double wgt = 0;
                if (!double.TryParse(row.Cells["CARRY_USE"].Value.ToString(), out wgt))
                {
                    MessageUtil.ShowTips("结转重量填写错误或未填写");
                    return;
                }
                if (wgt == 0)
                {
                    MessageUtil.ShowTips("结转重量不能为0");
                    return;
                }
                ArrayList list = new ArrayList();
                list.Add(row.Cells["BALNCE_PRICE_ORG"].Value.ToString());
                list.Add(row.Cells["CARRY_USE"].Value.ToString());
                list.Add(row.Cells["CARRY_MONEY"].Value.ToString());
                list.Add(row.Cells["ORD_LN_PK"].Value.ToString());
                parm.Add(list);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.sale.order.frmOrderEffect";
            ccp.MethodName = "saveCarryOrgInfo";
            ccp.ServerParams = new object[] { parm ,UserInfo.GetUserName()};
            ccp.IfShowErrMsg = false;
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp != null)
            {
                if (ccp.ReturnCode == -1)
                {
                    MessageUtil.ShowWarning(ccp.ReturnInfo);
                    return;
                }
                MessageUtil.ShowTips("结转成功！");
                doQuery();
                foreach (UltraGridRow row in gffect_oder.Rows)
                {
                    if (ordPk.Equals(row.Cells["ORD_PK"].Value.ToString()))
                    {
                        row.Activate();
                        break;
                    }
                }
            }
        }


        public void doQuery()
        {
            //签约时间
            string date = "";
            String orderStart = "";
            String orderEnd = "";
            if (che_date.Checked)
            {
                orderStart = Convert.ToDateTime(date_starte.Value).ToString("yyyy-MM-dd") + " 00:00:01";
                orderEnd = Convert.ToDateTime(date_end.Value).ToString("yyyy-MM-dd") + " 23:59:59";
            }
            else 
            { 
                orderStart = "1000-01-01 00:00:01";
                orderEnd = "9999-12-31 23:59:59";
            }


            //合同号
            string order = "";
            if (ord_no.Checked)
                order = orde_cho.Text.Trim();
            DataTable dt = Globals.GetData("com.steering.pss.sale.order.frmOrderEffect.CoreOrderCarryPriceQuery", new Object[] { order, orderStart, orderEnd }, this.ob);
            gffect_oder.DataSource = dt;
            //列自适应
            GridHelper.RefreshAndAutoSizeExceptColumns(gffect_oder, new UltraGridColumn[] { });

        }


        private void che_date_CheckedChanged(object sender, EventArgs e)
        {
            date_starte.Enabled = che_date.Checked;
            date_end.Enabled = che_date.Checked;
        }

        private void ord_no_CheckedChanged(object sender, EventArgs e)
        {
            orde_cho.Enabled = ord_no.Checked;
        }

        private void gffect_oder_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = gffect_oder.ActiveRow;
            if (ugr == null)
                return;
            this.doQueryeffect(gffect_oder.ActiveRow.Cells["ORD_PK"].Text);
            this.doQueryeffect_mol(gffect_oder.ActiveRow.Cells["ORDER_MODEL_NO"].Value.ToString());
            this.queryPriceInfo(gffect_oder.ActiveRow.Cells["ORD_PK"].Text);
        }

        private void queryPriceInfo(string ordPk)
        {
            DataTable dt = ServerHelper.GetData("com.steering.pss.sale.order.frmOrderEffect.queryPriceInfo", new object[] { ordPk }, this.ob);
            if (dt != null && dt.Rows.Count > 0)
            {
                txtPrice.Text = dt.Rows[0][0].ToString();
            }
        }

        private void doQueryeffect_mol(string ordermodel)
        {

            DataTable dt = Globals.GetData("com.steering.pss.sale.order.frmOrderEffect.CoreOrderEffectinfo", new Object[] { ordermodel }, this.ob);
            efforder_mol.DataSource = dt;

            //列自适应
            GridHelper.RefreshAndAutoSizeExceptColumns(efforder_mol, new UltraGridColumn[] {
                
            });
        }
        private void doQueryeffect(string order)
        {

            DataTable dt = Globals.GetData("com.steering.pss.sale.order.frmOrderEffect.CoreOrderCarrySqeQuery", new Object[] { order }, this.ob);
            GridHelper.CopyDataToDatatable(ref dt, ref this.orderLineDt, true);
            foreach (DataRow dr in orderLineDt.Rows)
            {
                double actWt = 0;
                double carryWt = 0;
                if (!double.TryParse(dr["ACT_WT"].ToString(), out actWt))
                    return;
                if (!double.TryParse(dr["CARRY_WT"].ToString(), out carryWt))
                    return;
                dr["CARRY_USE"] = Math.Round(actWt - carryWt, 4);
            }
            //列自适应
            GridHelper.RefreshAndAutoSizeExceptColumns(efforder_seq, new UltraGridColumn[] { });

        }

        private void gffect_oder_ClickCellButton(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            string acustom = gffect_oder.ActiveCell.Value.ToString();
            dlgBuyerInfo spt = new dlgBuyerInfo();
            spt.oPbd = this.ob;
            spt.customer = acustom;
            spt.FilePath = "checker";
            spt.ShowDialog();
        }

        private void efforder_seq_AfterRowActivate(object sender, EventArgs e)
        {
            if (efforder_seq.ActiveRow != null)
            {
                DataTable dt = Globals.GetData("com.steering.pss.sale.order.frmOrderEffect.CoreOrderCarryOrgInfo", new Object[] { efforder_seq.ActiveRow.Cells["ORD_LN_PK"].Value.ToString() }, this.ob);
                GridHelper.CopyDataToDatatable(ref dt, ref this.carryOrg, true);
                //列自适应
                GridHelper.RefreshAndAutoSizeExceptColumns(carry_price, new UltraGridColumn[] { });
            }
        }


        private void orde_cho_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (e.KeyChar == 13)
                doQuery();
        }


        private void efforder_seq_CellDataError(object sender, CellDataErrorEventArgs e)
        {
            e.RaiseErrorEvent = false;       // 阻止弹出错误提示窗口
            e.RestoreOriginalValue = true;   // 恢复原始值
            e.StayInEditMode = true;         // 继续保留在编辑模式
        }

    }
}