public void GetPrintSetAndGoodSet(string text)
{
if (string.IsNullOrWhiteSpace(text))
{
return;
}
#region 这里做流程控制，在同一个线程中操作
try
{
using (PrintSetServiceClient client = new PrintSetServiceClient())
{
//2、获取打印配置
DataTable psdt = client.GetPrintSetByFPNum(text);
if (psdt == null || psdt.Rows.Count == 0)
{
Speecher("Print Config is null");
return;
}
//3、获取成品配置
DataTable gsdt = client.GetGoodSetByFPNum(text);
if (gsdt == null || gsdt.Rows.Count == 0)
{
Speecher("Goods Config is null");
return;
}
//4、获取Ro配置
DataTable rsdt = client.GetRoSetByFPNum(text);
if (rsdt == null || rsdt.Rows.Count == 0)
{
Speecher("Ro# Config is null");
return;
}
button4.BackColor = Color.Green;
List <PrintSet> printsetList = PrintSet.DataTableToList(psdt);
List <RoSet> rosetList = RoSet.DataTableToList(rsdt);
List <GoodSet> goodsetList = GoodSet.DataTableToList(gsdt);
_currentPrintSet = null;
_currentPrintSet = printsetList.OrderByDescending(p => p.CreateTime).First();
_currentRoSet = null;
_currentRoSet = rosetList.OrderByDescending(r => r.Oid).First();
_currentGoodSetList = null;
_currentGoodSetList = goodsetList;
GotoNextTextBox(FinishedProductNum);
}
}
catch (Exception ex)
{
LogHelper.WriteLog("GetPrintSetAndGoodSet", ex);
}
#endregion
}
/// <summary>
/// 提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(textBox3.Text))
{
MessageBox.Show("RoNumber is null", "Warning");
return;
}
#region 装载Ro
RoSet goodro = new RoSet();
int oid = 0;
goodro.Oid = int.TryParse(textBox1.Text.Trim(), out oid) ? oid : 0;
int fpoid = 0;
goodro.FinishedProductNum = int.TryParse(comboBox1.SelectedValue.ToString(), out fpoid) ? fpoid : 0;
goodro.RoNumber = textBox3.Text.Trim();
#endregion
Task.Run(() => InsertOrUpdateGoodRoSet(goodro));
return;
}
/// <summary>
/// 添加/更新成品Ro#配置
/// </summary>
/// <param name="ro"></param>
private void InsertOrUpdateGoodRoSet(RoSet ro)
{
lock (lockObj)
{
try
{
if (ro == null)
{
MessageBox.Show("RoSet is null!", "Error");
}
StringBuilder noQueryStrbd = new StringBuilder();
List <SQLiteParameter[]> paramList = new List <SQLiteParameter[]>();
SQLiteParameter[] parameter =
{
SQLiteHelper.MakeSQLiteParameter("@Oid", DbType.Int32, ro.Oid),
SQLiteHelper.MakeSQLiteParameter("@FinishedProductNum", DbType.Int32, ro.FinishedProductNum),
SQLiteHelper.MakeSQLiteParameter("@RoNumber", DbType.String, ro.RoNumber),
};
paramList.Add(parameter);
if (ro.Oid == 0)
{
//添加新数据
noQueryStrbd.Append(@"Insert into RoSet (FinishedProductNum,RoNumber) ")
.Append(@"values ( ")
.Append(@"@FinishedProductNum,@RoNumber ")
.Append(@")");
}
else
{
//更新数据
noQueryStrbd.Append(@"Update RoSet set FinishedProductNum=@FinishedProductNum,RoNumber=@RoNumber ")
.Append(@" WHERE Oid=@Oid");
}
new SQLiteHelper().ExecuteNonQueryBatch(noQueryStrbd.ToString(), paramList);
InsertOrUpdateRoSetCallBackDel del = InsertOrUpdateRoSetCallBack;
this.BeginInvoke(del);
return;
}
catch (Exception ex)
{
throw ex;
}
}
}
/// <summary>
/// 初始化
/// </summary>
public void LabelPrintClear()
{
_currentPrintSet = null;
_currentRoSet = null;
_currentGoodSetList = null;
_snList.Clear();
_idStr = "";
button4.BackColor = Color.Red;
FinishedProductNum.Clear();
FinishedProductNum.ReadOnly = false;
ONU.Clear();
ONU.ReadOnly = true;
VVDSL.Clear();
VVDSL.ReadOnly = true;
TELSET.Clear();
TELSET.ReadOnly = true;
BIZBOX.Clear();
BIZBOX.ReadOnly = true;
labelID.Clear();
FinishedProductNum.Focus();
}
public Form_GoodRoEditor(RoSet goodro)
{
InitializeComponent();
_goodro = goodro;
}
