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