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;
}
}
/// 查询方法
///
/// 查询方法
///
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();
}
/// 保存方法
///
/// 保存方法
///
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();
}
/// 删除方法
///
/// 删除方法
///
private void DoSee()
{
this.ultraGrid1.UpdateData();
IQueryable 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
}