天津投入产出系统后端
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 

57 lines
1.6 KiB

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
//Ref:
using System.Data;
using QMAPP.BoraUpgrade.Common;
using QMAPP.BoraUpgrade.Entity;
namespace QMAPP.BoraUpgrade.DAL
{
/// <summary>
/// 注塑条码打码-数据访问类
/// CreateTime:2019.10.18
/// Author :陈冲
/// Mail :22367340@qq.com
/// </summary>
public class PrintCodeRouteDataAccess
{
#region 获取全部打码规则
/// <summary>
/// 获取全部打码规则
/// </summary>
/// <param name="productCode">产品编号</param>
/// <returns></returns>
public static DataTable GetPrintCodeRouteAllList()
{
DataTable returnVal = new DataTable();
string sqlScript = @"Select * From [T_QD_PrintCodeRoute]";
DataSet dataSet = SqlHelper.ExecuteDataset(Config.maindbConnectionString, CommandType.Text,sqlScript);
if ( dataSet.Tables.Count > 0 )
{
returnVal = dataSet.Tables[0];
}
return returnVal;
}
public static DataTable GetExsitProductCodeQty(string productCode,string cellCode)
{
string sql = $"select * from T_AW_Product where ProductCode='{productCode}' and WorkCell_Code='{cellCode}'";
DataSet dataSet = SqlHelper.ExecuteDataset(Config.maindbConnectionString, CommandType.Text, sql);
DataTable dataTable = dataSet.Tables[0];
return dataTable;
}
#endregion
}
}