public bool GetExistsCheckCode(GwType gwID, int assemblyID)
{
string sql = @"select count(1) from CheckCodeInfo where FGWID = @gwID and FAssemblyID = @assemblyID";
using (var conn = new DbHelperSQL(config).GetConnection())
{
return(conn.QuerySingle <int>(sql, new { gwID = gwID, assemblyID = assemblyID }) > 0);
}
}
/// <summary>
/// save data
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
private bool SaveData(RecordInfo info, GwType type)
{
bool re = false;
if (info != null)
{
re = dal.SaveInfo(info, type);
}
return(re);
}
public void BarCodeMatch(string barcode, GwType gw)
{
Dispatcher.InvokeAsync(() =>
{
switch (gw)
{
case GwType.OP01:
if (gwcode1.Text.Trim() == string.Empty)
{
if (barcode.Contains(codeInfo1.FBarCodeRule))
{
gwcode1.Text = barcode;
}
else
{
remark1.Text = "装配条码 NG！";
}
}
else
{
var co = entry1.Find(f => barcode.Contains(f.FCodeRule));
if (co != null)
{
barlist1.Add(barcode);
entry1.Remove(co);
}
}
break;
case GwType.OP40:
if (gwcode2.Text.Trim() == string.Empty)
{
if (barcode.Contains(codeInfo2.FBarCodeRule))
{
gwcode2.Text = barcode;
}
else
{
remark2.Text = "装配条码 NG！";
}
}
else
{
var co = entry2.Find(f => barcode.Contains(f.FCodeRule));
if (co != null)
{
barlist2.Add(barcode);
entry2.Remove(co);
}
}
break;
case GwType.OP70:
// 需要更改
if (gwcode3.Text.Trim() == string.Empty)
{
if (barcode.Contains(codeInfo3.FBarCodeRule))
{
gwcode3.Text = barcode;
}
else
{
remark3.Text = "装配条码 NG！";
}
}
else if (custcode.Text.Trim() == string.Empty)
{
//var co = entry3.Find(f => barcode.Contains(f.FCodeRule));
//if (co != null)
//{
// barlist3.Add(barcode);
// entry3.Remove(co);
//}
custcode.Text = barcode;
}
break;
case GwType.OP80:
// 扫客户条码
if (gwcode4.Text.Trim() == string.Empty)
{
gwcode4.Text = barcode;
}
//if (gwcode4.Text.Trim() == string.Empty)
//{
// if (barcode.Contains(codeInfo4.FBarCodeRule))
// {
// gwcode4.Text = barcode;
// }
// else
// {
// remark4.Text = "装配条码 NG！";
// }
//}
break;
}
});
}
public bool SaveInfo(RecordInfo info, GwType type)
{
string sql = @" INSERT INTO RecordInfo (FGWID,FAssemblyID,FBar,FCustBar,FDate) values
(@gwID,@assemblyID,@codeRule,@custBar,GETDATE());select SCOPE_IDENTITY();";
string sql1 = @"INSERT INTO RecordInfoEntry (FInterID,FCode) VALUES(@Id,@codeRule) ";
string sql2 = @"INSERT INTO RecordInfoEntry1 (FInterID,FValue) VALUES(@Id,@value) ";
string update = @"UPDATE RecordInfo SET FCustBar = @cust WHERE FBar = @bar";
string sql3 = @"select FBar from RecordInfo where FCustBar = @cust";
using (var conn = new DbHelperSQL(config).GetConnection())
{
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
if (type == GwType.OP70) // 绑定客户条码
{
if (!string.IsNullOrEmpty(info.FBar) && !string.IsNullOrEmpty(info.FCustBar))
{
SqlCommand up1 = new SqlCommand(update, conn, tran);
up1.Parameters.AddWithValue("@cust", info.FCustBar);
up1.Parameters.AddWithValue("@bar", info.FBar);
up1.ExecuteNonQuery();
}
}
else if (type == GwType.OP80)
{
if (!string.IsNullOrEmpty(info.FCustBar))
{
info.FBar = conn.QuerySingleOrDefault <string>(sql3, new { cust = info.FCustBar });
}
}
SqlCommand cmd = new SqlCommand(sql, conn, tran);
cmd.Parameters.AddWithValue("@gwID", info.FGWID);
cmd.Parameters.AddWithValue("@assemblyID", info.FAssemblyID);
cmd.Parameters.AddWithValue("@codeRule", info.FBar);
cmd.Parameters.AddWithValue("@custBar", info.FCustBar);
long id = Convert.ToInt64(cmd.ExecuteScalar());
// 零件条码
if (info.entries != null)
{
if (info.entries.Any())
{
foreach (var l in info.entries)
{
SqlCommand cmd1 = new SqlCommand(sql1, conn, tran);
cmd1.Parameters.AddWithValue("@Id", id);
cmd1.Parameters.AddWithValue("@codeRule", l.FCode);
cmd1.ExecuteNonQuery();
}
}
}
// 气检数据
if (info.entries1 != null)
{
if (info.entries1.Any())
{
foreach (var l in info.entries1)
{
SqlCommand cmd1 = new SqlCommand(sql2, conn, tran);
cmd1.Parameters.AddWithValue("@Id", id);
cmd1.Parameters.AddWithValue("@value", l.FVaule);
cmd1.ExecuteNonQuery();
}
}
}
tran.Commit();
return(true);
}
catch (Exception ex)
{
log.Error(ex.Message);
tran.Rollback();
return(false);
}
}
#endregion
}
/// <summary>
/// Get a window with given relationship to given window
/// </summary>
/// <param name="hWnd">Handle of the reference window</param>
/// <param name="gwType">Relationship to the reference window</param>
/// <returns>Handle for the window found or IntPtr.ZERO </returns>
internal static IntPtr GetWindow(IntPtr hWnd, GwType gwType) {
return new IntPtr( GetWindow_( hWnd, (uint) gwType) );
}
