public void SQLServerConnector() { using (var connection = new SQLServer(_msSqlConnection)) { try { connection.ExecuteNonQuery($@"CREATE TABLE [dbo].[TestTable]([id] int primary key,[value] nvarchar(255))"); for (var iter = 0; iter < 10; iter++) { var affectedCreate = connection.ExecuteNonQuery(@"INSERT INTO [dbo].[TestTable]([id],[value]) VALUES(@id,@value)", new[] { new SqlParameter("id", iter), new SqlParameter("value", "test") }); Assert.AreEqual(affectedCreate, 1); var selectedById = connection.ExecuteReader <TestTable>(@"SELECT * FROM [dbo].[TestTable] WHERE [id] = @id", new[] { new SqlParameter("id", iter) }); Assert.AreEqual(selectedById.First().id, iter); Assert.AreEqual(selectedById.First().value, "test"); var selectedByIdDynamic = connection.ExecuteReader(@"SELECT * FROM [dbo].[TestTable] WHERE [id] = @id", new[] { new SqlParameter("id", iter) }); Assert.AreEqual(selectedByIdDynamic.First().id, iter); Assert.AreEqual(selectedByIdDynamic.First().value, "test"); var affectedUpdate = connection.ExecuteNonQuery(@"UPDATE [dbo].[TestTable] SET [value] = @value WHERE [id] = @id", new[] { new SqlParameter("id", iter), new SqlParameter("value", "updated") }); Assert.AreEqual(affectedUpdate, 1); var affectedDelete = connection.ExecuteNonQuery(@"DELETE FROM [dbo].[TestTable] WHERE [id] = @id", new[] { new SqlParameter("id", iter) }); Assert.AreEqual(affectedDelete, 1); } var affectedSelectScalar = connection.ExecuteScalar <int>(@"SELECT COUNT(1) FROM [dbo].[TestTable]"); Assert.AreEqual(affectedSelectScalar, 0); Assert.Pass(); } finally { connection.ExecuteNonQuery($@"DROP TABLE [dbo].[TestTable]"); } } }
public int UpdateOutCaseBoxStorage(string out_case_code, string amount) { string updateSQL = $"UPDATE {DbTable.F_OUT_CASE_STORAGE_NAME} SET {DbTable.F_Out_Case_Storage.STORAGE_CAPACITY} = '{amount}' " + $"WHERE {DbTable.F_Out_Case_Storage.OUT_CASE_CODE} = '{out_case_code}'"; return(SQLServer.ExecuteNonQuery(updateSQL)); }
/// <summary> /// 删除某条记录 /// </summary> /// <param name="stationName"></param> /// <returns></returns> public int DeleteTypeStation(string typeNumber) { string deleteSQL = $"DELETE FROM [WT_SCL].[dbo].[Product_Process] WHERE [Type_Number] = '{typeNumber}'"; LogHelper.Log.Info($"DeleteProductType={deleteSQL}"); return(SQLServer.ExecuteNonQuery(deleteSQL)); }
private int InsertProductMaterial(string typeNo, string materialCode) { string insertSQL = $"INSERT INTO {DbTable.F_PRODUCT_MATERIAL_NAME}({DbTable.F_PRODUCT_MATERIAL.TYPE_NO},{DbTable.F_PRODUCT_MATERIAL.MATERIAL_CODE}) " + $"VALUES('{typeNo}','{materialCode}')"; return(SQLServer.ExecuteNonQuery(insertSQL)); }
/// <summary> /// 更新物料状态 0-fail,1-success /// </summary> /// <param name="materialCode"></param> /// <returns></returns> private static int UpdateMaterialState(string materialCode) { var selectSQL = $"SELECT {DbTable.F_Material.MATERIAL_STOCK}," + $"{DbTable.F_Material.MATERIAL_AMOUNTED} " + $"FROM {DbTable.F_MATERIAL_NAME} " + $"WHERE " + $"{DbTable.F_Material.MATERIAL_CODE} = '{materialCode}'"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { var stock = int.Parse(dt.Rows[0][0].ToString()); var amounted = int.Parse(dt.Rows[0][1].ToString()); LogHelper.Log.Info($"【更新物料状态】stock={stock} amounted={amounted}"); if (stock <= amounted) { //物料已使用完,更新状态为2 var updateSQL = $"UPDATE {DbTable.F_MATERIAL_NAME} SET " + $"{DbTable.F_Material.MATERIAL_STATE} = '2' WHERE " + $"{DbTable.F_Material.MATERIAL_CODE} = '{materialCode}'"; LogHelper.Log.Info($"【更新物料状态】物料已使用完成-更新状态为2"); return(SQLServer.ExecuteNonQuery(updateSQL)); } return(1); } return(0); }
public void GetTableLockInfoTest() { SQLServer objDB = null; try { objDB = TestEnvJudge(); if (objDB != null) { if (objDB.Connect()) { objDB.BeginTrans(); objDB.ExecuteNonQuery("insert into get_test values (NEXT VALUE FOR get_test_sequence,'','',SYSDATETIME(),SYSDATETIMEOFFSET())"); Assert.AreNotEqual(true, objDB.GetTableLockInfo("get_test")); objDB.RollBack(); } } } finally { if (objDB.Connect()) { objDB.Disconnect(); } objDB = null; } }
public void CreateAndDropTableTest() { SQLServer objDB = null; Random random = new Random(); try { objDB = TestEnvJudge(); if (objDB != null) { if (objDB.Connect()) { int ret = objDB.ExecuteNonQuery("CREATE TABLE Test_" + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + DateTime.Now.Millisecond + " (id int NOT NULL PRIMARY KEY, col_1 nvarchar(10) NULL, col_2 nvarchar(10) NULL, col_3 nvarchar(10) NULL);"); Assert.AreEqual(1, ret); } } } finally { if (objDB.Connect()) { objDB.Disconnect(); } objDB = null; random = null; } }
private int InsertProductType(string typeNo) { string insertSQL = $"INSERT INTO {DbTable.F_PRODUCT_TYPE_NO_NAME}({DbTable.F_TypeNo.TYPE_NO}) " + $"VALUES('{typeNo}')"; return(SQLServer.ExecuteNonQuery(insertSQL)); }
public string CommitProductMaterial(Dictionary <string, List <string> > keyValuePairs) { foreach (KeyValuePair <string, List <string> > kv in keyValuePairs) { string deleteSQL = $"DELETE FROM {DbTable.F_PRODUCT_MATERIAL_NAME} WHERE {DbTable.F_PRODUCT_MATERIAL.TYPE_NO} = '{kv.Key}'"; SQLServer.ExecuteNonQuery(deleteSQL); foreach (var v in kv.Value) { if (!IsExistProductMaterial(kv.Key, v)) { //insert if (InsertProductMaterial(kv.Key, v) < 1) { return("I0");//插入失败 } } else { // not update //if (UpdateProductMaterial(kv.Key, v) < 1) // return "G0";//更新失败 } } } return("1"); }
public void SQLServerConnectorCRUD() { using (var connection = new SQLServer(_msSqlConnection)) { try { connection.ExecuteNonQuery($@"CREATE TABLE [dbo].[TestTable]([id] int primary key,[value] nvarchar(255))"); for (var iter = 0; iter < 10; iter++) { TestTable testTable = new TestTable() { id = iter, value = $"test" }; var affectedCreate = connection.Insert(testTable); Assert.AreEqual(affectedCreate, 1); var selectedById = connection.Select <TestTable>(iter); Assert.AreEqual(selectedById.id, iter); Assert.AreEqual(selectedById.value, "test"); var selectedByIdLambda = connection.Select <TestTable>(x => x.id == iter); Assert.AreEqual(selectedByIdLambda.First().id, iter); Assert.AreEqual(selectedByIdLambda.First().value, "test"); var selectedAll = connection.Select <TestTable>(); Assert.AreEqual(selectedAll.First().id, iter); Assert.AreEqual(selectedAll.First().value, "test"); testTable.value = "updated"; var affectedUpdate = connection.Update(testTable); Assert.AreEqual(affectedUpdate, 1); var affectedUpdateLambdaValid = connection.Update(testTable, x => x.id == iter); Assert.AreEqual(affectedUpdateLambdaValid, 1); var affectedUpdateLambdaInvalid = connection.Update(testTable, x => x.id == iter + 1); Assert.AreEqual(affectedUpdateLambdaInvalid, 0); var affectedDeleteLambdaInvalid = connection.Delete <TestTable>(x => x.id == iter + 1); Assert.AreEqual(affectedDeleteLambdaInvalid, 0); var affectedDelete = connection.Delete(testTable); Assert.AreEqual(affectedDelete, 1); } var affectedSelectScalar = connection.Select <TestTable>(); Assert.AreEqual(affectedSelectScalar.Count(), 0); Assert.Pass(); } finally { connection.ExecuteNonQuery($@"DROP TABLE [dbo].[TestTable]"); } } }
private int UpdateMaterial(MaterialMsg material) { string updateSQL = $"UPDATE {DbTable.F_MATERIAL_NAME} SET {DbTable.F_Material.MATERIAL_AMOUNT} = '{material.MaterialAmount}' " + $"WHERE {DbTable.F_Material.MATERIAL_CODE} = '{material.MaterialCode}'"; LogHelper.Log.Info($"UpdateMaterial={updateSQL}"); return(SQLServer.ExecuteNonQuery(updateSQL)); }
private int InsertMaterial(MaterialMsg material) { string insertSQL = $"INSERT INTO {DbTable.F_MATERIAL_NAME}({DbTable.F_Material.MATERIAL_CODE},{DbTable.F_Material.MATERIAL_AMOUNT}) " + $"VALUES('{material.MaterialCode}','{material.MaterialAmount}')"; LogHelper.Log.Info($"InsertMaterial={insertSQL}"); return(SQLServer.ExecuteNonQuery(insertSQL)); }
public int DeleteProductMaterial(string typeNo, string materialCode) { string deleteSQL = $"DELETE FROM {DbTable.F_PRODUCT_MATERIAL_NAME} " + $"WHERE {DbTable.F_PRODUCT_MATERIAL.TYPE_NO} = '{typeNo}' AND " + $"{DbTable.F_PRODUCT_MATERIAL.MATERIAL_CODE} = '{materialCode}'"; return(SQLServer.ExecuteNonQuery(deleteSQL)); }
public static void UpdatebindTestResultHistory(string pid, string sid, int state) { var updateSQL = $"update {DbTable.F_TEST_RESULT_HISTORY_NAME} set " + $"{DbTable.F_TEST_RESULT_HISTORY.bindState} = '{state}' where " + $"{DbTable.F_TEST_RESULT_HISTORY.pcbaSN} = '{pid}' and " + $"{DbTable.F_TEST_RESULT_HISTORY.productSN} = '{sid}'"; SQLServer.ExecuteNonQuery(updateSQL); }
public int UpdatePackageProduct(PackageProduct packageProduct) { string updateSQL = $"UPDATE {DbTable.F_OUT_CASE_PRODUCT_NAME} SET " + $"{DbTable.F_Out_Case_Product.BINDING_STATE} = '{packageProduct.BindingState}' " + $"WHERE {DbTable.F_Out_Case_Product.OUT_CASE_CODE} = '{packageProduct.CaseCode}' AND " + $"{DbTable.F_Out_Case_Product.SN_OUTTER} = '{packageProduct.SnOutter}' "; LogHelper.LogInfo($"UpdatePackageProduct={updateSQL}"); return(SQLServer.ExecuteNonQuery(updateSQL)); }
//更新产品物料数量 private static int UpdateMaterialAmounted(string materialCode, int amounted) { var updateSQL = $"UPDATE {DbTable.F_MATERIAL_NAME} SET " + $"{DbTable.F_Material.MATERIAL_AMOUNTED} += '{amounted}' " + $"WHERE " + $"{DbTable.F_Material.MATERIAL_CODE} = '{materialCode}'"; LogHelper.Log.Info($"【更新物料使用总数量】amounted={amounted} " + updateSQL); return(SQLServer.ExecuteNonQuery(updateSQL)); }
private static int UpdateMaterialStatisticAmounted(string pcbaSN, string productTypeNo, string stationName, string materialCode, int amounted) { var updateSQL = $"UPDATE {DbTable.F_MATERIAL_STATISTICS_NAME} SET " + $"{DbTable.F_Material_Statistics.MATERIAL_AMOUNT} += '{amounted}' " + $"WHERE " + $"{DbTable.F_Material_Statistics.MATERIAL_CODE} = '{materialCode}' AND " + $"{DbTable.F_Material_Statistics.PRODUCT_TYPE_NO} = '{productTypeNo}' AND " + $"{DbTable.F_Material_Statistics.STATION_NAME} = '{stationName}' AND " + $"{DbTable.F_Material_Statistics.PCBA_SN} = '{pcbaSN}'"; LogHelper.Log.Info("【更新物料统计使用总数量】" + updateSQL); return(SQLServer.ExecuteNonQuery(updateSQL)); }
private static void UpdateMaterialPN(string materialPN) { if (!IsExistMaterialPN(materialPN)) { //insert new data var insertSQL = $"INSERT INTO {DbTable.F_MATERIAL_PN_NAME}(" + $"{DbTable.F_MATERIAL_PN.MATERIAL_PN}," + $"{DbTable.F_MATERIAL_PN.UPDATE_DATE}) VALUES(" + $"'{materialPN}'," + $"'{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}')"; LogHelper.Log.Info("【更新物料PN】" + insertSQL); SQLServer.ExecuteNonQuery(insertSQL); } }
public void SQLServerConnectorCRUD() { using (var connection = new SQLServer(_msSqlConnection)) { try { var datas = new List <TestTable>(); connection.CreateTable <TestTable>(); for (var iter = 0; iter < 10; iter++) { TestTable testTable = new TestTable() { id = iter, value = $"test" }; datas.Add(testTable); var affectedCreate = connection.Insert(testTable); Assert.AreEqual(affectedCreate, 1); var selectedById = connection.Query <TestTable>(primaryKey: iter); Assert.AreEqual(selectedById.id, iter); Assert.AreEqual(selectedById.value, "test"); var selectedByIdLambda = connection.Query <TestTable>(x => x.id == iter).First(); Assert.AreEqual(selectedByIdLambda.id, iter); Assert.AreEqual(selectedByIdLambda.value, "test"); var selectedAll = connection.Query <TestTable>().First(); Assert.AreEqual(selectedAll.id, iter); Assert.AreEqual(selectedAll.value, "test"); var selectFirst = connection.QueryFirst <TestTable>(); Assert.AreEqual(selectFirst.id, iter); Assert.AreEqual(selectFirst.value, "test"); testTable.value = null;//"updated"; var affectedUpdate = connection.Update(testTable); Assert.AreEqual(affectedUpdate, 1); var affectedDeleteLambdaInvalid = connection.Delete <TestTable>(x => x.id == iter + 1); Assert.AreEqual(affectedDeleteLambdaInvalid, 0); var affectedDelete = connection.Delete(testTable); Assert.AreEqual(affectedDelete, 1); } var affectedSelectScalar = connection.Query <TestTable>(); Assert.AreEqual(affectedSelectScalar.Count(), 0); Assert.AreEqual(datas.Count(), connection.InsertMany(datas)); Assert.Pass(); } finally { connection.ExecuteNonQuery("DROP TABLE [TestTable]"); } } }
/// <summary> /// 删除某条记录 /// </summary> /// <param name="stationName"></param> /// <returns></returns> public int DeleteStation(string order, string stationName) { string deleteSQL = ""; if (order == "" && stationName == "") { deleteSQL = $"DELETE FROM {DbTable.F_STATION_NAME} "; } else { deleteSQL = $"DELETE FROM {DbTable.F_STATION_NAME} " + $"WHERE {DbTable.F_Station.STATION_NAME} = '{stationName}' AND {DbTable.F_Station.STATION_ORDER} = '{order}'"; } return(SQLServer.ExecuteNonQuery(deleteSQL)); }
public int DeletePackageProduct(PackageProduct packageProduct) { string deleteSQL = ""; if (packageProduct.SnOutter == "" && packageProduct.CaseCode == "") { deleteSQL = $"DELETE FROM {DbTable.F_OUT_CASE_PRODUCT_NAME} "; } else { deleteSQL = $"DELETE FROM {DbTable.F_OUT_CASE_PRODUCT_NAME} " + $"WHERE {DbTable.F_Out_Case_Product.OUT_CASE_CODE} = '{packageProduct.CaseCode}' AND " + $"{DbTable.F_Out_Case_Product.SN_OUTTER} = '{packageProduct.SnOutter}'"; } return(SQLServer.ExecuteNonQuery(deleteSQL)); }
/// <summary> /// 执行更新数据库产品型号所属站位表 /// </summary> /// <param name="order"></param> /// <param name="stationName"></param> /// <returns></returns> private bool UpdateTypeStation(string typeNumber, string[] arrayStation) { string updateSQL = "UPDATE [WT_SCL].[dbo].[Product_Process] " + $"SET Station_Name_1 = '{arrayStation[0]}',Station_Name_2='{arrayStation[1]}',Station_Name_3='{arrayStation[2]}'," + $"Station_Name_4='{arrayStation[3]}',Station_Name_5='{arrayStation[4]}',Station_Name_6 = '{arrayStation[5]}'," + $"Station_Name_7 = '{arrayStation[6]}',Station_Name_8 = '{arrayStation[7]}',Station_Name_9 = '{arrayStation[8]}',Station_Name_10 = '{arrayStation[9]}' " + $"WHERE Type_Number = '{typeNumber}'"; int r = SQLServer.ExecuteNonQuery(updateSQL); LogHelper.Log.Info($"Update Product Type Number={updateSQL}"); if (r > 0) { return(true); } return(false); }
public int CommitOutCaseBoxStorage(string out_case_code, string amount) { string insertSQL = $"INSERT INTO {DbTable.F_OUT_CASE_STORAGE_NAME}({DbTable.F_Out_Case_Storage.OUT_CASE_CODE},{DbTable.F_Out_Case_Storage.STORAGE_CAPACITY}) " + $"VALUES('{out_case_code}','{amount}')"; if (IsExistOutCaseBoxStorage(out_case_code)) { //update return(UpdateOutCaseBoxStorage(out_case_code, amount)); } else { //insert return(SQLServer.ExecuteNonQuery(insertSQL)); } }
private static bool UpdateCurrentMaterialRemain(string materialCode, string typeNo, string stationName, string pcbaSN) { try { var selectSQL = $"SELECT {DbTable.F_Material.MATERIAL_STOCK},{DbTable.F_Material.MATERIAL_AMOUNTED} " + $"FROM {DbTable.F_MATERIAL_NAME} WHERE {DbTable.F_Material.MATERIAL_CODE} = '{materialCode}'"; var dtOrigin = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dtOrigin.Rows.Count > 0) { var stock = dtOrigin.Rows[0][0].ToString(); var amount = dtOrigin.Rows[0][1].ToString(); var remainTotal = int.Parse(stock) - int.Parse(amount); //更新当前物料剩余库存 var updateRemain = $"UPDATE {DbTable.F_MATERIAL_STATISTICS_NAME} SET " + $"{DbTable.F_Material_Statistics.MATERIAL_CURRENT_REMAIN} = '{remainTotal}' " + $"WHERE {DbTable.F_Material_Statistics.MATERIAL_CODE} = '{materialCode}' " + $"AND " + $"{DbTable.F_Material_Statistics.PRODUCT_TYPE_NO} = '{typeNo}' " + $"AND " + $"{DbTable.F_Material_Statistics.STATION_NAME} = '{stationName}' " + $"AND " + $"{DbTable.F_Material_Statistics.PCBA_SN} = '{pcbaSN}'"; var dtRemain = SQLServer.ExecuteNonQuery(updateRemain); if (dtRemain > 0) { LogHelper.Log.Info("【当前物料剩余数量更新成功!】"); return(true); } else { LogHelper.Log.Info("【当前物料剩余数量更新失败!】" + updateRemain); return(false); } } else { LogHelper.Log.Info("【更新物料剩余数量-查询库存与使用总数失败】" + selectSQL); return(false); } } catch (Exception ex) { LogHelper.Log.Error("更新物料剩余数量异常-" + ex.Message); return(false); } }
/// <summary> /// 配置产线包含哪些站位,按顺序插入 /// </summary> /// <param name="dctData"></param> /// <returns>成功返回1,失败返回0+空格+序号+键+空格+值</returns> public int InsertStation(List <Station> stationList) { LogHelper.Log.Info($"接口被调用-InsertProduce"); foreach (var station in stationList) { if (!IsExistStation(station.StationID, station.StationName)) { //不存在,插入 string insertSQL = $"INSERT INTO {DbTable.F_STATION_NAME}({DbTable.F_Station.STATION_ORDER}," + $"{DbTable.F_Station.STATION_NAME}) " + $"VALUES('{station.StationID}','{station.StationName}')"; return(SQLServer.ExecuteNonQuery(insertSQL)); } } return(-1); }
/* * 1)check是否入库 * 2)未入库则入库,更新数据 */ public static string CheckMaterialPutInStorage(Queue <string[]> queue) { var array = queue.Dequeue(); var materialCode = array[0]; var teamLeader = array[1]; var admin = array[2]; var selectSQL = $"SELECT {DbTable.F_Material.MATERIAL_STATE} FROM " + $"{DbTable.F_MATERIAL_NAME} WHERE {DbTable.F_Material.MATERIAL_CODE} = '{materialCode}'"; LogHelper.Log.Info("【查询入库记录】" + selectSQL); var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { //查询有记录,已经入过库 return(ConvertCheckMaterialPutInStorage(MaterialCheckPutStorageEnum.STATUS_IS_PUTED_IN_STORAGE)); } //记录不存在-未入库 //更新入库记录: //插入物料信息-更新物料状态1+更新物料库存 // var insertSQL = $"INSERT INTO {DbTable.F_MATERIAL_NAME}(" + $"{DbTable.F_Material.MATERIAL_CODE}," + $"{DbTable.F_Material.MATERIAL_STOCK}," + $"{DbTable.F_Material.MATERIAL_TEAM_LEADER}," + $"{DbTable.F_Material.MATERIAL_ADMIN}," + $"{DbTable.F_Material.MATERIAL_UPDATE_DATE}) VALUES(" + $"'{materialCode}'," + $"'{MaterialCodeMsg.GetMaterialDetail(materialCode).MaterialQTY}'," + $"'{teamLeader}'," + $"'{admin}'," + $"'{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}')"; LogHelper.Log.Info("【入库】" + insertSQL); var iRes = SQLServer.ExecuteNonQuery(insertSQL); if (iRes == 1)//新入库成功 { LogHelper.Log.Info("【入库】入库成功"); //更新物料PN UpdateMaterialPN(MaterialCodeMsg.GetMaterialPN(materialCode)); return(ConvertCheckMaterialPutInStorage(MaterialCheckPutStorageEnum.STATUS_IS_NEW_PUT_INT_STORAGE)); } LogHelper.Log.Info("【入库失败】"); return(ConvertCheckMaterialPutInStorage(MaterialCheckPutStorageEnum.STATUS_IS_PUT_IN_FAIL_STORAGE)); }
public int DeleteMaterial(string materialCode) { string deleteSQL = ""; if (string.IsNullOrEmpty(materialCode)) { //delete all data deleteSQL = $"DELETE FROM {DbTable.F_MATERIAL_NAME}"; } else { //delete one row deleteSQL = $"DELETE FROM {DbTable.F_MATERIAL_NAME} " + $"WHERE {DbTable.F_Material.MATERIAL_CODE} = '{materialCode}'"; } return(SQLServer.ExecuteNonQuery(deleteSQL)); }
public static string UpdateLimitConfig(Queue <string[]> pvqueue) { try { string[] array = pvqueue.Dequeue(); var stationName = array[0]; var typeNo = array[1]; var testItem = array[2]; var limitValue = array[3]; var teamLeader = array[4]; var admin = array[5]; //limit可能为路径 LogHelper.Log.Info(limitValue); if (limitValue.Contains("\\")) { limitValue = limitValue.Replace("\\", "\\\\"); LogHelper.Log.Info(limitValue); } var insertSQL = $"INSERT INTO {DbTable.F_TEST_LIMIT_CONFIG_NAME}(" + $"{DbTable.F_TEST_LIMIT_CONFIG.STATION_NAME}," + $"{DbTable.F_TEST_LIMIT_CONFIG.TYPE_NO}," + $"{DbTable.F_TEST_LIMIT_CONFIG.TEST_ITEM}," + $"{DbTable.F_TEST_LIMIT_CONFIG.LIMIT}," + $"{DbTable.F_TEST_LIMIT_CONFIG.TEAM_LEADER}," + $"{DbTable.F_TEST_LIMIT_CONFIG.ADMIN}," + $"{DbTable.F_TEST_LIMIT_CONFIG.UPDATE_DATE}) VALUES(" + $"'{stationName}','{typeNo}','{testItem}','{limitValue}','{teamLeader}','{admin}','{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}')"; //if (IsExistLimit(typeNo, stationName, testItem, limitValue, teamLeader, admin)) // return "OK"; var res = SQLServer.ExecuteNonQuery(insertSQL); if (res > 0) { return("OK"); } else { LogHelper.Log.Info(insertSQL); return("FAIL"); } } catch (Exception ex) { LogHelper.Log.Error(ex.Message); return("ERROR"); } }
public static string UpdateProgrameVersion(Queue <string[]> pvqueue) { try { string[] array = pvqueue.Dequeue(); var typeNo = array[0]; var stationName = array[1]; var programePath = array[2]; var programeName = array[3]; var teamLeader = array[4]; var admin = array[5]; LogHelper.Log.Info(programePath); if (programePath.Contains("\\")) { programePath = programePath.Replace("\\", "\\\\"); LogHelper.Log.Info(programePath); } var insertSQL = $"INSERT INTO {DbTable.F_TEST_PROGRAME_VERSION_NAME}(" + $"{DbTable.F_TEST_PROGRAME_VERSION.TYPE_NO}," + $"{DbTable.F_TEST_PROGRAME_VERSION.STATION_NAME}," + $"{DbTable.F_TEST_PROGRAME_VERSION.PROGRAME_NAME}," + $"{DbTable.F_TEST_PROGRAME_VERSION.PROGRAME_VERSION}," + $"{DbTable.F_TEST_PROGRAME_VERSION.TEAM_LEADER}," + $"{DbTable.F_TEST_PROGRAME_VERSION.ADMIN}," + $"{DbTable.F_TEST_PROGRAME_VERSION.UPDATE_DATE}) VALUES(" + $"'{typeNo}','{stationName}','{programePath}','{programeName}'," + $"'{teamLeader}','{admin}','{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}')"; //if (IsExistVersion(typeNo, stationName, programeName, programeVersion, teamLeader, admin)) // return "OK"; var res = SQLServer.ExecuteNonQuery(insertSQL); if (res > 0) { return("OK"); } else { LogHelper.Log.Info(insertSQL); return("FAIL"); } } catch (Exception ex) { LogHelper.Log.Error(ex.Message); return("ERROR"); } }
/// <summary> /// 记录抽检时,不合格数据 /// </summary> private static void InsertProductCheckRecord(string outCaseCode, string snOutter, string typeNo, string stationName, string bindingState, string remark, string teamdLeader, string admin) { string insertSQL = $"INSERT INTO {DbTable.F_PRODUCT_CHECK_RECORD_NAME}(" + $"{DbTable.F_Out_Case_Product.OUT_CASE_CODE}," + $"{DbTable.F_Out_Case_Product.SN_OUTTER}," + $"{DbTable.F_Out_Case_Product.TYPE_NO}," + $"{DbTable.F_Out_Case_Product.STATION_NAME}," + $"{DbTable.F_Out_Case_Product.BINDING_STATE}," + $"{DbTable.F_Out_Case_Product.REMARK}," + $"{DbTable.F_Out_Case_Product.TEAM_LEADER}," + $"{DbTable.F_Out_Case_Product.ADMIN}," + $"{DbTable.F_Out_Case_Product.BINDING_DATE}) VALUES(" + $"'{outCaseCode}','{snOutter}','{typeNo}','{stationName}'," + $"'{bindingState}','{remark}','{teamdLeader}','{admin}','{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")}')"; SQLServer.ExecuteNonQuery(insertSQL); }