public static string[] SelectPVersion(Queue <string[]> queue) { var array = queue.Dequeue(); var productTypeNo = array[0]; var productStation = array[1]; var selectSQL = $"SELECT top 1 {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} FROM " + $"{DbTable.F_TEST_PROGRAME_VERSION_NAME} " + $"WHERE " + $"{DbTable.F_TEST_PROGRAME_VERSION.TYPE_NO} = '{productTypeNo}' AND " + $"{DbTable.F_TEST_PROGRAME_VERSION.STATION_NAME} = '{productStation}' " + $"ORDER BY " + $"{DbTable.F_TEST_PROGRAME_VERSION.UPDATE_DATE} ASC"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count < 1) { return new string[] { "query result is null" } } ; var typeNo = dt.Rows[0][0].ToString(); var stationName = dt.Rows[0][1].ToString(); var programeName = dt.Rows[0][2].ToString(); var programeVersion = dt.Rows[0][3].ToString(); var teamLeader = dt.Rows[0][4].ToString(); var admin = dt.Rows[0][5].ToString(); return(new string[] { typeNo, stationName, programeName, programeVersion, teamLeader, admin }); } }
public static string[] SelectSpecLimit(Queue <string[]> queue) { var array = queue.Dequeue(); var productTypeNo = array[0]; var productStation = array[1]; var productItem = array[2]; var selectSQL = $"SELECT top 1 {DbTable.F_TEST_LIMIT_CONFIG.TYPE_NO}," + $"{DbTable.F_TEST_LIMIT_CONFIG.STATION_NAME}," + $"{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} FROM " + $"{DbTable.F_TEST_LIMIT_CONFIG_NAME} " + $"WHERE " + $"{DbTable.F_TEST_LIMIT_CONFIG.TYPE_NO} = '{productTypeNo}' AND " + $"{DbTable.F_TEST_LIMIT_CONFIG.STATION_NAME} = '{productStation}' AND " + $"{DbTable.F_TEST_LIMIT_CONFIG.TEST_ITEM} = '{productItem}' " + $"ORDER BY " + $"{DbTable.F_TEST_LIMIT_CONFIG.UPDATE_DATE} ASC"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count < 1) { return new string[] { "query result is null" } } ; var typeNo = dt.Rows[0][0].ToString(); var stationName = dt.Rows[0][1].ToString(); var item = dt.Rows[0][2].ToString(); var limit = dt.Rows[0][3].ToString(); var teamLeader = dt.Rows[0][4].ToString(); var admin = dt.Rows[0][5].ToString(); return(new string[] { typeNo, stationName, item, limit, teamLeader, admin }); }
/// <summary> /// 查询用户信息 /// </summary> /// <param name="userName"></param> /// <returns></returns> public QueryResult GetUserInfo(string username, out DataSet dataSet) { string sqlString = "SELECT * " + "FROM [WT_SCL].[dbo].[f_user] " + "WHERE " + $"[username] = '{username}' or [phone] = '{username}' or [email] = '{username}' "; try { dataSet = SQLServer.ExecuteDataSet(sqlString); if (dataSet.Tables[0].Rows.Count < 1) { return(QueryResult.NONE_DATE); } else { return(QueryResult.EXIST_DATA); } } catch (Exception ex) { LogHelper.Log.Error("获取用户信息异常..." + ex.Message + "\r\n" + ex.StackTrace + "\r\nSQL:" + sqlString); dataSet = null; return(QueryResult.EXCEPT_ERR); } }
private static UPackageProduct IsExist(string caseCode, string snOutter) { var selectSQL = $"SELECT {DbTable.F_Out_Case_Product.BINDING_STATE} " + $"FROM {DbTable.F_OUT_CASE_PRODUCT_NAME} WHERE " + $"{DbTable.F_Out_Case_Product.OUT_CASE_CODE} = '{caseCode}' AND " + $"{DbTable.F_Out_Case_Product.SN_OUTTER} = '{snOutter}'"; LogHelper.Log.Info(selectSQL); var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; UPackageProduct uPackageProduct = new UPackageProduct(); if (dt.Rows.Count > 0) { uPackageProduct.IsRecordExist = true; var value = dt.Rows[0][0].ToString(); if (value == "0") { uPackageProduct.IsProductBinding = false; } else if (value == "1") { uPackageProduct.IsProductBinding = true; } } else { uPackageProduct.IsRecordExist = false; } return(uPackageProduct); }
/// <summary> /// 上位机查询上一站位的所有记录 /// </summary> /// <param name="sn"></param> /// <param name="typeNo"></param> /// <param name="station"></param> /// <returns></returns> public DataSet SelectLastTestResultUpper(string sn, string typeNo, string station) { //根据型号与站位,查询其上一站位 SQLServer.SqlConnectionString = connectionString; LogHelper.Log.Info("上位机查询测试结果,传入站位为" + station); string selectOrderSQL = $"SELECT {DbTable.F_Product_Station.STATION_ORDER} FROM {DbTable.F_PRODUCT_STATION_NAME} " + $"WHERE {DbTable.F_Product_Station.STATION_NAME} = '{station}'"; LogHelper.Log.Info(selectOrderSQL); DataTable dt = SQLServer.ExecuteDataSet(selectOrderSQL).Tables[0]; int lastOrder = int.Parse(dt.Rows[0][0].ToString()) - 1; selectOrderSQL = $"SELECT {DbTable.F_Product_Station.STATION_NAME} FROM {DbTable.F_PRODUCT_STATION_NAME} " + $"WHERE {DbTable.F_Product_Station.STATION_ORDER} = '{lastOrder}'"; dt = SQLServer.ExecuteDataSet(selectOrderSQL).Tables[0]; station = dt.Rows[0][0].ToString(); LogHelper.Log.Info("测试端查询测试结果,上一站位为" + station); //由上一站位查询记录 string selectSQL = $"SELECT {DbTable.F_Test_Result.SN},{DbTable.F_Test_Result.TYPE_NO}," + $"{DbTable.F_Test_Result.STATION_NAME},{DbTable.F_Test_Result.TEST_RESULT}," + $"{DbTable.F_Test_Result.UPDATE_DATE},{DbTable.F_Test_Result.REMARK} " + $"FROM {DbTable.F_TEST_RESULT_NAME} " + $"WHERE {DbTable.F_Test_Result.SN} = '{sn}' AND {DbTable.F_Test_Result.TYPE_NO} = '{typeNo}' AND " + $"{DbTable.F_Test_Result.STATION_NAME} = '{station}'" + $"ORDER BY {DbTable.F_Test_Result.UPDATE_DATE}"; return(SQLServer.ExecuteDataSet(selectSQL)); }
/// <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); }
/// <summary> /// 查询结果 /// </summary> /// <param name="snInner"></param> /// <param name="snOutter"></param> /// <param name="typeNumber"></param> /// <param name="stationName"></param> /// <returns></returns> public static DataSet SelectProductData(string snInner, string snOutter, string typeNumber, string stationName) { string selectSQL = "SELECT [SN],[Type_Number],[Station_Name],[Test_Result],[CreateDate],[UpdateDate],[Remark] " + "FROM [WT_SCL].[dbo].[Product_Data] " + $"WHERE [SN] = '{snInner}' OR [SN]='{snInner}-{snOutter}' AND [Type_Number]='{typeNumber}' AND [Station_Name]='{stationName}'"; return(SQLServer.ExecuteDataSet(selectSQL)); }
public static DataSet SelectTypeNoList() { var selectSQL = $"SELECT {DbTable.F_PRODUCT_PACKAGE_STORAGE.PRODUCT_TYPE_NO} " + $"FROM " + $"{DbTable.F_PRODUCT_PACKAGE_STORAGE_NAME} "; return(SQLServer.ExecuteDataSet(selectSQL)); }
public DataSet GetA10001ColumnByTable_ds(string table_id) { /*table_id 表名 根据表名称获取列的清单*/ DataSet ds = new DataSet(); SQLServer db = new SQLServer(); string sql = "Select * From A10001 Where TABLE_ID= '" + table_id + "' order by line_no asc"; ds = db.ExecuteDataSet(sql, CommandType.Text); return(ds); }
private bool IsExistOutCaseBoxStorage(string out_case_code) { string selectSQL = $"SELECT * FROM {DbTable.F_OUT_CASE_STORAGE_NAME} WHERE {DbTable.F_Out_Case_Storage.OUT_CASE_CODE} = '{out_case_code}'"; DataTable dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(true); } return(false); }
private static List <TestResultBasic> SelectTestResultBasic() { DataTable typeNoDt = SelectTypeNoList().Tables[0]; List <TestResultBasic> testResultsList = new List <TestResultBasic>(); if (typeNoDt.Rows.Count > 0) { for (int i = 0; i < typeNoDt.Rows.Count; i++) { var typeNo = typeNoDt.Rows[i][0].ToString(); DataTable stationList = SelectStationList(typeNo).Tables[0]; if (stationList.Rows.Count > 0) { for (int j = 0; j < stationList.Rows.Count; j++) { var stationName = stationList.Rows[j][1].ToString(); var selectResultSQL = $"SELECT TOP 1 " + $"{DbTable.F_Test_Result.SN}," + $"{DbTable.F_Test_Result.TYPE_NO}," + $"{DbTable.F_Test_Result.STATION_NAME}," + $"{DbTable.F_Test_Result.STATION_IN_DATE}," + $"{DbTable.F_Test_Result.STATION_OUT_DATE}," + $"{DbTable.F_Test_Result.TEST_RESULT}," + $"{DbTable.F_Test_Result.TEAM_LEADER}," + $"{DbTable.F_Test_Result.ADMIN} " + $"FROM " + $"{DbTable.F_TEST_RESULT_NAME} " + $"WHERE " + $"{DbTable.F_Test_Result.STATION_NAME} = '{stationName}' " + $"AND " + $"{DbTable.F_Test_Result.TYPE_NO} = '{typeNo}' " + $"ORDER BY " + $"{DbTable.F_Test_Result.STATION_IN_DATE} DESC"; var dtResult = SQLServer.ExecuteDataSet(selectResultSQL).Tables[0]; TestResultBasic testResultBasic = new TestResultBasic(); if (dtResult.Rows.Count > 0) { testResultBasic.ProductSN = dtResult.Rows[0][0].ToString(); testResultBasic.ProductTypeNo = dtResult.Rows[0][1].ToString(); testResultBasic.StationName = dtResult.Rows[0][2].ToString(); testResultBasic.StationInDate = dtResult.Rows[0][3].ToString(); testResultBasic.StationOutDate = dtResult.Rows[0][4].ToString(); testResultBasic.TestResultValue = dtResult.Rows[0][5].ToString(); testResultBasic.UserTeamLeader = dtResult.Rows[0][6].ToString(); testResultBasic.UserAdmin = dtResult.Rows[0][7].ToString(); testResultsList.Add(testResultBasic); } } } } } return(testResultsList); }
/// <summary> /// 产品型号是否为空 /// </summary> /// <param name="id"></param> /// <returns></returns> private bool IsExistProductType(string typeNo) { string selectSQL = $"SELECT * FROM {DbTable.F_PRODUCT_TYPE_NO_NAME} WHERE {DbTable.F_TypeNo.TYPE_NO} = '{typeNo}'"; DataTable dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(true); } return(false); }
/// <summary> /// 查询当前某工艺的站位记录 /// </summary> /// <returns></returns> public static DataSet SelectStationList(string processName) { string selectSQL = $"SELECT {DbTable.F_TECHNOLOGICAL_PROCESS.STATION_ORDER}," + $"{DbTable.F_TECHNOLOGICAL_PROCESS.STATION_NAME}," + $"{DbTable.F_TECHNOLOGICAL_PROCESS.USER_NAME}," + $"{DbTable.F_TECHNOLOGICAL_PROCESS.UPDATE_DATE} " + $"FROM {DbTable.F_TECHNOLOGICAL_PROCESS_NAME} " + $"WHERE {DbTable.F_TECHNOLOGICAL_PROCESS.PROCESS_NAME} = '{processName}' " + $"ORDER BY {DbTable.F_TECHNOLOGICAL_PROCESS.STATION_ORDER}"; return(SQLServer.ExecuteDataSet(selectSQL)); }
private static string GetProductTypeNo(string pid) { var selectSQL = $"select top 1 {DbTable.F_Test_Result.TYPE_NO} from {DbTable.F_TEST_RESULT_NAME} " + $"where {DbTable.F_Test_Result.SN} like '%{pid}%'"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows[0][0].ToString()); } return(""); }
private static TestReulstDetail SelectTestResultOfSN(string pcbasn, string productsn, string stationName) { TestReulstDetail testResult = new TestReulstDetail(); var selectSQL = $"SELECT TOP 1 " + $"{DbTable.F_Test_Result.STATION_IN_DATE}," + $"{DbTable.F_Test_Result.STATION_OUT_DATE}," + $"{DbTable.F_Test_Result.TEAM_LEADER}," + $"{DbTable.F_Test_Result.TEST_RESULT}," + $"{DbTable.F_Test_Result.TYPE_NO} " + $"FROM " + $"{DbTable.F_TEST_RESULT_NAME} " + $"WHERE " + $"{DbTable.F_Test_Result.SN} = '{pcbasn}' " + $"AND " + $"{DbTable.F_Test_Result.STATION_NAME} = '{stationName}' " + $"ORDER BY {DbTable.F_Test_Result.UPDATE_DATE} DESC"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) {//PCBA查询 testResult.StationInDate = dt.Rows[0][0].ToString(); testResult.StationOutDate = dt.Rows[0][1].ToString(); testResult.UserTeamLeader = dt.Rows[0][2].ToString(); testResult.TestResultValue = dt.Rows[0][3].ToString(); testResult.ProductTypeNo = dt.Rows[0][4].ToString(); } else {//外壳查询 selectSQL = $"SELECT TOP 1 " + $"{DbTable.F_Test_Result.STATION_IN_DATE}," + $"{DbTable.F_Test_Result.STATION_OUT_DATE}," + $"{DbTable.F_Test_Result.TEAM_LEADER}," + $"{DbTable.F_Test_Result.TEST_RESULT}," + $"{DbTable.F_Test_Result.TYPE_NO} " + $"FROM " + $"{DbTable.F_TEST_RESULT_NAME} " + $"WHERE " + $"{DbTable.F_Test_Result.SN} = '{productsn}' " + $"AND " + $"{DbTable.F_Test_Result.STATION_NAME} = '{stationName}' " + $"ORDER BY {DbTable.F_Test_Result.UPDATE_DATE} DESC"; dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { testResult.StationInDate = dt.Rows[0][0].ToString(); testResult.StationOutDate = dt.Rows[0][1].ToString(); testResult.UserTeamLeader = dt.Rows[0][2].ToString(); testResult.TestResultValue = dt.Rows[0][3].ToString(); testResult.ProductTypeNo = dt.Rows[0][4].ToString(); } } return(testResult); }
/// <summary> /// 产线序号是否为空 /// </summary> /// <param name="id"></param> /// <returns></returns> private bool IsExistStation(int id, string station) { string selectSQL = $"SELECT * FROM {DbTable.F_STATION_NAME} WHERE {DbTable.F_Station.STATION_ORDER} = '{id}' AND " + $"{DbTable.F_Station.STATION_NAME} = '{station}'"; DataTable dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(true); } return(false); }
private static bool IsExistMaterialCodePN(string materialCode) { var selectSQL = $"SELECT * FROM {DbTable.F_MATERIAL_NAME} WHERE " + $"{DbTable.F_Material.MATERIAL_CODE} like '%{materialCode}%'"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(true); } return(false); }
private static bool IsPutInStorage(string materialCode) { var selectSQL = $"SELECT {DbTable.F_Material.MATERIAL_STATE} FROM " + $"{DbTable.F_MATERIAL_NAME} WHERE {DbTable.F_Material.MATERIAL_CODE} = '{materialCode}'"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { //查询有记录,已经入过库 return(true); } return(false); }
private static bool IsExistStation(string stationName) { string selectSQL = "SELECT [SN],[Type_Number],[Station_Name],[Test_Result],[CreateDate],[UpdateDate],[Remark] " + "FROM [WT_SCL].[dbo].[Product_Data] " + $"WHERE [Station_Name]='{stationName}'"; DataTable dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(true); } return(false); }
private static string SelectCurrentMaterialState(string materialCode) { var selectSQL = $"SELECT {DbTable.F_Material.MATERIAL_STATE} FROM {DbTable.F_MATERIAL_NAME} WHERE " + $"{DbTable.F_Material.MATERIAL_CODE} = '{materialCode}'"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; LogHelper.Log.Info(selectSQL); if (dt.Rows.Count > 0) { return(dt.Rows[0][0].ToString()); } return(""); }
private bool IsExistPackageProduct(string caseCode, string snOutter) { string selectSQL = $"SELECT * FROM {DbTable.F_OUT_CASE_PRODUCT_NAME} " + $"WHERE {DbTable.F_Out_Case_Product.OUT_CASE_CODE} = '{caseCode}' AND " + $"{DbTable.F_Out_Case_Product.SN_OUTTER} = '{snOutter}'"; DataTable dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(true); } return(false); }
public static string GetProductSNOfShell(string pcbSN) { var selectSQL = $"SELECT {DbTable.F_BINDING_PCBA.SN_OUTTER} FROM {DbTable.F_BINDING_PCBA_NAME} " + $"WHERE {DbTable.F_BINDING_PCBA.SN_OUTTER} = '{pcbSN}' AND " + $"{DbTable.F_BINDING_PCBA.BINDING_STATE} = '1'"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows[0][0].ToString()); } return(""); }
/// <summary> /// PCB与外壳一一对应,可能会出现更新外壳的情况 /// </summary> /// <param name="snPcba"></param> /// <param name="snOutter"></param> /// <returns></returns> private static bool IsExistPCBAShell(string snPcba, string snOutter) { var selectSQL = $"SELECT * FROM {DbTable.F_BINDING_PCBA_NAME} WHERE " + $"{DbTable.F_BINDING_PCBA.SN_PCBA} = '{snPcba}' AND " + $"{DbTable.F_BINDING_PCBA.SN_OUTTER}= '{snOutter}' "; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(true); } return(false); }
private static string SelectShellState(string snOutter) { var selectSQL = $"SELECT top 1 {DbTable.F_BINDING_PCBA.OUTTER_STATE} FROM " + $"{DbTable.F_BINDING_PCBA_NAME} " + $"WHERE " + $"{DbTable.F_BINDING_PCBA.SN_OUTTER} = '{snOutter}'"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows[0][0].ToString()); } return("1"); }
private static string SelectPcba(string snOutter) { var selectSQL = $"SELECT {DbTable.F_BINDING_PCBA.SN_PCBA} FROM {DbTable.F_BINDING_PCBA_NAME} WHERE " + $"{DbTable.F_BINDING_PCBA.SN_OUTTER} = '{snOutter}' " + $"AND " + $"{DbTable.F_BINDING_PCBA.BINDING_STATE} = '1'"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(dt.Rows[0][0].ToString()); } return(""); }
private bool IsExistMaterial(string materialCode) { string selectSQL = $"SELECT * FROM {DbTable.F_MATERIAL_NAME} WHERE {DbTable.F_Material.MATERIAL_CODE} = '{materialCode}'"; DataTable dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(true); } else { return(false); } }
public DataSet SelectOutCaseBoxStorage(string caseCode) { string selectSQL = ""; if (string.IsNullOrEmpty(caseCode)) { selectSQL = $"SELECT * FROM {DbTable.F_OUT_CASE_STORAGE_NAME}"; } else { selectSQL = $"SELECT * FROM {DbTable.F_OUT_CASE_STORAGE_NAME} WHERE {DbTable.F_Out_Case_Storage.OUT_CASE_CODE} = '{caseCode}'"; } return(SQLServer.ExecuteDataSet(selectSQL)); }
private static bool IsExistRecord(string caseCode, string snOutter) { var selectSQL = $"SELECT {DbTable.F_Out_Case_Product.BINDING_STATE} " + $"FROM {DbTable.F_OUT_CASE_PRODUCT_NAME} WHERE " + $"{DbTable.F_Out_Case_Product.OUT_CASE_CODE} = '{caseCode}' AND " + $"{DbTable.F_Out_Case_Product.SN_OUTTER} = '{snOutter}' "; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(true); } return(false);//已解绑/无绑定记录 }
/// <summary> /// 查询所有用户信息 /// </summary> /// <param name="userName"></param> /// <returns></returns> public DataSet GetAllUserInfo() { try { string sqlString = "SELECT * " + "FROM [WT_SCL].[dbo].[f_user] "; return(SQLServer.ExecuteDataSet(sqlString)); } catch { LogHelper.Log.Error("获取所有用户信息异常..."); return(null); } }
private static int SelectLastInsertAmount(string type_no, string stationName, string code) { var selectSQL = $"SELECT {DbTable.F_Material_Statistics.MATERIAL_AMOUNT} " + $"FROM {DbTable.F_MATERIAL_STATISTICS_NAME} WHERE " + $"{DbTable.F_Material_Statistics.STATION_NAME} = '{stationName}' AND " + $"{DbTable.F_Material_Statistics.PRODUCT_TYPE_NO} = '{type_no}' AND " + $"{DbTable.F_Material_Statistics.MATERIAL_CODE} = '{code}'"; var dt = SQLServer.ExecuteDataSet(selectSQL).Tables[0]; if (dt.Rows.Count > 0) { return(int.Parse(dt.Rows[0][0].ToString())); } return(0); }