You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
961 lines
46 KiB
961 lines
46 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Windows.Forms;
|
|
using DevExpress.XtraEditors;
|
|
using ICSSoft.Base.Config.AppConfig;
|
|
using ICSSoft.Base.Config.DBHelper;
|
|
using ICSSoft.Base.ReferForm.AppReferForm;
|
|
using ICSSoft.Frame.Data.Entity;
|
|
using ICSSoft.Frame.Data.BLL;
|
|
|
|
namespace ICSSoft.Frame.APP
|
|
{
|
|
public partial class FormICSMROPickingEditAdd : DevExpress.XtraEditors.XtraForm
|
|
{
|
|
private DataTable data;
|
|
//DataTable body;
|
|
string VRow = "";
|
|
String guid = "";
|
|
FormICSPickingModel entity = new FormICSPickingModel();
|
|
public string Sys = "";
|
|
|
|
#region 构造函数
|
|
|
|
public FormICSMROPickingEditAdd()
|
|
{
|
|
InitializeComponent();
|
|
}
|
|
public FormICSMROPickingEditAdd(String id)
|
|
{
|
|
InitializeComponent();
|
|
guid = id;
|
|
}
|
|
#endregion
|
|
|
|
#region 关闭 退出
|
|
private void btnClose_Click(object sender, EventArgs e)
|
|
{
|
|
this.Close();
|
|
}
|
|
#endregion
|
|
|
|
#region 移动窗体
|
|
private const int WM_NCHITTEST = 0x84;
|
|
private const int HTCLIENT = 0x1;
|
|
private const int HTCAPTION = 0x2;
|
|
//首先必须了解Windows的消息传递机制，当有鼠标活动消息时，
|
|
//系统发送WM_NCHITTEST 消息给窗体作为判断消息发生地的根据。 nchittest
|
|
//假如你点击的是标题栏，窗体收到的消息值就是 HTCAPTION ，
|
|
//同样地，若接受到的消息是 HTCLIENT，说明用户点击的是客户区，也就是鼠标消息发生在客户区。
|
|
|
|
//重写窗体，使窗体可以不通过自带标题栏实现移动
|
|
protected override void WndProc(ref Message m)
|
|
{
|
|
//当重载窗体的 WndProc 方法时，可以截获 WM_NCHITTEST 消息并改些该消息，
|
|
//当判断鼠标事件发生在客户区时，改写改消息，发送 HTCAPTION 给窗体，
|
|
//这样，窗体收到的消息就时 HTCAPTION ，在客户区通过鼠标来拖动窗体就如同通过标题栏来拖动一样。
|
|
//注意：当你重载 WndProc 并改写鼠标事件后，整个窗体的鼠标事件也就随之改变了。
|
|
switch (m.Msg)
|
|
{
|
|
case WM_NCHITTEST:
|
|
base.WndProc(ref m);
|
|
if ((int)m.Result == HTCLIENT)
|
|
m.Result = (IntPtr)HTCAPTION;
|
|
return;
|
|
}
|
|
//拦截双击标题栏、移动窗体的系统消息
|
|
if (m.Msg != 0xA3)
|
|
{
|
|
base.WndProc(ref m);
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 新增 修改
|
|
private void save_Click(object sender, EventArgs e)
|
|
{
|
|
//if (txtPickingNO.Text.Trim() == "" || txtWHCode.Text.Trim() == "" || txtCode.Text.Trim() == "" || txtiQuantity.Text.Trim() == "" )
|
|
//{
|
|
// ICSBaseSimpleCode.AppshowMessageBox("请添加一行内容!");
|
|
// return;
|
|
//}
|
|
if (txtPickingNO.Text.Trim() == "" || txtWHCode.Text.Trim() == "" || txtOutCategory.Text.Trim() == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("请输入退料单号、仓库、出库类别内容!");
|
|
return;
|
|
}
|
|
for (int i = 0; i < grdDetail.RowCount; i++)
|
|
{
|
|
string PickingNO = string.Empty;
|
|
PickingNO = grdDetail.GetRowCellValue(i, colPickingNO).ToString();
|
|
if (string.IsNullOrWhiteSpace(PickingNO))
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("请添加字表行信息!");
|
|
return;
|
|
}
|
|
}
|
|
|
|
entity.ID = guid;
|
|
entity.VouchCode = txtPickingNO.Text.Trim();
|
|
entity.MUSER = AppConfig.UserCode;
|
|
entity.MUSERName = AppConfig.UserName;
|
|
entity.MTIME = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");
|
|
entity.WorkPoint = AppConfig.WorkPointCode;
|
|
entity.EATTRIBUTE1 = null;
|
|
entity.CreateTIME = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");
|
|
entity.CreateUSER = AppConfig.UserName;
|
|
entity.IsPickingOrBack = 1;
|
|
entity.PickingSTATUS = "新建";
|
|
try
|
|
{
|
|
guid = ICSPickingBLL.Add(entity, AppConfig.AppConnectString);
|
|
this.Close();
|
|
ICSBaseSimpleCode.AppshowMessageBox("操作成功");
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
|
|
}
|
|
}
|
|
#endregion
|
|
|
|
#region 取消
|
|
//private void can_Click(object sender, EventArgs e)
|
|
//{
|
|
// this.Close();
|
|
//}
|
|
#endregion
|
|
|
|
#region 页面加载
|
|
private void FormICSINVENTORYEditAdd_Load(object sender, EventArgs e)
|
|
{
|
|
Sys = GetSys();
|
|
if (Sys == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("连接数据库不正确！");
|
|
return;
|
|
}
|
|
if (guid != "")
|
|
{
|
|
lblTitle.Text = "MRO领料单维护";
|
|
txtPickingNO.Properties.ReadOnly = true;
|
|
txtWHCode.Properties.ReadOnly = true;
|
|
|
|
entity = ICSPickingBLL.SearchInfoByID(guid, AppConfig.AppConnectString);
|
|
txtPickingNO.Text = entity.VouchCode;
|
|
txtWHCode.Text = entity.WHCode;
|
|
//20190705ZM
|
|
txtDept.Text = entity.Dept;
|
|
txtCREWCODE.Text = entity.VENDORCODE;
|
|
this.txtOutCategory.Text = entity.OutCategory;
|
|
this.txtMEMO.Text = entity.MEMO;
|
|
//txtRDCode.Text = entity.RDCode;
|
|
txtMUSERName.Text = AppConfig.UserName;
|
|
txtMTIME.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
|
|
|
|
DataTable body = ICSPickingBLL.GetDetailList(entity.VouchCode);
|
|
grvDetail.DataSource = body;
|
|
grdDetail.BestFitColumns();
|
|
}
|
|
else
|
|
{
|
|
lblTitle.Text = "MRO领料单修改";
|
|
txtPickingNO.Properties.ReadOnly = true;
|
|
txtDept.Text = entity.Dept;
|
|
this.txtOutCategory.Text = entity.OutCategory;
|
|
txtPickingNO.Text = ICSPickingBLL.GetOutInNo(AppConfig.AppConnectString);
|
|
txtMUSERName.Text = AppConfig.UserName;
|
|
txtMTIME.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
|
|
}
|
|
init();
|
|
}
|
|
#endregion
|
|
|
|
#region 初始化查询条件
|
|
private void init()
|
|
{
|
|
#region
|
|
string sql = "SELECT DISTINCT INVCODE AS [存货编码] ,INVNAME AS [存货名称] ,INVSTD AS [规格型号] FROM ICSINVENTORY WHERE WorkPoint='{0}' ORDER BY INVCODE ";
|
|
sql = string.Format(sql, AppConfig.WorkPointCode);
|
|
DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
|
|
txtCode.Properties.ValueMember = "存货编码";
|
|
txtCode.Properties.DisplayMember = "存货编码";
|
|
txtCode.Properties.DataSource = dt;
|
|
txtCode.Properties.NullText = "";//空时的值
|
|
txtCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体
|
|
txtCode.Properties.ValidateOnEnterKey = true;//回车确认
|
|
txtCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard
|
|
txtCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容
|
|
//自适应宽度
|
|
txtCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
|
|
#endregion
|
|
|
|
#region 仓库
|
|
string sql1 = "SELECT DISTINCT StorageCode AS [仓库编号] ,StorageName AS[仓库名称] FROM ICSStorage WHERE WorkPoint='{0}' ORDER BY StorageCode";
|
|
sql1 = string.Format(sql1, AppConfig.WorkPointCode);
|
|
DataTable dt1 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql1).Tables[0];
|
|
txtWHCode.Properties.ValueMember = "仓库编号";
|
|
txtWHCode.Properties.DisplayMember = "仓库编号";
|
|
txtWHCode.Properties.DataSource = dt1;
|
|
txtWHCode.Properties.NullText = "";//空时的值
|
|
txtWHCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体
|
|
txtWHCode.Properties.ValidateOnEnterKey = true;//回车确认
|
|
txtWHCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard
|
|
txtWHCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容
|
|
//自适应宽度
|
|
txtWHCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
|
|
#endregion
|
|
|
|
#region 出库类型
|
|
string sql2 = "SELECT DISTINCT cRdCode AS [出库类型编号],cRdName AS [出库类型名称] FROM ICSRdStyle WHERE WorkPoint = '{0}' AND bRdFlag=0 AND bRdEnd=1 AND cRdCode != '20201' ORDER BY cRdCode";
|
|
sql2 = string.Format(sql2, AppConfig.WorkPointCode);
|
|
DataTable dt2 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql2).Tables[0];
|
|
txtOutCategory.Properties.ValueMember = "出库类型编号";
|
|
txtOutCategory.Properties.DisplayMember = "出库类型编号";
|
|
txtOutCategory.Properties.DataSource = dt2;
|
|
txtOutCategory.Properties.NullText = "";//空时的值
|
|
txtOutCategory.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体
|
|
txtOutCategory.Properties.ValidateOnEnterKey = true;//回车确认
|
|
txtOutCategory.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard
|
|
txtOutCategory.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容
|
|
//自适应宽度
|
|
txtOutCategory.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
|
|
#endregion
|
|
|
|
#region 部门
|
|
string sql3 = "SELECT DISTINCT cDepCode AS [部门编号],cDepName AS [部门名称] FROM ICSDepartment WHERE WorkPoint = '{0}' AND bDepEnd = 1 ORDER BY cDepCode";
|
|
sql3 = string.Format(sql3, AppConfig.WorkPointCode);
|
|
DataTable dt3 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql3).Tables[0];
|
|
txtDept.Properties.ValueMember = "部门编号";
|
|
txtDept.Properties.DisplayMember = "部门编号";
|
|
txtDept.Properties.DataSource = dt3;
|
|
txtDept.Properties.NullText = "";//空时的值
|
|
txtDept.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体
|
|
txtDept.Properties.ValidateOnEnterKey = true;//回车确认
|
|
txtDept.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard
|
|
txtDept.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容
|
|
//自适应宽度
|
|
txtDept.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
|
|
#endregion
|
|
|
|
#region 班组
|
|
string sql4 = "";
|
|
if (Sys == "ICSMES_YTSys")
|
|
{
|
|
if (this.txtOutCategory.Text == "20301" && this.txtDept.Text == "0401")
|
|
{
|
|
sql4 = @"SELECT CREWCODE 班组编码, CREWDESC 班组名称 FROM ICSCREW
|
|
WHERE 1=1 AND WorkPoint = '{0}' AND ISNULL(EATTRIBUTE3, '') = '' AND ISNULL(EATTRIBUTE1, '') = '01' ORDER BY CREWCODE ";
|
|
}
|
|
else if (this.txtOutCategory.Text == "20301" && this.txtDept.Text == "0301")
|
|
{
|
|
sql4 = @"SELECT CREWCODE 班组编码, CREWDESC 班组名称 FROM ICSCREW
|
|
WHERE 1=1 AND WorkPoint = '{0}' AND ISNULL(EATTRIBUTE3, '') = '' AND ISNULL(EATTRIBUTE1, '') = '02' ORDER BY CREWCODE ";
|
|
}
|
|
else
|
|
{
|
|
sql4 = "SELECT CREWCODE 班组编码, CREWDESC 班组名称 FROM ICSCREW WHERE 1=1 AND WorkPoint = '{0}' AND ISNULL(EATTRIBUTE3, '') = '' ORDER BY CREWCODE ";
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if (this.txtOutCategory.Text == "20302" && this.txtDept.Text == "0301")
|
|
{
|
|
sql4 = @"SELECT CREWCODE 班组编码, CREWDESC 班组名称 FROM ICSCREW
|
|
WHERE 1=1 AND WorkPoint = '{0}' AND ISNULL(EATTRIBUTE3, '') = '03' AND ISNULL(EATTRIBUTE1, '') = '03' ORDER BY CREWCODE ";
|
|
}
|
|
else
|
|
{
|
|
sql4 = "SELECT CREWCODE 班组编码, CREWDESC 班组名称 FROM ICSCREW WHERE 1=1 AND WorkPoint = '{0}' AND ISNULL(EATTRIBUTE3, '') = '03' ORDER BY CREWCODE ";
|
|
}
|
|
}
|
|
sql4 = string.Format(sql4, AppConfig.WorkPointCode);
|
|
DataTable dt4 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql4).Tables[0];
|
|
txtCREWCODE.Properties.ValueMember = "班组名称";
|
|
txtCREWCODE.Properties.DisplayMember = "班组名称";
|
|
txtCREWCODE.Properties.DataSource = dt4;
|
|
txtCREWCODE.Properties.NullText = "";//空时的值
|
|
txtCREWCODE.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体
|
|
txtCREWCODE.Properties.ValidateOnEnterKey = true;//回车确认
|
|
txtCREWCODE.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard
|
|
txtCREWCODE.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容
|
|
//自适应宽度
|
|
txtCREWCODE.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
|
|
#endregion
|
|
}
|
|
#endregion
|
|
|
|
#region 工单号
|
|
private void txtMOCode_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
|
|
{
|
|
|
|
string sql = @" SELECT DISTINCT MOCODE AS [工单号] FROM ICSMO ";
|
|
DataTable data = DBHelper.ExecuteDataset(AppConfig.GetDataBaseConnectStringByKey("[DB.SYS]"), CommandType.Text, sql).Tables[0];
|
|
FormDataRefer reForm = new FormDataRefer();
|
|
reForm.FormTitle = "工单信息";
|
|
reForm.DataSource = data;
|
|
reForm.MSelectFlag = false;
|
|
reForm.RowIndexWidth = 35;
|
|
reForm.Width = 600;
|
|
reForm.FormHeight = 900;
|
|
//if (reForm.ShowDialog() == DialogResult.OK)
|
|
//{
|
|
// foreach (DataRow dr in reForm.ReturnData.Rows)
|
|
// {
|
|
// txtMOCode.Text = dr["生产订单号"].ToString();
|
|
|
|
// }
|
|
//}
|
|
//if (data != null&&data.Rows.Count>0) {
|
|
// txtMORow.Text = data.Rows[0]["生产订单行号"].ToString();
|
|
// txtMoverCode.Text = data.Rows[0]["苏船工号"].ToString();
|
|
//}
|
|
|
|
}
|
|
#endregion
|
|
//#region 库房
|
|
//private void txtWHCode_EditValueChanged(object sender, EventArgs e)
|
|
//{
|
|
// string sql = "SELECT DISTINCT StorageCode AS [仓库编号] FROM ICSStorage WHERE WorkPoint='{0}' ORDER BY StorageCode";
|
|
// sql = string.Format(sql, AppConfig.WorkPointCode);
|
|
// DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
|
|
// txtWHCode.Properties.ValueMember = "行号";
|
|
// txtWHCode.Properties.DisplayMember = "行号";
|
|
// txtWHCode.Properties.DataSource = dt;
|
|
// txtWHCode.Properties.NullText = "";//空时的值
|
|
// txtWHCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体
|
|
// txtWHCode.Properties.ValidateOnEnterKey = true;//回车确认
|
|
// txtWHCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard
|
|
// txtWHCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容
|
|
// //自适应宽度
|
|
// txtWHCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
|
|
//}
|
|
//#endregion
|
|
#region 行号
|
|
private void txtMORow_EditValueChanged(object sender, EventArgs e)
|
|
{
|
|
//string MOCODE = txtMOCode.EditValue.ToString();
|
|
//string sql = "SELECT DISTINCT MOSEQ AS [行号] FROM ICSMO WHERE MOCODE='{0}' ORDER BY MOSEQ";
|
|
//sql = string.Format(sql, MOCODE);
|
|
//DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
|
|
//txtMORow.Properties.ValueMember = "行号";
|
|
//txtMORow.Properties.DisplayMember = "行号";
|
|
//txtMORow.Properties.DataSource = dt;
|
|
//txtMORow.Properties.NullText = "";//空时的值
|
|
//txtMORow.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体
|
|
//txtMORow.Properties.ValidateOnEnterKey = true;//回车确认
|
|
//txtMORow.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard
|
|
//txtMORow.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容
|
|
////自适应宽度
|
|
//txtMORow.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
|
|
//txtMORow.EditValue = "";
|
|
//txtMoverCode.Text = "";
|
|
//if (MOCODE == "")
|
|
//{
|
|
// txtMoverCode.Properties.ReadOnly = false;
|
|
//}
|
|
//else
|
|
//{
|
|
// txtMoverCode.Properties.ReadOnly = true;
|
|
//}
|
|
////DataTable dt_temp = (DataTable)glue.Properties.DataSource;
|
|
////if (dt_temp.Rows.Count > 0)
|
|
//if (dt.Rows.Count > 0)
|
|
//{
|
|
// //默认选择第一项
|
|
// txtMORow.EditValue = dt.Rows[0][0].ToString().Trim();
|
|
//}
|
|
}
|
|
#endregion
|
|
|
|
private void btnSaveDetail_Click_bak(object sender, EventArgs e)
|
|
{
|
|
//1. 填写出库类别，部门，存货编码，数量三项为必输项，备注为不必输；
|
|
if (txtWHCode.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("请选择仓库！");
|
|
return;
|
|
}
|
|
if (txtCode.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("存货编码不能为空");
|
|
return;
|
|
}
|
|
if (txtiQuantity.Text == "" || Convert.ToDecimal(txtiQuantity.Text) == 0)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("数量不能为空");
|
|
return;
|
|
}
|
|
if (this.txtOutCategory.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("出库类别不能为空");
|
|
return;
|
|
}
|
|
if (this.txtDept.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("部门不能为空！");
|
|
return;
|
|
}
|
|
try
|
|
{
|
|
string sqlQ = @"SELECT '' AS ID,'' VouchCode,'' UserId,'' MUSERName,'' MTIME,'' WorkPoint,'' AS CreateTIME,'' AS CreateUSER,'' AS MEMO, '' AS IsPickingOrBack, '' AS OutCategory ";
|
|
sqlQ = string.Format(sqlQ, AppConfig.WorkPointCode);
|
|
data = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sqlQ).Tables[0];
|
|
DataRow dr = data.NewRow();
|
|
dr["ID"] = new Guid().ToString();
|
|
dr["VouchCode"] = txtPickingNO.Text.Trim();
|
|
dr["UserId"] = AppConfig.UserId;
|
|
dr["MUSERName"] = AppConfig.UserName;
|
|
dr["MTIME"] = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");
|
|
dr["WorkPoint"] = AppConfig.WorkPointCode;
|
|
dr["CreateTIME"] = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");
|
|
dr["CreateUSER"] = AppConfig.UserName;
|
|
dr["MEMO"] = txtMEMO.Text.Trim();
|
|
dr["IsPickingOrBack"] = 1; //1--领料；3-退料
|
|
dr["OutCategory"] = this.txtOutCategory.Text;
|
|
data.Rows.Add(dr);
|
|
this.grvDetail.DataSource = data;
|
|
#region
|
|
//FormICSPickingModel Picking = new FormICSPickingModel();
|
|
//Picking.ID = guid;
|
|
//Picking.VouchCode = txtPickingNO.Text.Trim();
|
|
////Picking.StorageID = txtStorageID.Text.Trim();
|
|
//Picking.MUSER = AppConfig.UserId;
|
|
//Picking.MUSERName = AppConfig.UserName;
|
|
//Picking.MTIME = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");
|
|
//Picking.WorkPoint = AppConfig.WorkPointCode;
|
|
//Picking.CreateTIME = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");
|
|
//Picking.CreateUSER = AppConfig.UserName;
|
|
//Picking.MEMO = txtMEMO.Text.Trim();
|
|
//Picking.IsPickingOrBack = 1; //1--领料；3-退料
|
|
//Picking.OutCategory = this.txtOutCategory.Text;
|
|
//Picking.FormICSPickingDetail = new List<FormICSPickingDetailModel>();
|
|
#endregion
|
|
if (string.IsNullOrWhiteSpace(txtirowno.Text))
|
|
{
|
|
txtirowno.Text = ICSPickingBLL.GetPickingRowNo(guid, AppConfig.AppConnectString);//入库单行号
|
|
}
|
|
#region
|
|
//FormICSPickingDetailModel PickingDetail = new FormICSPickingDetailModel();
|
|
//bool detailIsID = false;
|
|
//if (txtDetailId.Text == "")
|
|
//{
|
|
// detailIsID = true;
|
|
// PickingDetail.ID = "0";//领料单明细ID
|
|
//}
|
|
//else
|
|
//{
|
|
// PickingDetail.ID = txtDetailId.Text; //领料单ID
|
|
//}
|
|
////PickingDetail.VoucherNO = txtMoverCode.Text.Trim();//苏船工号
|
|
//PickingDetail.VouchCode = txtPickingNO.Text.Trim();//单号
|
|
//string strtime = DateTime.Now.ToString("yyyyMMdd");
|
|
//string sql = @"SELECT CONVERT(INT,RIGHT(MAX(A.VouchRow),4)) AS MAXLOT FROM ICSMaterialPick A WHERE A.VouchCode ='{0}'";
|
|
//sql = string.Format(sql, PickingDetail.VouchCode);//取已存的transNo后四位
|
|
//DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sql).Tables[0];
|
|
//if (dt == null || dt.Rows.Count <= 0)
|
|
//{
|
|
// VRow = "0001";
|
|
//}
|
|
//else if (dt.Rows[0][0] == null || dt.Rows[0][0].ToString() == "")
|
|
//{
|
|
// VRow = "0001";
|
|
//}
|
|
//else
|
|
//{
|
|
// VRow = (Convert.ToInt32(dt.Rows[0][0]) + 1).ToString().PadLeft(4, '0');//自动生成transNo
|
|
//}
|
|
|
|
//PickingDetail.VouchRow = VRow; //入库单行号
|
|
//PickingDetail.SubInvCode = txtCode.Text.Trim();//物料代码
|
|
//PickingDetail.WHCode = txtWHCode.Text.Trim();//仓库
|
|
|
|
//PickingDetail.Quantity = Convert.ToDecimal(txtiQuantity.Text.Trim());//应退数量
|
|
//PickingDetail.MTIME = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");//领料时间
|
|
|
|
//PickingDetail.OutCategory = this.txtOutCategory.Text.Trim();
|
|
//PickingDetail.Dept = this.txtDept.Text.Trim();
|
|
|
|
//Picking.FormICSPickingDetail.Add(PickingDetail);
|
|
|
|
//string id = ICSPickingBLL.AddAndEditDetail(Picking, AppConfig.AppConnectString);
|
|
//if (guid == "" && string.IsNullOrWhiteSpace(guid))
|
|
//{
|
|
// guid = id;
|
|
//}
|
|
//if (string.IsNullOrWhiteSpace(txtDetailId.Text.Trim()))
|
|
//{
|
|
// txtDetailId.Text = "";
|
|
// txtirowno.Text = "";
|
|
// ICSBaseSimpleCode.AppshowMessageBox(0, "新增成功");
|
|
//}
|
|
//else
|
|
//{
|
|
// ICSBaseSimpleCode.AppshowMessageBox(0, "维护成功");
|
|
// txtWHCode.Text = "";
|
|
// txtCode.Text = "";
|
|
// txtcInvName.Text = "";
|
|
// txtcInvStd.Text = "";
|
|
// txtINVUOM.Text = "";
|
|
// txtiQuantity.Text = "";
|
|
// //txtMOCode.Text = "";
|
|
// //txtMORow.Text = "";
|
|
// txtDetailId.Text = "0";
|
|
// txtDept.Text = "";
|
|
// txtOutCategory.Text = "";
|
|
|
|
//}
|
|
//FormICSINVENTORYEditAdd_Load(null, null);
|
|
#endregion
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
|
|
return;
|
|
}
|
|
}
|
|
|
|
private void btnSaveDetail_Click(object sender, EventArgs e)
|
|
{
|
|
//20190910新增一个单据只能保存一个出库类别，在表行中新增仓库、出库类别、部门
|
|
string sqlOutCategory = @" SELECT DISTINCT
|
|
j.OutCategory
|
|
FROM
|
|
ICSMaterialPick a
|
|
LEFT JOIN ICSMaterial j ON a.VouchCode = j.VouchCode
|
|
WHERE
|
|
a.VouchCode = '{0}'
|
|
AND a.WorkPoint = '" + AppConfig.WorkPointCode + "' ";
|
|
sqlOutCategory = string.Format(sqlOutCategory, this.txtPickingNO.Text);
|
|
DataTable dtOutCategory = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sqlOutCategory).Tables[0];
|
|
if (dtOutCategory != null && dtOutCategory.Rows.Count > 0)
|
|
{
|
|
string _OutCategory = dtOutCategory.Rows[0][0].ToString();
|
|
if (_OutCategory != this.txtOutCategory.Text)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("一张MRO领料单不能出现两个出库类别！");
|
|
return;
|
|
}
|
|
}
|
|
//1. 填写出库类别，部门，存货编码，数量三项为必输项，备注为不必输；
|
|
if (txtWHCode.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("请选择仓库！");
|
|
return;
|
|
}
|
|
if (txtCode.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("存货编码不能为空");
|
|
return;
|
|
}
|
|
if (txtiQuantity.Text == "" || Convert.ToDecimal(txtiQuantity.Text) == 0)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("数量不能为空");
|
|
return;
|
|
}
|
|
if (this.txtOutCategory.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("出库类别不能为空");
|
|
return;
|
|
}
|
|
if (Sys == "ICSMES_YTSys")
|
|
{
|
|
if (this.txtOutCategory.Text == "20303" || this.txtOutCategory.Text == "20306")
|
|
{
|
|
if (txtMEMO.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("亚太账套，出库类别为20303或20306时，备注不能为空");
|
|
return;
|
|
}
|
|
}
|
|
}
|
|
if (this.txtOutCategory.Text == "20202" && txtRDCode.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("出库类别为20202时, RD号不能为空！");
|
|
return;
|
|
}
|
|
if (this.txtDept.Text == "")
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("部门不能为空！");
|
|
return;
|
|
}
|
|
try
|
|
{
|
|
FormICSPickingModel Picking = new FormICSPickingModel();
|
|
Picking.ID = guid;
|
|
Picking.VouchCode = txtPickingNO.Text.Trim();
|
|
//Picking.StorageID = txtStorageID.Text.Trim();
|
|
Picking.MUSER = AppConfig.UserId;
|
|
Picking.MUSERName = AppConfig.UserName;
|
|
Picking.MTIME = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");
|
|
Picking.WorkPoint = AppConfig.WorkPointCode;
|
|
Picking.CreateTIME = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");
|
|
Picking.CreateUSER = AppConfig.UserName;
|
|
Picking.MEMO = txtMEMO.Text.Trim();
|
|
Picking.IsPickingOrBack = 1; //1--领料；3-退料
|
|
Picking.OutCategory = this.txtOutCategory.Text;
|
|
Picking.VENDORCODE = txtCREWCODE.Text.Trim();
|
|
Picking.FormICSPickingDetail = new List<FormICSPickingDetailModel>();
|
|
if (string.IsNullOrWhiteSpace(txtirowno.Text))
|
|
{
|
|
txtirowno.Text = ICSPickingBLL.GetPickingRowNo(guid, AppConfig.AppConnectString);//入库单行号
|
|
}
|
|
FormICSPickingDetailModel PickingDetail = new FormICSPickingDetailModel();
|
|
bool detailIsID = false;
|
|
if (txtDetailId.Text == "")
|
|
{
|
|
detailIsID = true;
|
|
PickingDetail.ID = "0";//领料单明细ID
|
|
}
|
|
else
|
|
{
|
|
PickingDetail.ID = txtDetailId.Text; //领料单ID
|
|
}
|
|
//PickingDetail.VoucherNO = txtMoverCode.Text.Trim();//苏船工号
|
|
PickingDetail.VouchCode = txtPickingNO.Text.Trim();//单号
|
|
string strtime = DateTime.Now.ToString("yyyyMMdd");
|
|
string sql = @"SELECT CONVERT(INT,RIGHT(MAX(A.VouchRow),4)) AS MAXLOT FROM ICSMaterialPick A WHERE A.VouchCode ='{0}'";
|
|
sql = string.Format(sql, PickingDetail.VouchCode);//取已存的transNo后四位
|
|
DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString, CommandType.Text, sql).Tables[0];
|
|
if (dt == null || dt.Rows.Count <= 0)
|
|
{
|
|
VRow = "0001";
|
|
}
|
|
else if (dt.Rows[0][0] == null || dt.Rows[0][0].ToString() == "")
|
|
{
|
|
VRow = "0001";
|
|
}
|
|
else
|
|
{
|
|
VRow = (Convert.ToInt32(dt.Rows[0][0]) + 1).ToString().PadLeft(4, '0');//自动生成transNo
|
|
}
|
|
|
|
PickingDetail.VouchRow = VRow; //入库单行号
|
|
PickingDetail.SubInvCode = txtCode.Text.Trim();//物料代码
|
|
PickingDetail.WHCode = txtWHCode.Text.Trim();//仓库
|
|
#region
|
|
//PickingDetail.MOCode = txtMOCode.Text.Trim();//工单号
|
|
// if (txtMOCode.Text == "")
|
|
// {
|
|
// PickingDetail.MORow = "";
|
|
// }
|
|
// else
|
|
//{
|
|
// PickingDetail.MORow = txtMORow.Text.Trim();//行号
|
|
// }
|
|
#endregion
|
|
PickingDetail.Quantity = Convert.ToDecimal(txtiQuantity.Text.Trim());//应退数量
|
|
//PickingDetail.HasQuantity = Convert.ToDecimal(txtiQuantity.Text.Trim());//已退数量
|
|
PickingDetail.MTIME = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");//领料时间
|
|
|
|
PickingDetail.OutCategory = this.txtOutCategory.Text.Trim();
|
|
if (this.txtOutCategory.Text == "20202")
|
|
{
|
|
PickingDetail.RDCode = txtRDCode.Text.Trim();
|
|
}
|
|
PickingDetail.Dept = this.txtDept.Text.Trim();
|
|
Picking.FormICSPickingDetail.Add(PickingDetail);
|
|
|
|
string id = ICSPickingBLL.AddAndEditDetail(Picking, AppConfig.AppConnectString);
|
|
if (guid == "" && string.IsNullOrWhiteSpace(guid))
|
|
{
|
|
guid = id;
|
|
}
|
|
if (string.IsNullOrWhiteSpace(txtDetailId.Text.Trim()))
|
|
{
|
|
txtDetailId.Text = "";
|
|
txtirowno.Text = "";
|
|
ICSBaseSimpleCode.AppshowMessageBox(0, "新增成功");
|
|
}
|
|
else
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox(0, "维护成功");
|
|
txtWHCode.Text = "";
|
|
txtCode.Text = "";
|
|
txtcInvName.Text = "";
|
|
txtcInvStd.Text = "";
|
|
txtINVUOM.Text = "";
|
|
txtiQuantity.Text = "";
|
|
//txtMOCode.Text = "";
|
|
//txtMORow.Text = "";
|
|
txtDetailId.Text = "0";
|
|
txtDept.Text = "";
|
|
txtOutCategory.Text = "";
|
|
txtRDCode.Text = "";
|
|
}
|
|
FormICSINVENTORYEditAdd_Load(null, null);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
|
|
return;
|
|
}
|
|
}
|
|
|
|
private void btnDelDetail_Click(object sender, EventArgs e)
|
|
{
|
|
grdDetail.PostEditor();
|
|
this.Validate();
|
|
if (grdDetail.RowCount == 0)
|
|
return;
|
|
List<string> guidList = new List<string>();
|
|
List<string> codeList = new List<string>();
|
|
for (int i = 0; i < grdDetail.RowCount; i++)
|
|
{
|
|
if (grdDetail.GetRowCellValue(i, colisSelect).ToString() == "Y")
|
|
{
|
|
guidList.Add(grdDetail.GetRowCellValue(i, colID).ToString());
|
|
}
|
|
}
|
|
if (guidList.Count == 0)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("请选择数据！");
|
|
return;
|
|
}
|
|
|
|
try
|
|
{
|
|
|
|
#region 20190920ZM新增有领过料就不能删除单据行不能删除 ICSMaterialPick
|
|
|
|
string HasQuantityMsg = string.Empty;
|
|
foreach (var item in guidList)
|
|
{
|
|
string VouchCode = string.Empty;
|
|
string VouchRow = string.Empty;
|
|
|
|
string sql = @"SELECT VouchCode,VouchRow FROM ICSMaterialPick WHERE ID='" + item + "' AND HasQuantity>0";
|
|
sql = string.Format(sql);
|
|
DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
|
|
if (dt != null && dt.Rows.Count > 0)
|
|
{
|
|
VouchCode = dt.Rows[0]["VouchCode"].ToString();
|
|
VouchRow = dt.Rows[0]["VouchRow"].ToString();
|
|
HasQuantityMsg += "单号：" + VouchCode + " 行号：" + VouchRow + " 已经有领料不能删除该行！";
|
|
|
|
}
|
|
|
|
}
|
|
if (!string.IsNullOrWhiteSpace(HasQuantityMsg))
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox(HasQuantityMsg);
|
|
return;
|
|
}
|
|
#endregion
|
|
|
|
if (ICSBaseSimpleCode.AppshowMessageBoxRepose("确定删除该领料信息吗？删除后无法恢复，确定吗？") != DialogResult.OK)
|
|
return;
|
|
|
|
ICSPickingBLL.deleteDetailInfo(guidList, AppConfig.AppConnectString);
|
|
txtirowno.Text = "";
|
|
txtDetailId.Text = "";
|
|
ICSBaseSimpleCode.AppshowMessageBox(0, "删除成功");
|
|
FormICSINVENTORYEditAdd_Load(null, null);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
|
|
}
|
|
}
|
|
|
|
private void btnUpdateDetail_Click(object sender, EventArgs e)
|
|
{
|
|
int count = 0;
|
|
for (int i = 0; i < grdDetail.RowCount; i++)
|
|
{
|
|
if (grdDetail.GetRowCellValue(i, colisSelect).ToString() == "Y")
|
|
{
|
|
count++;
|
|
}
|
|
}
|
|
if (count != 1)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox("请选择数据,且只能选择一条进行编辑!!!");
|
|
return;
|
|
}
|
|
try
|
|
{
|
|
FormICSPickingModel Picking = new FormICSPickingModel();
|
|
//Picking.ID = guid;
|
|
Picking.VouchCode = txtPickingNO.Text.Trim();
|
|
//Picking.StorageID = txtStorageID.Text.Trim();
|
|
Picking.FormICSPickingDetail = new List<FormICSPickingDetailModel>();
|
|
|
|
FormICSPickingDetailModel PickingDetail = new FormICSPickingDetailModel();
|
|
//PickingDetail.DetailID = txtDetailId.Text.Trim();//领料单明细ID
|
|
//PickingDetail.PickingID = guid;//领料单ID
|
|
PickingDetail.VouchCode = txtPickingNO.Text.Trim();//退料单号
|
|
PickingDetail.SubInvCode = txtCode.Text.Trim();//物料代码
|
|
PickingDetail.WHCode = txtWHCode.Text.Trim();//仓库
|
|
//if (txtMOCode.Text == "")
|
|
//{
|
|
// PickingDetail.MOCode = "";
|
|
// PickingDetail.MORow = "";
|
|
//}
|
|
//else {
|
|
// PickingDetail.MOCode = txtMOCode.Text.Trim();//工单号
|
|
// PickingDetail.MORow = txtMORow.Text.Trim();//行号
|
|
//}
|
|
PickingDetail.Quantity = Convert.ToDecimal(txtiQuantity.Text.Trim());//应退数量
|
|
//PickingDetail.HasQuantity = Convert.ToDecimal(txtiQuantity.Text.Trim());//已退数量
|
|
//PickingDetail.CreateTIME = AppConfig.GetSeverDateTime("yyyy-MM-dd hh:mm:ss");
|
|
//PickingDetail.CreateUSER = AppConfig.UserName;
|
|
Picking.FormICSPickingDetail.Add(PickingDetail);
|
|
|
|
string id = ICSPickingBLL.AddAndEditDetail(Picking, AppConfig.AppConnectString);
|
|
if (guid == "" && string.IsNullOrWhiteSpace(guid))
|
|
{
|
|
guid = Picking.VouchCode;
|
|
}
|
|
ICSBaseSimpleCode.AppshowMessageBox(0, "修改成功");
|
|
FormICSINVENTORYEditAdd_Load(null, null);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox(ex.Message);
|
|
return;
|
|
}
|
|
}
|
|
|
|
private void grvDetail_DoubleClick(object sender, EventArgs e)
|
|
{
|
|
if (grdDetail.FocusedRowHandle < 0)
|
|
{
|
|
return;
|
|
}
|
|
for (int i = 0; i < grdDetail.RowCount; i++)
|
|
{
|
|
grdDetail.SetRowCellValue(i, colisSelect, "");
|
|
}
|
|
if (grdDetail.FocusedColumn == colisSelect)
|
|
{
|
|
if (grdDetail.GetRowCellValue(grdDetail.FocusedRowHandle, colisSelect).ToString() == "")
|
|
{
|
|
grdDetail.SetRowCellValue(grdDetail.FocusedRowHandle, colisSelect, "Y");
|
|
}
|
|
else
|
|
{
|
|
grdDetail.SetRowCellValue(grdDetail.FocusedRowHandle, colisSelect, "");
|
|
}
|
|
}
|
|
string ID = "";
|
|
for (int i = 0; i < grdDetail.RowCount; i++)
|
|
{
|
|
if (grdDetail.GetRowCellValue(i, colisSelect).ToString() == "Y")
|
|
{
|
|
ID = grdDetail.GetRowCellValue(i, colID).ToString();
|
|
}
|
|
}
|
|
DataTable dt = ICSPickingBLL.GetDetailInfo(ID);
|
|
foreach (DataRow dr in dt.Rows)
|
|
{
|
|
txtPickingNO.Text = dr["VouchCode"].ToString().Trim();
|
|
txtMTIME.Text = dr["dDate"].ToString().Trim();
|
|
txtMUSERName.Text = dr["cMaker"].ToString().Trim();
|
|
txtWHCode.Text = dr["iWHCode"].ToString().Trim();
|
|
txtCode.Text = dr["cInvCode"].ToString().Trim();
|
|
txtcInvName.Text = dr["cInvName"].ToString().Trim();
|
|
txtcInvStd.Text = dr["cInvStd"].ToString().Trim();
|
|
txtINVUOM.Text = dr["cInvStd"].ToString().Trim();
|
|
txtiQuantity.Text = dr["iQuantity"].ToString().Trim();
|
|
txtINVUOM.Text = dr["INVUOM"].ToString().Trim();
|
|
//txtMOCode.Text = dr["MOCode"].ToString().Trim();
|
|
//txtMORow.Text = dr["MORow"].ToString().Trim();
|
|
txtDetailId.Text = dr["ID"].ToString().Trim();
|
|
txtRDCode.Text = dr["RDCode"].ToString().Trim();
|
|
}
|
|
}
|
|
|
|
private void txtCode_EditValueChanged(object sender, EventArgs e)
|
|
{
|
|
try
|
|
{
|
|
string Code = txtCode.EditValue.ToString();
|
|
string sql = @"select INVCODE as 存货编码, INVNAME as 存货名称,INVSTD as 规格型号,INVUOM as 单位
|
|
from ICSINVENTORY WHERE INVCODE='{0}'";
|
|
sql = string.Format(sql, Code);
|
|
DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
|
|
if (dt != null && dt.Rows.Count > 0)
|
|
{
|
|
txtcInvName.Text = dt.Rows[0]["存货名称"].ToString();
|
|
txtcInvStd.Text = dt.Rows[0]["规格型号"].ToString();
|
|
//txtcDepName.Text = dt.Rows[0]["生产部门"].ToString();
|
|
txtINVUOM.Text = dt.Rows[0]["单位"].ToString();
|
|
txtiQuantity.Text = "";
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox(ex.ToString());
|
|
}
|
|
}
|
|
|
|
private void txtMORow_EditValueChanged_1(object sender, EventArgs e)
|
|
{
|
|
try
|
|
{
|
|
//string Row = txtMORow.EditValue.ToString();
|
|
//string sql = @"select MOCODE ,MOSEQ ,MOVER from ICSMO WHERE MOCODE='{0}' and MOSEQ='{1}'";
|
|
//sql = string.Format(sql, txtMOCode.Text.Trim(), txtMORow.Text.Trim());
|
|
//DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
|
|
//if (dt != null && dt.Rows.Count > 0)
|
|
//{
|
|
// txtMoverCode.Text = dt.Rows[0]["MOVER"].ToString();
|
|
//}
|
|
|
|
#region
|
|
//string sql1 = "SELECT MOCODE 工单号,SEQ 生产订单行号,MOBITEMCODE 存货编码 FROM ICSMOBOM WHERE MOCODE='{0}' and SEQ='{1}'";
|
|
string sql1 = "SELECT MOCODE 工单号,SEQ 生产订单行号,MOBITEMCODE 存货编码 FROM ICSMOBOM WHERE MOCODE='{0}' and SEQ='{1}'";
|
|
|
|
//sql1 = string.Format(sql1,txtMOCode.Text.Trim(),txtMORow.Text.Trim());
|
|
sql1 = string.Format(sql1);
|
|
|
|
DataTable dt1 = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql1).Tables[0];
|
|
txtCode.Properties.ValueMember = "存货编码";
|
|
txtCode.Properties.DisplayMember = "存货编码";
|
|
txtCode.Properties.DataSource = dt1;
|
|
txtCode.Properties.NullText = "";//空时的值
|
|
txtCode.Properties.ImmediatePopup = true;//输入值是否马上弹出窗体
|
|
txtCode.Properties.ValidateOnEnterKey = true;//回车确认
|
|
txtCode.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.Standard;//要使用户可以输入，这里须设为Standard
|
|
txtCode.Properties.AllowNullInput = DevExpress.Utils.DefaultBoolean.True; //可用Ctrl + Delete清空选择內容
|
|
//自适应宽度
|
|
txtCode.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
|
|
#endregion
|
|
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
ICSBaseSimpleCode.AppshowMessageBox(ex.ToString());
|
|
}
|
|
}
|
|
|
|
private void txtOutCategory_EditValueChanged(object sender, EventArgs e)
|
|
{
|
|
if (txtOutCategory.Text.ToString() == "20202")
|
|
{
|
|
txtRDCode.Properties.ReadOnly = false;
|
|
}
|
|
else
|
|
{
|
|
txtRDCode.Properties.ReadOnly = true;
|
|
}
|
|
}
|
|
|
|
public string GetSys()
|
|
{
|
|
string sql = @"SELECT DBName FROM Sys_DataBase WHERE 1=1 AND DBSourceName = 'SYS' AND WorkCode = '{0}' ";
|
|
sql = string.Format(sql, AppConfig.WorkPointCode);
|
|
DataTable dt = DBHelper.ExecuteDataset(AppConfig.AppConnectString.ToString(), CommandType.Text, sql).Tables[0];
|
|
if (dt != null && dt.Rows.Count > 0)
|
|
{
|
|
return dt.Rows[0]["DBName"].ToString();
|
|
}
|
|
else
|
|
{
|
|
return "";
|
|
}
|
|
}
|
|
}
|
|
}
|