public Form_PrintSetEditor(PrintSet print)
{
InitializeComponent();
_print = print;
InitSNTable();
InitPackageTable();
}
protected void Page_Load(object sender, EventArgs e)
{
string TemplateType = Request.QueryString["TemplateType"];
WsSystem ws = new WsSystem();
PrintSet obj = ws.QueryPrintSetPath(TemplateType);
if (obj != null)
{
string name = string.Empty;
if (obj.MEMO == "箱号模板")
{
name = "csn.lab";
}
if (obj.MEMO == "条码模板")
{
name = "psn.lab";
}
else
{
name = "msn.lab";
}
downloadfile(obj.TemplatePath, name);
}
}
private void QueryPrint()
{
lock (lockObj)
{
try
{
StringBuilder queryStrbd = new StringBuilder();
queryStrbd.Append("select * from PrintSet order by Oid desc");
//_packageSetTable.Rows.Clear();//清除行数据，但是行保留
DataTable dt = new DataTable();
dt = new SQLiteHelper().ExecuteQuery(queryStrbd.ToString());
List <PrintSet> packageList = new List <PrintSet>();
foreach (DataRow row in dt.Rows)
{
PrintSet print = new PrintSet();
print.Oid = row["Oid"] == DBNull.Value ? 0 : Convert.ToInt32(row["Oid"]);
print.FinishedProductNum = row["FinishedProductNum"] == DBNull.Value ? "" : (string)row["FinishedProductNum"];
packageList.Add(print);
}
QueryPrintCallbackDel del = QueryPrintCallback;
comboBox1.BeginInvoke(del, packageList);
return;
}
catch (Exception ex)
{
LogHelper.WriteLog("QueryPrint", ex);
}
}
}
/// <summary>
/// 添加/更新成品配置
/// </summary>
/// <param name="print"></param>
private void InsertOrUpdatePrintSet(PrintSet print)
{
lock (lockObj)
{
try
{
if (print == null)
{
MessageBox.Show("待添加/更新的记录为空", "Error");
}
StringBuilder noQueryStrbd = new StringBuilder();
StringBuilder queryStrbd = new StringBuilder();
List <SQLiteParameter[]> paramList = new List <SQLiteParameter[]>();
SQLiteParameter[] parameter =
{
SQLiteHelper.MakeSQLiteParameter("@Oid", DbType.Int32, print.Oid),
SQLiteHelper.MakeSQLiteParameter("@FinishedProductNum", DbType.String, print.FinishedProductNum),
SQLiteHelper.MakeSQLiteParameter("@SN", DbType.String, print.SN),
SQLiteHelper.MakeSQLiteParameter("@Package", DbType.String, print.Package)
};
paramList.Add(parameter);
if (print.Oid == 0)
{
//添加新数据
noQueryStrbd.Append(@"Insert into PrintSet (FinishedProductNum,SN,Package) ")
.Append(@"values ( ")
.Append(@"@FinishedProductNum,@SN,@Package ")
.Append(@")");
queryStrbd.Append(@"select * from PrintSet where FinishedProductNum=@FinishedProductNum");
}
else
{
//更新数据
noQueryStrbd.Append(@"Update PrintSet set FinishedProductNum=@FinishedProductNum,SN=@SN,Package=@Package ")
.Append(@" WHERE Oid=@Oid");
queryStrbd.Append(@"select * from PrintSet where FinishedProductNum=@FinishedProductNum and Oid!=@Oid");
}
DataTable existTable = new SQLiteHelper().ExecuteQuery(queryStrbd.ToString(), parameter);
bool isrepeat = true;
if (existTable.Rows.Count == 0)
{
isrepeat = false;
new SQLiteHelper().ExecuteNonQueryBatch(noQueryStrbd.ToString(), paramList);
}
InsertOrUpdatePrintSetCallBackDel del = InsertOrUpdatePrintSetCallBack;
this.BeginInvoke(del, isrepeat);
return;
}
catch (Exception ex)
{
LogHelper.WriteLog("InsertOrUpdatePrintSet", ex);
}
}
}
private void QueryPrintCallback(List <PrintSet> printlist)
{
comboBox1.DataSource = printlist;
comboBox1.DisplayMember = "FinishedProductNum";
comboBox1.ValueMember = "Oid";
if (_goodro != null && _goodro.Oid != 0)
{
PrintSet selectedPrint = printlist.FirstOrDefault(p => p.Oid == _goodro.FinishedProductNum);
comboBox1.Text = selectedPrint == null ? "" : selectedPrint.FinishedProductNum;
}
return;
}
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
}
public Msg <PrintSet> Printers()
{
Msg <PrintSet> msg = new Msg <PrintSet>();
try
{
PrintSet ps = new PrintSet()
{
DefaultPrinters = PrinterConfig.Printers, SystemPrinters = PrinterConfig.SystemPrinters
};
msg.Result = true;
msg.Object = ps;
}
catch (Exception e)
{
msg.Content = e.Message;
LogUtil.Logger.Error(e.Message);
}
return(msg);
}
/// <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();
}
protected bool SaveToDB(string path, string savepath)
{
try
{
string templatetype = DropDownList1.SelectedItem.Value;
string templatetypename = DropDownList1.SelectedItem.Text;
WsSystem ws = new WsSystem();
PrintSet bb = new PrintSet();
bb.ID = "";
bb.TemplatePath = savepath;
bb.TemplateType = templatetype;
bb.MEMO = templatetypename;
bb.ACTIVE = "0";
ws.SavePrintLabelTemplate(bb);
return(true);
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
return(false);
}
}
/// <summary>
/// 提交
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(textBox2.Text))
{
MessageBox.Show("成品料号不可为空", "Warning");
return;
}
#region 装载Print
PrintSet print = new PrintSet();
int oid = 0;
print.Oid = int.TryParse(textBox1.Text.Trim(), out oid) ? oid : 0;
print.FinishedProductNum = textBox2.Text.Trim();
print.SN = SN_TableToJson();
print.Package = Package_TableToJson();
#endregion
#region 判断SN和Package
if (!string.IsNullOrWhiteSpace(print.SN))
{
List <SN> snList = JsonConvert.DeserializeObject <List <SN> >(print.SN);
if (snList.Where(s => s.IsUsed == true).Select(s => s.Name.Trim().ToUpper()).Distinct().Count() != snList.Where(s => s.IsUsed == true).ToList().Count)
{
MessageBox.Show("The name of SN is unique!");
}
}
if (!string.IsNullOrWhiteSpace(print.Package))
{
List <Package> packageList = JsonConvert.DeserializeObject <List <Package> >(print.Package);
if (packageList.Select(s => s.Name.Trim().ToUpper()).Distinct().Count() != packageList.Count)
{
MessageBox.Show("The name of Package is unique!", "Warning");
}
}
#endregion
Task.Run(() => InsertOrUpdatePrintSet(print));
//InsertOrUpdatePrintSet(print);
return;
}
