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) ); }