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