public System.Data.DataSet GetMaterialPreparationKpAndStation(string dicstring)
{
string fieldlist = "stationno as 料站,kpnumber as 料号".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring);
return(dp.GetData(table, fieldlist, mst, out count));
}
/// <summary>
/// 获得主代用料
/// </summary>
/// <param name="tmp"></param>
/// <returns></returns>
public System.Data.DataSet GetKpdistinctMaterial(string dicstring)
{
string fieldlist = "*".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring);
return(dp.GetData(table, fieldlist, mst, out count));
}
public System.Data.DataSet Get_T_MATERIAL_PREPARATION(string dicstring)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
string fieldlist = "WOID,PARTNUMBER,USERID,STATIONNO,MASTERID,KPNUMBER,KPDESC,REPLACEGROUP,KPDISTINCT,LOCALTION,RECDATE,BOMVER,SIDE,UNIT,FEEDERTYPE".ToUpper();
int count = 0;
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring);
return(dp.GetData(table, fieldlist, mst, out count));
}
public System.Data.DataSet Get_T_EQC_TOOLS(string TOOSNO)
{
string fieldlist = "TOOLS_TYPE,TOOLS_NO,MAX_AMOUNT,USE_QTY,STATUS,LOC_ID,RECDATE,REMARK";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("TOOLS_NO", TOOSNO);
return(dp.GetData(table, fieldlist, mst, out count));
}
public int GetGetKeyPartsCount(string Kpnumber)
{
string fieldlist = "kpnumber".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("kpnumber".ToUpper(), Kpnumber);
return(dp.GetData("SFCB.B_KEYPART", fieldlist, mst, out count).Tables[0].Rows.Count);
}
public System.Data.DataSet GetGangInfoByTrsn(string trsn)
{
string fieldlist = "trsn,vendercode,kpnumber,storehouseId,locId,case sstatus when 0 then '仓库' when 1 then '线边仓' when 2 then '生产线' when 3 then '已使用' when 6 then '退回仓库'when 7 then '维修' when 8 then '外借' when 9 then '报废' end as sstatus,recdate,datecode,lotId,remark,userId";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("TRSN", trsn);
return(dp.GetData("SFCR.T_PART_STOREHOUSE_HAD", fieldlist.ToUpper(), mst, out count));
}
public System.Data.DataSet QueryTrsn(string trsn)
{
string table = "SFCR.T_PART_STOREHOUSE_HAD";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("TRSN", trsn);
return(dp.GetData(table, "*", mst, out count));
}
/// <summary>
/// 获取空的库位
/// </summary>
/// <param name="storehouseid"></param>
/// <returns></returns>
public System.Data.DataSet GetNotUsedLocId(string storehouseid)
{
string table = "SFCR.T_STOREHOUSE_LOCTION_INFO";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("STOREHOUSEID", storehouseid);
return(dp.GetData(table, "LOCID", mst, out count));
}
public System.Data.DataSet Get_Z_WHS_TRACKING(Dictionary <string, object> mst)
{
string table = "SFCR.Z_WHS_TRACKING";
string fieldlist = "ESN,WOID,PARTNUMBER,PRODUCTNAME,VERSIONCODE,TYPE,LOCSTATION,STATIONNAME,WIPSTATION,NEXTSTATION,USERID,RECDATE,ERRFLAG,SCRAPFLAG,SN,MAC,IMEI,CARTONNUMBER,TRAYNO,PALLETNUMBER,MCARTONNUMBER,MPALLETNUMBER," +
"LINE,SECTIONNAME,ROUTGROUPID,STORENUMBER,WEIGHTQTY,QA_NO,QA_RESULT,TRACK_NO,ATE_STATION_NO,IN_LINE_TIME,BOMNUMBER,REWORKNO,LOTIN,STOREHOUSEID,LOCID,LOTOUT,RECDATE1,STATUS";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, fieldlist, mst, out count));
}
public System.Data.DataSet GettPartBlockedByPartNo(string partno)
{
string fieldlist = "*".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("PART_NO", partno);
return(dp.GetData("SFCR.T_PART_BLOCKED", fieldlist, mst, out count));
}
public System.Data.DataSet PublicMaterialPreparationSelect(string woId)
{
string fieldlist = "stationno,kpnumber".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("WOID", woId);
return(dp.GetData(table, fieldlist, mst, out count));
}
public System.Data.DataSet GetMaxMaintaoindate(string feederid)
{
string fieldlist = "MAX(fixtureenddate) as fixtureenddate".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("fixtureItem", "保养");
mst.Add("fixtureId", feederid);
return(dp.GetData("SFCR.T_FIXTURE_REGIST", fieldlist, mst, out count));
}
/// <summary>
/// 获取工艺，craftId,craftname,craftparamet,beworkseg
/// </summary>
/// <param name="craftId"></param>
/// <returns></returns>
public System.Data.DataSet GetCraftInfoByCraftId(string craftId)
{
string fieldlist = "craftId,craftname,craftparameterurl,beworkseg,checktoolsflag";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary<string, object> mst = new Dictionary<string, object>();
mst.Add("craftId", craftId);
return dp.GetData(table, fieldlist, mst, out count);
}
public System.Data.DataSet Get_Tr_Sn_Detail(string Tr_Sn)
{
string table = "SFCR.R_TR_SN_DETAIL";
string fieldlist = "PO_ID,TR_SN,KP_NO,VENDER_ID,VENDER_NAME,DATE_CODE,LOT_CODE,QTY,STOCK_ID,LOC_ID,TANSFER_NO,URGENT_PN,STOCK_NO,STOCK_DATE,WOID,USER_ID,STATUS,REMARK1,REMARK2,UPDATE_DATE,FIFO_DC ";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("TR_SN", Tr_Sn);
return(dp.GetData(table, fieldlist, mst, out count));
}
/// <summary>
/// 根据料号获取信息
/// </summary>
/// <param name="kpnumber">料号</param>
/// <returns></returns>
public System.Data.DataSet QueryPartMaps(string kpnumber)
{
string table = "SFCR.T_PART_MAPS";
string fieldlist = "kpnumber,selfkpnumber,venderId,vendercode,venderkpnumber,kpdesc,parttype,partgroup,partstate".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("KPNUMBER", kpnumber);
return(dp.GetData(table, fieldlist, mst, out count));
}
/// <summary>
/// 获取用户使用ATE测试的权限
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public DataSet GetUserAteEmp(string userId)
{
string table = "sfcb.b_Ate_Emp".ToUpper();
string fieldlist = "craftId,craftname".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("USERID", userId);
return(dp.GetData(table, fieldlist, mst, out count));
}
/// <summary>
/// 获取指定人员的用户权限列表
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public System.Data.DataSet GetUserJurisdictionByUserId(string userId)
{
string table = "SFCB.B_USER_POPLIST";
string fieldlist = "progid,funId";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("USERID", userId);
return(dp.GetData(table, fieldlist, mst, out count));
}
public DataSet Get_B_MAIL_T(string Mail_App)
{
string table = "MESDB.B_MAIL_T";
string fieldlist = "MAIL_APP,MAIL_TO,MAIL_TO_OTHER,MAIL_CC,MAIL_BCC,MAIL_SUBJECT,MAIL_CONTENT,MAIL_MANAGEMENT,MAIL_DOMAIN_NAME,RECDATE";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("MAIL_APP", Mail_App);
return(dp.GetData(table, fieldlist, mst, out count));
}
public System.Data.DataSet GettSmtKPDetaltForWoByKpnumber(string kpnumber)
{
string table = "SFCR.T_SMT_KP_DETALT_FORWO";
string fieldlist = "woId,kpnumber,stationno,kpdesc,kpdistinct,replacegroup,recdate".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("KPNUMBER", kpnumber);
return(dp.GetData(table, fieldlist, mst, out count));
}
/// <summary>
/// 根据备料表获取是否为最新料表
/// </summary>
/// <param name="MasterId"></param>
/// <returns></returns>
public System.Data.DataSet GetSmtKpMaster(string MasterId)
{
string table = "SFCR.T_SMT_KP_MASTER";
string fieldlist = "masterId,lineId,userId,partnumber,modelname,bomver,pcbside,recdate,reserve1,case reserve2 when '0' then '待审核' when '1' then '审核通过' else '审核失败' end as reserve2";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("MASTERID", MasterId);
return(dp.GetData(table, fieldlist, mst, out count));
}
public System.Data.DataSet GetKpDetalt(string masterId)
{
string table = "SFCR.T_SMT_KP_DETALT";
string fieldlist = "stationno,kpnumber,kpdesc,case kpdistinct when '1' then 'True' else 'False' end as kpdistinct,replacegroup,priorityclass,loction,reserve1,reserve".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("MASTERID", masterId);
return(dp.GetData(table, fieldlist, mst, out count));
}
public System.Data.DataSet Get_WO_SnRule(string woId)
{
string table = "SFCR.T_WO_SN_RULE";
string fieldlist = "WOID,SNTYPE,SNPREFIX,SNPOSTFIX,SNSTART,SNEND,SNLENG,VER,REVE,RECDATE,USENUM";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("WOID", woId);
return(dp.GetData(table, fieldlist, mst, out count));
}
public DataSet GetPalletNnmberInfoForCarton(string woId, string Pallet)
{
string fieldlist = "woid,palletnumber,line,partnumber,packtype,total,closeflag,computer";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("WOID", woId);
mst.Add("PALLETNUMBER", Pallet);
return(dp.GetData("SFCR.T_PALLET_INFO", fieldlist, mst, out count));
}
// 获取当前表中closedflag=1 并且 palletnumber=刷入的号码
public System.Data.DataSet GettPalletInfo(string palletnumber)
{
string fieldlist = "woid, palletnumber, line, partnumber, packtype, total, closeflag, recdate, computer".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("PALLETNUMBER", palletnumber);
mst.Add("CLOSEFLAG", 1);
return(dp.GetData("SFCR.T_PALLET_INFO", fieldlist, mst, out count));
}
public System.Data.DataSet GetMaterialPreByKpnumber_1(string sWoid, string sKpnumber)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
string fieldlist = "woId,partnumber,userId,stationno,stationnum,masterId,kpnumber".ToUpper();
int count = 0;
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("WOID", sWoid);
mst.Add("KPNUMBER", sKpnumber);
return(dp.GetData("sfcr.t_material_preparation_1".ToUpper(), fieldlist, mst, out count));
}
public System.Data.DataSet GetALLB_SnRule_WO()
{
string Fileds = @"WOID,CUST_SN_PREFIX,CUST_SN_POSTFIX,CUST_SN_LENG,CUST_SN_STR,CUST_LAST_SN,CUST_BOX_PREFIX,CUST_BOX_LENG,CUST_BOX_STR,
CUST_LAST_BOX,BOX_LAB_NAME,CUST_CARTON_PREFIX,CUST_CARTON_POSTFIX,CUST_CARTON_LENG,CUST_CARTON_STR,CUST_LAST_CARTON,CARTON_LAB_NAME,CUST_PALLET_PREFIX,
CUST_PALLET_POSTFIX,CUST_PALLET_LENG,CUST_PALLET_STR,CUST_LAST_PALLET,PALLET_LAB_NAME,IN_STATION_TIME,EMP_NO,CUST_END_CARTON";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, Fileds, null, out count));
}
public System.Data.DataSet QueryWoBomInfoData(string WO)
{
string table = "SFCR.T_WO_BOM_INFO";
string fieldlist = "woId,userId,partnumber,kpnumber,kpdesc,qty,process,bomver,recdate".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("WOID", WO);
return(dp.GetData(table, fieldlist, mst, out count));
}
public System.Data.DataSet GetLineInfo(IDictionary <string, object> mst, string Fields)
{
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
if (string.IsNullOrEmpty(Fields))
{
Fields = "LINEID,LINEDESC,STARTIPADDR,ENDIPADDR,WSID,USERID";
}
return(dp.GetData("SFCB.B_LINE_INFO", Fields, mst, out count));
}
/// <summary>
/// 根据成品料号获取该料号在哪些SMT产线上生产
/// </summary>
/// <param name="partnumber">成品料号</param>
/// <returns></returns>
public System.Data.DataSet GetMachineIdAndMasterIdListByPartnumber(string partnumber)
{
string table = "SFCR.T_SMT_KP_MASTER";
string fieldlist = "masterId,lineId".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("PARTNUMBER", partnumber);
return(dp.GetData(table, fieldlist, mst, out count));
}
public System.Data.DataSet QueryAllStationList(string sSEQ, string sMO)
{
string fieldlist = "WOID,PARTNUMBER,USERID,STATIONNO,MASTERID,KPNUMBER,KPDESC,REPLACEGROUP,KPDISTINCT,LOCALTION,RECDATE,BOMVER,SIDE,UNIT,FEEDERTYPE".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("MASTERID", sSEQ);
mst.Add("WOID", sMO);
return(dp.GetData(table, fieldlist, mst, out count));
}
