using System;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using DevExpress.XtraEditors;
|
using DevExpress.XtraGrid.Views.Grid;
|
using Gs.DevApp.DevFrm.QC.Models;
|
using Gs.DevApp.Entity;
|
using Gs.DevApp.ToolBox;
|
using Gs.DevApp.UserControl;
|
using MES.Service.Modes;
|
using Newtonsoft.Json;
|
using Newtonsoft.Json.Linq;
|
|
namespace Gs.DevApp.DevFrm.QC
|
{
|
public partial class Frm_MesQmCheckitemDt : XtraForm
|
{
|
private List<FilterEntity> _filterList = new List<FilterEntity>();
|
private readonly string _webServiceName = "MesQmCheckitemManager/";
|
|
public Frm_MesQmCheckitemDt()
|
{
|
InitializeComponent();
|
toolBarMenu1.btnAddClick += ToolBarMenu1_btnAddClick;
|
toolBarMenu1.btnEdtClick += ToolBarMenu1_btnEdtClick;
|
toolBarMenu1.btnSaveClick += ToolBarMenu1_btnSaveClick;
|
toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick;
|
toolBarMenu1.btnDelClick += ToolBarMenu1_btnDelClick1;
|
toolBarMenu1.btnEscClick += ToolBarMenu1_btnEscClick;
|
toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick;
|
gcMain.MouseDoubleClick += GcMain_MouseDoubleClick;
|
getPageList(1, UtilityHelper.GetPageSize());
|
pageBar1.PagerEvent += PageBar1_PagerEvent;
|
gridView1.CustomDrawRowIndicator += (s, e) =>
|
{
|
if (e.Info.IsRowIndicator && e.RowHandle >= 0)
|
e.Info.DisplayText = (e.RowHandle + 1).ToString();
|
};
|
gridView1.CustomDrawEmptyForeground += (s, e) =>
|
{
|
var str = "暂未查找到匹配的数据!";
|
var f = new Font("微软雅黑", 16);
|
var r = new Rectangle(
|
gridView1.GridControl.Width / 2 - 100, e.Bounds.Top + 45,
|
e.Bounds.Right - 5, e.Bounds.Height - 5);
|
e.Graphics.DrawString(str, f, Brushes.Gray, r);
|
};
|
//初始化物料选择和各种下拉
|
_setIno();
|
}
|
|
/// <summary>
|
/// 双击事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void GcMain_MouseDoubleClick(object sender, MouseEventArgs e)
|
{
|
var rowGuid =
|
UtilityHelper.GetCurrentDoubleRow(gridView1,
|
e, "guid");
|
if (!string.IsNullOrEmpty(rowGuid))
|
getModel(rowGuid, false, 999);
|
}
|
|
/// <summary>
|
/// 分页事件
|
/// </summary>
|
/// <param name="curPage"></param>
|
/// <param name="pageSize"></param>
|
private void PageBar1_PagerEvent(int curPage, int pageSize)
|
{
|
getPageList(curPage, pageSize);
|
}
|
|
/// <summary>
|
/// 查询事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e)
|
{
|
var frm =
|
new ShowFilter(gridView1.Columns,
|
_filterList);
|
frm.UpdateParent += Frm_UpdateParent;
|
frm.ShowDialog();
|
}
|
|
/// <summary>
|
/// 查询回调
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void Frm_UpdateParent(object sender, UpdateParentEventArgs e)
|
{
|
_filterList = e.FilterList;
|
getPageList(1, pageBar1.RowsCount);
|
}
|
|
/// <summary>
|
/// 取消事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnEscClick(object sender, EventArgs e)
|
{
|
UtilityHelper.JumpToTab(xtraTabControl1, 0);
|
}
|
|
/// <summary>
|
/// 删除事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnDelClick1(object sender, EventArgs e)
|
{
|
string rowGuid = "", rowName = "";
|
(rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_itemNo, gridView1);
|
if (string.IsNullOrEmpty(rowGuid))
|
{
|
MsgHelper.Warning("请先选择你要操作的行！");
|
return;
|
}
|
|
if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】的检验标准，确定删除吗？"))
|
return;
|
var lst = new List<dynamic>();
|
lst.Add(rowGuid);
|
var _obj = lst;
|
try
|
{
|
var strJson = UtilityHelper.HttpPost("",
|
_webServiceName + "DeleteModel",
|
JsonConvert.SerializeObject(_obj));
|
var _rtn =
|
UtilityHelper.ReturnToDynamic(strJson);
|
if (_rtn.rtnCode > 0)
|
{
|
UtilityHelper.JumpToTab(xtraTabControl1, 0);
|
getPageList(1, UtilityHelper.GetPageSize());
|
}
|
MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 刷新事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e)
|
{
|
UtilityHelper.JumpToTab(xtraTabControl1, 0);
|
getPageList(1, UtilityHelper.GetPageSize());
|
}
|
|
/// <summary>
|
/// 修改事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnEdtClick(object sender, EventArgs e)
|
{
|
string rowGuid = "", rowName = "";
|
(rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_itemNo, gridView1);
|
if (string.IsNullOrEmpty(rowGuid))
|
{
|
MsgHelper.Warning("请先选择你要操作的行！");
|
return;
|
}
|
getModel(rowGuid, true, 1);
|
}
|
|
/// <summary>
|
/// 新增事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnAddClick(object sender, EventArgs e)
|
{
|
UtilityHelper.JumpToTab(xtraTabControl1, 1);
|
lbGuid.Text = "";
|
var gridViews =
|
new List<GridView>();
|
gridViews.Add(gvMx1);
|
UtilityHelper.CleanValueByControl(panel1.Controls, true,
|
gridViews);
|
UtilityHelper.SetDefaultTable(gcMx1, gvMx1);
|
}
|
|
/// <summary>
|
/// 保存事件
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void ToolBarMenu1_btnSaveClick(object sender, EventArgs e)
|
{
|
toolBarMenu1.isSetBtn = false;
|
string _ItemId = txt_itemId.GetId()
|
; if (string.IsNullOrEmpty(_ItemId))
|
{
|
MsgHelper.Warning("请选择物料！");
|
// txt_account.Focus();
|
return;
|
}
|
gvMx1.CloseEditor();
|
gvMx1.UpdateCurrentRow();
|
var lst = new List<MesQmCheckitemDt>();
|
for (var i = 0; i < gvMx1.DataRowCount; i++)
|
{
|
var row = gvMx1.GetDataRow(i);
|
if (row != null)
|
lst.Add(new MesQmCheckitemDt
|
{
|
Guid = null,
|
Forder = 1,
|
FcheckItem = row["FcheckItem"].ToString(),
|
SampleSizeNo = row["SampleSizeNo"].ToString(),
|
FcheckTool = row["FcheckTool"].ToString(),
|
FcheckLevel = row["FcheckLevel"].ToString(),
|
Fstand = row["Fstand"].ToString(),
|
FacLevel = row["FacLevel"].ToString(),
|
});
|
}
|
|
var _obj = new MesQmCheckitem
|
{
|
Guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()),
|
Memo = txt_memo.Text.Trim(),
|
ItemNo = txt_itemNo.Text.Trim(),
|
IsEnabled = txt_isenabled.Checked,
|
list = lst
|
};
|
|
try
|
{
|
var strJson = UtilityHelper.HttpPost("",
|
_webServiceName + "EditModel",
|
JsonConvert.SerializeObject(_obj));
|
var _rtn =
|
UtilityHelper.ReturnToDynamic(strJson);
|
MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
if (_rtn.rtnCode > 0)
|
{
|
lbGuid.Text = _rtn.rtnData;
|
toolBarMenu1.isSetBtn = true;
|
UtilityHelper.ChangeEnableByControl(panel1.Controls,
|
false);
|
}
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// </summary>
|
/// <param name="curPage">第几页</param>
|
/// <param name="pageSize">每页几条</param>
|
private void getPageList(int curPage, int pageSize)
|
{
|
var _sbSqlWhere =
|
new StringBuilder();
|
foreach (var itm in _filterList)
|
_sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" +
|
itm.fileValue + "'");
|
|
var pgq = new PageQueryModel(curPage, pageSize,
|
"create_date", "asc", "", _sbSqlWhere.ToString());
|
var json = JsonConvert.SerializeObject(pgq);
|
try
|
{
|
var strReturn = UtilityHelper.HttpPost("",
|
_webServiceName + "GetListPageIQC", json);
|
var dd =
|
UtilityHelper.ReturnToTablePage(strReturn);
|
if (dd.rtnCode > 0)
|
{
|
var dt = dd.rtnData.list;
|
gcMain.BindingContext = new BindingContext();
|
gcMain.DataSource = dt;
|
gcMain.ForceInitialize();
|
var dddd = dd.rtnData.pages; //总页
|
pageBar1.TotalPages = dddd;
|
pageBar1.RecordCount = dd.rtnData.total; //记录总数
|
pageBar1.CurrentPage = curPage; //当前页
|
pageBar1.RowsCount = pageSize; //每页显示
|
pageBar1.setTxt();
|
}
|
else
|
{
|
MsgHelper.ShowError("提示：" + dd.rtnMsg);
|
}
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
private void getModel(string strGuid, bool isEdit, int tabIdx)
|
{
|
if (string.IsNullOrEmpty(strGuid))
|
{
|
MsgHelper.Warning("请先选择你要操作的行！");
|
return;
|
}
|
|
UtilityHelper.JumpToTab(xtraTabControl1, tabIdx);
|
var _obj = new
|
{
|
guid = strGuid //主建
|
};
|
try
|
{
|
var strJson = UtilityHelper.HttpPost("",
|
_webServiceName + "GetModelIQC",
|
JsonConvert.SerializeObject(_obj));
|
var _rtn =
|
UtilityHelper.ReturnToDynamic(strJson);
|
if (_rtn.rtnCode > 0)
|
{
|
var dy = _rtn.rtnData;
|
lbGuid.Text = strGuid;
|
var gvList =
|
new List<GridView>();
|
gvList.Add(gvMx1);
|
UtilityHelper.SetValueByObj(panel1.Controls, dy,
|
isEdit, gvList);
|
var _job = JObject.Parse(strJson);
|
var array = new JArray();
|
foreach (var a in _job["rtnData"]["list"]) array.Add(a);
|
|
var dt =
|
JsonConvert.DeserializeObject<DataTable>(
|
array.ToString());
|
if (dt.Rows.Count > 0)
|
{
|
gcMx1.BindingContext = new BindingContext();
|
gcMx1.DataSource = dt;
|
gcMx1.ForceInitialize();
|
}
|
else
|
{
|
UtilityHelper.SetDefaultTable(gcMx1,
|
gvMx1);
|
}
|
}
|
else
|
{
|
MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
}
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
|
|
#region 以下为种种下拉
|
|
private void getCopyMx(string strGuid)
|
{
|
if (string.IsNullOrEmpty(strGuid))
|
{
|
MsgHelper.Warning("请先选择你要复制的行！");
|
return;
|
}
|
var _obj = new
|
{
|
guid = strGuid
|
};
|
try
|
{
|
var strJson = UtilityHelper.HttpPost("",
|
_webServiceName + "GetModelIQC",
|
JsonConvert.SerializeObject(_obj));
|
var _rtn =
|
UtilityHelper.ReturnToDynamic(strJson);
|
if (_rtn.rtnCode > 0)
|
{
|
var dy = _rtn.rtnData;
|
var _job = JObject.Parse(strJson);
|
var array = new JArray();
|
foreach (var a in _job["rtnData"]["list"]) array.Add(a);
|
var dt =
|
JsonConvert.DeserializeObject<DataTable>(
|
array.ToString());
|
if (dt.Rows.Count > 0)
|
{
|
gcMx1.BindingContext = new BindingContext();
|
gcMx1.DataSource = dt;
|
gcMx1.ForceInitialize();
|
}
|
else
|
{
|
MsgHelper.Warning("提示：没找到相应的明细，请选择其它试试！");
|
}
|
}
|
else
|
{
|
MsgHelper.Warning("提示：" + _rtn.rtnMsg);
|
}
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
private void _setIno()
|
{
|
txt_itemId.KeyFile = "id";
|
txt_itemId.EditChanged += (s, e) =>
|
{
|
txt_itemModel.Text = this.txt_itemId.GetModel();
|
txt_itemNo.Text = this.txt_itemId.GetCode();
|
};
|
btnSelect.Click += (s, e) =>
|
{
|
var frm = new SelectCheckDt();
|
frm.UpdateParent += (ss, ee) =>
|
{
|
var lst = new List<string>();
|
lst = ee.StringList;
|
getCopyMx(lst[0]);
|
|
};
|
frm.ShowDialog();
|
};
|
_getListJyxm();
|
_getListJygj();
|
_getListJybz();
|
_getListJssp();
|
_getListJysp();
|
}
|
/// <summary>
|
/// 读取检验项目
|
/// </summary>
|
private void _getListJyxm()
|
{
|
var json = JsonConvert.SerializeObject("QCITEM");
|
try
|
{
|
var strReturn = UtilityHelper.HttpPost("", "MesSysLookupTypesManager/GetItemList", json);
|
var dd = UtilityHelper.ReturnToList(strReturn);
|
var dt = dd.rtnData;
|
foreach (DataRow dr in dt.Rows)
|
{
|
rptJYXM.Items.Add(dr["lookUpName"].ToString());
|
}
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
|
/// <summary>
|
/// 读取检验工具
|
/// </summary>
|
private void _getListJygj()
|
{
|
var json = JsonConvert.SerializeObject("QATOOLS");
|
try
|
{
|
var strReturn = UtilityHelper.HttpPost("", "MesSysLookupTypesManager/GetItemList", json);
|
var dd = UtilityHelper.ReturnToList(strReturn);
|
var dt = dd.rtnData;
|
foreach (DataRow dr in dt.Rows)
|
{
|
rptJYGJ.Items.Add(dr["lookUpName"].ToString());
|
}
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.Warning("提示：" + ex.Message);
|
}
|
}
|
/// <summary>
|
/// 读取检验标准
|
/// </summary>
|
private void _getListJybz()
|
{
|
var pgq = new PageQueryModel(1, 999999, "CREATE_DATE", "asc", "",
|
" and 1=1");
|
var json = JsonConvert.SerializeObject(pgq);
|
try
|
{
|
var strReturn = UtilityHelper.HttpPost("",
|
"MesQmAql1Manager/GetListPage", json);
|
var rtn = UtilityHelper.ReturnToTablePage(strReturn);
|
var dt = rtn.rtnData.list;
|
foreach (DataRow dr in dt.Rows)
|
{
|
rptJYBZ.Items.Add((new CboItemEntity(dr["SampleSizeNo"].ToString(), dr["SampleSizeName"].ToString())));
|
//string ddddd = dr["SampleSizeName"].ToString();
|
}
|
}
|
catch (Exception ex)
|
{
|
MsgHelper.Warning("提示：" + ex.Message);
|
Close();
|
Application.Exit();
|
}
|
}
|
/// <summary>
|
/// 读取接受水平
|
/// </summary>
|
private void _getListJssp()
|
{
|
rptJSSP.Items.AddRange(new string[] {
|
"0.010---(AQL_0_0010)"
|
, "0.015---(AQL_0_0015)"
|
, "0.025---(AQL_0_0025)"
|
,"0.04---(AQL_0_0040)"
|
,"0.065---(AQL_0_0065)"
|
,"0.10---(AQL_0_010)"
|
,"0.15---(AQL_0_015)"
|
,"0.25---(AQL_0_025)"
|
,"0.40---(AQL_0_040)"
|
,"0.65---(AQL_0_065)"
|
,"1.00---(AQL_0_100)"
|
,"1.50---(AQL_0_150)"
|
,"2.00---(AQL_0_200)"
|
,"2.50---(AQL_0_250)"
|
});
|
}
|
/// <summary>
|
/// 读取检验水平
|
/// </summary>
|
private void _getListJysp()
|
{
|
rptJYSP.Items.AddRange(new string[] {
|
"1.一般检验水平(I)"
|
, "2.一般检验水平(II)"
|
,"3.一般检验水平(III)"
|
,"4.特殊检验水平(S1)"
|
,"5.特殊检验水平(S2)"
|
,"6.特殊检验水平(S3)"
|
,"7.特殊检验水平(S4),"
|
});
|
}
|
|
/// <summary>
|
/// 关联检验标准名称
|
/// </summary>
|
/// <param name="sender"></param>
|
/// <param name="e"></param>
|
private void rptJYBZ_SelectedIndexChanged(object sender, EventArgs e)
|
{
|
ComboBoxEdit comboBox = sender as ComboBoxEdit;
|
if (comboBox != null)
|
{
|
CboItemEntity _itm = comboBox.EditValue as CboItemEntity;
|
string _val = _itm.Value.ToString();
|
string _txt = _itm.Text.ToString();
|
gvMx1.CloseEditor();
|
gvMx1.UpdateCurrentRow();
|
GridView myView = (gcMx1.MainView as GridView);
|
int dataIndex = myView.GetDataSourceRowIndex(myView.FocusedRowHandle);
|
myView.SetRowCellValue(dataIndex, "sampleSizeNo", _val);
|
myView.SetRowCellValue(dataIndex, "sampleSizeName", _txt);
|
}
|
}
|
|
#endregion
|
|
|
}
|
}
|
