MES_Client/TGMES/Core.StlMes.Client.PnCost/frmBaseProcessBzcost.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.PnCost.Models;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
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 Core.StlMes.Client.PnCost
{
    public partial class frmBaseProcessBzcost : FrmBase
    {
        #region  定义变量

        public frmBaseProcessBzcost()
        {
            InitializeComponent();
        }

        private DataTable dtpline;
        #endregion

        #region  初始化
        private void frmBaseProcesscost_Load(object sender, EventArgs e)
        {
            this.ultraGrid1.DisplayLayout.Bands[0].Columns["ORD_NO"].MergedCellStyle = MergedCellStyle.Always;
            Query();
        }

        #endregion

        #region  方法

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            base.ToolBar_Click(sender, ToolbarKey);
            switch (ToolbarKey)
            {
                case "Query":
                    Query();
                    break;
                case "doCs":
                    doCS();
                    break;
                case "Calculate":
                    Calculate();
                    break;
                case "doSee":
                    DoSee();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(ultraGrid1, "钢级信息");
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        /// 查询方法
        /// <summary>
        /// 查询方法
        /// </summary>
        private void Query()
        {
            //eginDate.ToString("yyyyMMdd")
            #region 条件验证
            string httext = this.htText.Text.Trim();
            string startTime = this.dateTimePicker1.Value.ToString("yyyyMMdd");
            string endTime = this.dateTimePicker2.Value.ToString("yyyyMMdd");
            string askplanIdText = this.askplanIdText.Text.Trim();
            #endregion
            DataTable data = ServerHelper.GetData("com.steering.mes.cost.FrmBalance.Query",
                 new object[] { httext, startTime, endTime, askplanIdText,this.CustomInfo }, ob);
            dataTable1.Clear();
            GridHelper.CopyDataToDatatable(data, dataTable1, true);
            if (ultraGrid1.Rows.Count == 0)
            {
                return;
            }
            ultraGrid1.UpdateData();
            ultraGrid1.ActiveRow = ultraGrid1.Rows[0];
        }

        private void Calculate()
        {
            try
            {
                ultraGrid1.UpdateData();
                UltraGridRow row = ultraGrid1.ActiveRow;
                if (row == null) return;
                string tiaoshu = "";
                if(this.ultraCheckEditor1.Checked && this.comboBox1.Text != ""){
                    tiaoshu = this.comboBox1.Text;
                }
                if (tiaoshu == null && tiaoshu.Equals("")) {
                    MessageUtil.ShowError("请选择测算的条数");
                }
                ServerHelper.SetData("com.steering.mes.cost.FrmBalance.CalculateAll", new object[] { this.UserInfo.GetUserName(), tiaoshu,this.CustomInfo }, ob);
            }
            catch (Exception ex)
            {
                MessageUtil.ShowError("测算失败" + ex.Message + "'");
                return;
            }
            MessageUtil.ShowTips("测算成功!");
            Query();
        }
        /// 保存方法
        /// <summary>
        /// 保存方法
        /// </summary>
        private void doCS()
        {
            try
            {
                ultraGrid1.UpdateData();
                UltraGridRow row = ultraGrid1.ActiveRow;
                if (row == null) return;
                foreach (UltraGridRow item in ultraGrid1.Rows)
                {
                    if (Convert.ToBoolean(item.Cells["CHECK"].Text) == true)
                    {
                        string ordNo = item.Cells["ORD_NO"].Value.ToString().Trim();
                        string ordSeq = item.Cells["ORD_SEQ"].Value.ToString().Trim();
                        string spetkey = item.Cells["SPETKEY"].Value.ToString().Trim();
                        string steelName = item.Cells["STEELNAME"].Value.ToString().Trim();
                        string askplanId = item.Cells["ASKPLAN_ID"].Value.ToString().Trim();
                        string kx = item.Cells["MODEL_DESC"].Value.ToString().Trim();
                        string waijin = item.Cells["WAIJIN"].Value.ToString().Trim();
                        string bihou = item.Cells["BIHOU"].Value.ToString().Trim();
                        string stoveNo = item.Cells["STOVE_NO"].Value.ToString().Trim();
                        string id = item.Cells["ID"].Value.ToString().Trim();
                        string money = item.Cells["MONEY"].Value.ToString().Trim();
                        string userName = this.UserInfo.GetUserName();
                        ServerHelper.SetData("com.steering.mes.cost.FrmBalance.Calculate", new object[] { ordNo, ordSeq, userName, steelName, spetkey,
                                                                                                          askplanId, kx, waijin, bihou, stoveNo, id,this.CustomInfo,money }, ob);
                    }
                }
            }
            catch (Exception ex)
            {
                MessageUtil.ShowError("测算失败" + ex.Message + "'");
                return;
            }
            MessageUtil.ShowTips("测算成功!");
            Query();
        }
        /// 删除方法
        /// <summary>
        /// 删除方法
        /// </summary>
        private void DoSee()
        {

            this.ultraGrid1.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True'");
            if (checkMagRows.Count() > 1)
            {
                MessageUtil.ShowTips("选择的条数有误！");
                return;
            }
            string strurl = "";
            foreach (UltraGridRow uRow in checkMagRows)
            {
                string processCode = uRow.Cells["PROCESS_CODE"].Value.ToString();
                strurl = "http://172.16.2.137:8081/webroot/decision/view/report?viewlet=tqnqd06bz.cpt" + "&processCode=" + processCode; //+ "&BILL_NO=" + BillNo + "&NAME=" + this.UserInfo.GetUserName();
                FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
                fBug.AutoSize = true;
                fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
                fBug.WindowState = FormWindowState.Maximized;
                fBug.Text = "标准成本测算";
                fBug.Show();
            }
        }

        private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e)
        {
            comboBox1.Enabled = this.ultraCheckEditor1.Checked;
        }

    }
    #endregion
}