using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Globalization;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Mcp.Control.Entity;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using System.Collections;
using Core.StlMes.Client.Mcp.Mch.McmZj;
using Core.Mes.Client.Comm.Format;
namespace Core.StlMes.Client.Mcp.Mch.MchResult
{
public partial class FrmZjResult : FrmBase
{
private string _judgeStove = "";
private string _batchNo = "";
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
ultraGridPlan.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
baseinfoZj1.UltraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
informationZj1.UltraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
ultraGrid1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
foreach (UltraGridColumn ugc in ultraGridPlan.DisplayLayout.Bands[0].Columns)
{
ugc.SortIndicator = SortIndicator.Disabled;
}
//PanelSizeFlag = 0;
}
public FrmZjResult()
{
InitializeComponent();
//GridHelper.InitCardGrid(dataSet1, ultraGridPlan);//显示人工质检主信息界面
}
///
/// ToolBar按钮
///
///
///
public override void ToolBar_Click(object sender, string ToolbarKey)
{
switch (ToolbarKey)
{
case "DoQuery":
PlanQuery();
break;
case "DoAdd":
ResultSave();
break;
case "DoDelete":
DoDelete();
break;
case "Exp":
Doexp();
break;
case "Close":
this.Dispose();
this.Close();
break;
}
}
///
/// 获取grid 所有勾选的行
///
///
/// 复选框所在列名
///
public static List UltraGridGetChooseRows(UltraGrid grid)
{
grid.UpdateData();
List list = new List();
RowsCollection rows = grid.Rows;
foreach (var item in rows)
{
try
{
if (Convert.ToBoolean(item.Cells["check"].Value) == true)
{
list.Add(item);
}
}
catch { }
}
return list;
}
public List getplnZyZjc()
{
List ls = new List();
this.ultraGrid1.UpdateData();
List listRow = UltraGridGetChooseRows(ultraGrid1);
foreach (UltraGridRow ultraGridRow in listRow)
{
ArrayList plnZyZjc = new ArrayList();
string heatPlanSqe = ultraGridRow.Cells["HEAT_PLAN_SQE"].Value.ToString();
string judgeStoveNo = ultraGridRow.Cells["JUDGE_STOVE_NO"].Value.ToString();
string pipeEndOd1 = ultraGridRow.Cells["PIPE_END_OD1"].Value.ToString();
string pipeEndOd2 = ultraGridRow.Cells["PIPE_END_OD2"].Value.ToString();
string pipeEndOutOfRoundness = ultraGridRow.Cells["PIPE_END_OUT_OF_ROUNDNESS"].Value.ToString();
string pipeEndMm = ultraGridRow.Cells["PIPE_END_MM"].Value.ToString();
string pipeEndS1 = ultraGridRow.Cells["PIPE_END_S1"].Value.ToString();
string pipeEndS2 = ultraGridRow.Cells["PIPE_END_S2"].Value.ToString();
string pipeEndS3 = ultraGridRow.Cells["PIPE_END_S3"].Value.ToString();
string pipeEndS4 = ultraGridRow.Cells["PIPE_END_S4"].Value.ToString();
string pipeEndBevel = ultraGridRow.Cells["PIPE_END_BEVEL"].Value.ToString();
string pipeEndRootFace = ultraGridRow.Cells["PIPE_END_ROOT_FACE"].Value.ToString();
string pipeEndOutOfSquareness = ultraGridRow.Cells["PIPE_END_OUT_OF_SQUARENESS"].Value.ToString();
string pipeEndResiMag = ultraGridRow.Cells["PIPE_END_RESI_MAG"].Value.ToString();
string pipeBodyOd1 = ultraGridRow.Cells["PIPE_BODY_OD1"].Value.ToString();
string pipeBodyOd2 = ultraGridRow.Cells["PIPE_BODY_OD2"].Value.ToString();
string pipeBodyOutOfRoundness = ultraGridRow.Cells["PIPE_BODY_OUT_OF_ROUNDNESS"].Value.ToString();
string pipeBodyMm = ultraGridRow.Cells["PIPE_BODY_MM"].Value.ToString();
string isDecide = ultraGridRow.Cells["IS_DECIDE"].Value.ToString();
string pipeBodyLengs = ultraGridRow.Cells["PIPE_BODY_LENGS"].Value.ToString();
string pipeEndOd1B = ultraGridRow.Cells["PIPE_END_OD1_B"].Value.ToString();
string pipeEndOd2B = ultraGridRow.Cells["PIPE_END_OD2_B"].Value.ToString();
string pipeEndOutOfRoundnessB = ultraGridRow.Cells["PIPE_END_OUT_OF_ROUNDNESS_B"].Value.ToString();
string pipeEndMmB = ultraGridRow.Cells["PIPE_END_MM_B"].Value.ToString();
string pipeEndS1B = ultraGridRow.Cells["PIPE_END_S1_B"].Value.ToString();
string pipeEndS2B = ultraGridRow.Cells["PIPE_END_S2_B"].Value.ToString();
string pipeEndS3B = ultraGridRow.Cells["PIPE_END_S3_B"].Value.ToString();
string pipeEndS4B = ultraGridRow.Cells["PIPE_END_S4_B"].Value.ToString();
string pipeEndBevelB = ultraGridRow.Cells["PIPE_END_BEVEL_B"].Value.ToString();
string pipeEndRootFaceB = ultraGridRow.Cells["PIPE_END_ROOT_FACE_B"].Value.ToString();
string pipeEndOutOfSquarenessB = ultraGridRow.Cells["PIPE_END_OUT_OF_SQUARENESS_B"].Value.ToString();
string pipeEndResiMagB = ultraGridRow.Cells["PIPE_END_RESI_MAG_B"].Value.ToString();
string pipeEndResiMag2 = ultraGridRow.Cells["PIPE_END_RESI_MAG_2"].Value.ToString();
string pipeEndResiMag3 = ultraGridRow.Cells["PIPE_END_RESI_MAG_3"].Value.ToString();
string pipeEndResiMag4 = ultraGridRow.Cells["PIPE_END_RESI_MAG_4"].Value.ToString();
string pipeEndResiMag2B = ultraGridRow.Cells["PIPE_END_RESI_MAG_2_B"].Value.ToString();
string pipeEndResiMag3B = ultraGridRow.Cells["PIPE_END_RESI_MAG_3_B"].Value.ToString();
string pipeEndResiMag4B = ultraGridRow.Cells["PIPE_END_RESI_MAG_4_B"].Value.ToString();
plnZyZjc.Add(heatPlanSqe);
plnZyZjc.Add(judgeStoveNo);
plnZyZjc.Add(pipeEndOd1);
plnZyZjc.Add(pipeEndOd2);
plnZyZjc.Add(pipeEndOutOfRoundness);
plnZyZjc.Add(pipeEndMm);
plnZyZjc.Add(pipeEndS1);
plnZyZjc.Add(pipeEndS2);
plnZyZjc.Add(pipeEndS3);
plnZyZjc.Add(pipeEndS4);
plnZyZjc.Add(pipeEndBevel);
plnZyZjc.Add(pipeEndRootFace);
plnZyZjc.Add(pipeEndOutOfSquareness);
plnZyZjc.Add(pipeEndResiMag);
plnZyZjc.Add(pipeBodyOd1);
plnZyZjc.Add(pipeBodyOd2);
plnZyZjc.Add(pipeBodyOutOfRoundness);
plnZyZjc.Add(isDecide);
plnZyZjc.Add(pipeBodyLengs);
plnZyZjc.Add(pipeBodyMm);
plnZyZjc.Add(pipeEndOd1B);
plnZyZjc.Add(pipeEndOd2B);
plnZyZjc.Add(pipeEndOutOfRoundnessB);
plnZyZjc.Add(pipeEndMmB);
plnZyZjc.Add(pipeEndS1B);
plnZyZjc.Add(pipeEndS2B);
plnZyZjc.Add(pipeEndS3B);
plnZyZjc.Add(pipeEndS4B);
plnZyZjc.Add(pipeEndBevelB);
plnZyZjc.Add(pipeEndRootFaceB);
plnZyZjc.Add(pipeEndOutOfSquarenessB);
plnZyZjc.Add(pipeEndResiMagB);
plnZyZjc.Add(pipeEndResiMag2);
plnZyZjc.Add(pipeEndResiMag3);
plnZyZjc.Add(pipeEndResiMag4);
plnZyZjc.Add(pipeEndResiMag2B);
plnZyZjc.Add(pipeEndResiMag3B);
plnZyZjc.Add(pipeEndResiMag4B);
ls.Add(plnZyZjc);
}
return ls;
}
public void CopyDataToDatatableplnZyZjc(string judgeStoveNo)
{
if (judgeStoveNo == null)
{
return;
}
dtPipeSize.Rows.Clear();
DataTable dtDtail = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmZjResult.getQueryZjc", new object[] { judgeStoveNo }, this.ob);
GridHelper.CopyDataToDatatable(ref dtDtail, ref dtPipeSize, true);
}
///
/// 计划查询
///
public void PlanQuery()
{
string PrimaKey = txtJudgeStoveNo.Text.ToString();
//查询计划记录
DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmZjResult.getQueryZjBaseInfo", new object[] { PrimaKey }, this.ob);
if (dt.Rows.Count == 0)
{
if (ShowMessageFlag == 0)
{
MessageBox.Show("未查询到匹配的数据,请重新查询!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
return;
}
GridHelper.CopyDataToDatatable(ref dt, ref dtPlan, true);
_judgeStove = dt.Rows[0]["JUDGE_STOVE_NO"].ToString();
baseinfoZj1.CopyDataToDatatableBseinfo(dt);
informationZj1.CopyDataToDatatableplnZyZjDtail(dt,this.ob);
CopyDataToDatatableplnZyZjc(dt.Rows[0]["JUDGE_STOVE_NO"].ToString());
}
///
/// 保存
///
public void ResultSave()
{
//基础信息
ArrayList plnZyZjm = getplinZyZjm();
//详情表
ArrayList plnZyZjcDtail = informationZj1.getplinZyZjdetal();
//管号详情表
List plnZyZjc = getplnZyZjc();
if (informationZj1.isReturn == false)
{
MessageBox.Show("输入支数错误", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageUtil.ShowYesNoAndQuestion("是否保存?") == DialogResult.No)
return;
var ccp = new CoreClientParam();
ccp.ServerName = "com.steering.mes.mcp.Mch.FrmZjResult";
ccp.MethodName = "doSaveZjRusult";
ccp.ServerParams = new object[]
{
plnZyZjm, plnZyZjcDtail,plnZyZjc
};
ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
MessageUtil.ShowTips(ccp.ReturnInfo);
PlanQuery();
}
}
private void Doexp()
{
UltraGridRow row = ultraGridPlan.ActiveRow;
string jugeNo = row.Cells["JUDGE_STOVE_NO"].Value.ToString();
string zjid = row.Cells["ZJID"].Value.ToString();
if (zjid.Equals("")) return;
string strurl = "http://172.54.10.42:8080/webroot/decision/view/report?op=write&viewlet=SteelPipeFinalInspectionReport.cpt&zjId=" + zjid + "&stoNo=" + jugeNo;
if (zjid.Equals("")) return;
var fre = new FrmRepExcel(ob, strurl);
fre.AutoSize = true;
fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
fre.WindowState = FormWindowState.Maximized;
fre.Show();
}
public ArrayList getplinZyZjm()
{
ArrayList plnZyZjm = new ArrayList();
baseinfoZj1.UltraGrid4.UpdateData();
UltraGridRow ultraGridPlans = ultraGridPlan.ActiveRow;
UltraGridRow ultraGridBaseinfo = baseinfoZj1.UltraGrid4.ActiveRow;
//基础信息
string judgeStove = ultraGridPlans.Cells["JUDGE_STOVE_NO"].Value.ToString();
string orderNo = ultraGridPlans.Cells["ORDER_NO"].Value.ToString();
string specName = ultraGridPlans.Cells["SPEC_NAME"].Value.ToString();
string gradename = ultraGridPlans.Cells["GRADENAME"].Value.ToString();
string steelname = ultraGridPlans.Cells["STEELNAME"].Value.ToString();
string producname = ultraGridPlans.Cells["PRODUCNAME"].Value.ToString();
string stdName = ultraGridPlans.Cells["STD_NAME"].Value.ToString();
string length = ultraGridBaseinfo.Cells["LENGTH"].Value.ToString();
string coating = ultraGridBaseinfo.Cells["COATING"].Value.ToString();
string protector = ultraGridBaseinfo.Cells["PROTECTOR"].Value.ToString();
string marking = ultraGridBaseinfo.Cells["MARKING"].Value.ToString();
string bachNo = ultraGridBaseinfo.Cells["lotNo"].Value.ToString();
string resiMag = ultraGridBaseinfo.Cells["Resimag"].Value.ToString();
string zjid = ultraGridPlans.Cells["ZJID"].Value.ToString();
_batchNo = bachNo;
plnZyZjm.Add(judgeStove);
plnZyZjm.Add(bachNo);
plnZyZjm.Add(specName);
plnZyZjm.Add(gradename);
plnZyZjm.Add(steelname);
plnZyZjm.Add(orderNo);
plnZyZjm.Add(producname);
plnZyZjm.Add(stdName);
plnZyZjm.Add(length);
plnZyZjm.Add(coating);
plnZyZjm.Add(protector);
plnZyZjm.Add(marking);
plnZyZjm.Add(resiMag);
plnZyZjm.Add(zjid);
return plnZyZjm;
}
private void DoDelete()
{
UltraGridRow row = ultraGridPlan.ActiveRow;
string stoveNo = row.Cells["JUDGE_STOVE_NO"].Value.ToString();
if (stoveNo.Equals("") || stoveNo == null) return;
if (MessageUtil.ShowYesNoAndQuestion("是否删除?") == DialogResult.No)
return;
CoreClientParam ccp = new CoreClientParam();
try
{
ccp.ServerName = "com.steering.mes.mcp.Mch.FrmZjResult";
ccp.MethodName = "DoDelete";
ccp.ServerParams = new object[] { stoveNo };
ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
MessageUtil.ShowTips(ccp.ReturnInfo);
PlanQuery();
}
}
catch (Exception ex)
{
MessageUtil.ShowTips("操作失败");
}
if (ccp.ReturnCode != -1)
{
MessageUtil.ShowTips(ccp.ReturnInfo);
ccp.ReturnInfo.Equals("删除成功");
PlanQuery();
}
}
public int ShowMessageFlag { get; set; }
private void ultraComboEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
{
List ls = new List();
List listRow = UltraGridGetChooseRows(ultraGrid1);
RowsCollection rows = ultraGrid1.Rows;
foreach (var item in rows)
{
try
{
//if (Convert.ToBoolean(item.Cells["check"].Value) == true)
//{
// list.Add(item);
//}
string heatPlanSqe = item.Cells["MAT_NO"].Value.ToString();
ls.Add(heatPlanSqe);
}
catch { }
}
using (FrmMesureData MesureData = new FrmMesureData(_judgeStove, _batchNo, ob, this.UserInfo.GetUserName(), false, ls))
{
MesureData.ShowDialog();
CopyDataToDatatableplnZyZjc(_judgeStove);
ultraGrid1.UpdateData();
ultraGrid1.Refresh();
//ultraGrid1.ActiveCell.Value = (decimal)MesureData.list.Where(p => p.Flag == "00").Select(p => p.MatNo).Distinct().Count();
//portMchBatchControl1.Query(ActiveRow.HeatPlanNo, ActiveRow.BatchNo, Gx, ActiveRow.ProducType == "C" || ActiveRow.ProducType == "E");
}
}
private void ultraGrid1_KeyPress(object sender, KeyPressEventArgs e)
{
if (this.ultraGrid1.ActiveCell == null)
return;
string strKey = this.ultraGrid1.ActiveCell.Column.ToString();
if (!(e.KeyChar == '\b') && ultraGrid1.ActiveRow.Cells[strKey].Value.ToString().Length >= 6)
{
e.Handled = true;
}
if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b' || e.KeyChar == '.'))
{
e.Handled = true;
}
if (e.KeyChar == '.')
{
char[] arrary = ultraGrid1.ActiveRow.Cells[strKey].Text.ToCharArray();
if (arrary.Length == 0)
{
ultraGrid1.ActiveRow.Cells[strKey].Value = "0.";
ultraGrid1.ActiveRow.Cells[strKey].SelStart = ultraGrid1.ActiveRow.Cells[strKey].Value.ToString().Length;
e.Handled = true;
}
else
{
for (int i = 0; i < arrary.Length; i++)
{
if (arrary[i] == '.')
e.Handled = true;
}
}
}
}
private void chkHeatNo_CheckedChanged(object sender, EventArgs e)
{
txtJudgeStoveNo.Enabled = chkHeatNo.Checked;
}
}
}