public DataSet GetPalletInfo(IDictionary <string, object> mst)
{
string fieldlist = "woid,palletnumber,line,partnumber,packtype,total,closeflag,computer".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, fieldlist, mst, out count));
}
public DataSet GetSystemInputData() //查询出系统所需要的参数
{
string fieldlist = "worktypename,code,param";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData("SFCB.B_WORK_TYPE_NAME", fieldlist, null, out count));
}
/// <summary>
/// 删除部门
/// </summary>
/// <param name="deptname"></param>
public void DeleteDeptInfo(string deptname)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("deptname", deptname);
dp.DeleteData(table, mst);
}
// 获取用户信息表的所有记录
public System.Data.DataSet GettCustomerAll()
{
string fieldlist = "customerId, customername, address, contactperson, phone, city";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, fieldlist, null, out count));
}
public void DeleteKeyParts(string kpnumber)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("kpnumber", kpnumber);
dp.DeleteData("SFCB.B_KEYPART", mst);
}
/// <summary>
/// 删除工厂信息
/// </summary>
/// <param name="facId"></param>
public void DeleteFacInfo(string facId)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("FACID", facId);
dp.DeleteData(table, mst);
}
public void DeleteBomNumber(string Bom)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("bomnumber", Bom);
dp.DeleteData(table, mst);
}
public DataSet GetFacCodeList()
{
string fieldlist = "distinct facCode".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, fieldlist, null, out count));
}
/// <summary>
/// 删除机器/工站信息
/// </summary>
/// <param name="machineId"></param>
public void DeleteMachineInfo(string machineId)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("MACHINEID", machineId);
dp.DeleteData(table, mst);
}
public void UpdateSupplyMaterialStatus(string dicskm)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicskm);
mst.Add("supplytime".ToUpper(), System.DateTime.Now);
dp.UpdateData("sfcr.t_smt_kp_monnitor", new string[] { "ROWID" }, mst);
}
public void InserWoBomData(string dicstring)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(dicstring);
mst.Add("RECDATE", System.DateTime.Now);
dp.AddData("SFCR.T_WO_BOM_INFO", mst);
}
public byte[] GetData(string TableName, string DicString, string fieldlist)
{
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = MapListConverter.JsonToDictionary(DicString);
return(GetDataSetSurrogateZipBytes(dp.GetData(TableName, fieldlist, mst, out count)));
}
public System.Data.DataSet QueryPartBlocked()
{
string fieldlist = "part_no as 料号,date_code as 生产周期,vender_code as 厂商代码,Lot_id as 生产批次,check_type as 检查类型,Used_flag as 是否检查,In_station_time as 进入系统时间,emp_no as 工号".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData("SFCR.T_PART_BLOCKED", fieldlist, null, out count));
}
public void DeleteErrorCode(string ERRORCODE)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("ERRORCODE", ERRORCODE);
dp.DeleteData(table, mst);
}
public void InsertErrorCode(string dicstring)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> dic = MapListConverter.JsonToDictionary(dicstring);
dic.Add("RECDATE", DateTime.Now);
dp.AddData(table, dic);
}
/// <summary>
/// 删除线体
/// </summary>
/// <param name="lineId"></param>
public void DeleteLineInfo(string lineId)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("LINEID", lineId);
dp.DeleteData("SFCB.B_LINE_INFO", mst);
}
/// <summary>
/// 获取所有的工厂信息
/// </summary>
/// <returns>facId,facname,address</returns>
public System.Data.DataSet GetFacInfo()
{
string fieldlist = "facId,facname,address ,facCode".ToUpper();
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, fieldlist, null, out count));
}
/// <summary>
/// 根据工艺Id获取对应的工艺项目
/// </summary>
/// <param name="craftId"></param>
/// <returns></returns>
public System.Data.DataSet GetCraftItemByCraftId(string craftId)
{
string fieldlist = "craftId,craftItem,craftparameterdes,upperlimit,lowerlimit,other";
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("SFCB.B_CRAFT_ITEM", fieldlist, mst, out count);
}
public void UPDATE_WIPSTATION(string STOCK_NO, string WIP_STATION)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("STORENUMBER", STOCK_NO);
mst.Add("WIPSTATION", string.IsNullOrEmpty(WIP_STATION) ? "1003" : WIP_STATION);
dp.UpdateData("sfcr.t_wip_tracking_online", new string[] { "STORENUMBER" }, mst);
}
public System.Data.DataSet GettSmtKPDetaltForWo()
{
string table = "SFCR.T_SMT_KP_DETALT_FORWO";
string fieldlist = "woId,kpnumber,stationno,kpdesc,kpdistinct,replacegroup,recdate";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, fieldlist, null, out count));
}
public void UpdateSmtkPMonnitorCdata(string rowid, string cdata)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
Dictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("ROWID", rowid);
mst.Add("CDATA", cdata);
dp.UpdateData("sfcr.t_smt_kp_monnitor", new string[] { "ROWID" }, mst);
}
public DataSet GetReworkInfo(string ReworkNo)
{
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("REWORKNO", ReworkNo);
return(dp.GetData("SFCR.T_REWORK_DETAIL_INFO", "REWORKNO,WORKDATE,USERID,PARTNUMBER,WOID,TOTALQTY,MEMO,REWORKDESC,REWORKDATE", mst, out count));
}
/// <summary>
/// 获取所有的用户信息
/// </summary>
/// <returns></returns>
public System.Data.DataSet GetUserInfo()
{
string table = "SFCB.B_USER_INFO";
string fieldlist = "userId as 工号,username as 用户名,rolecaption as 角色名称,deptname as 部门名称,facId as 工厂编号,pwd as 密码,userphone as 联系电话,useremail as 电子邮箱,userstatus as 用户状态";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, fieldlist, null, out count));
}
public void DeleteSmtKPDetalt(string KpMaster)
{
string table = "SFCR.T_SMT_KP_DETALT";
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("MASTERID", KpMaster);
dp.DeleteData(table, mst);
}
public System.Data.DataSet Get_Z_WHS_TRACKING(Dictionary <string, object> mst, string Fields)
{
string table = "SFCR.Z_WHS_TRACKING";
string fieldlist = Fields;
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, fieldlist, mst, out count));
}
public void EditSmtKpMonitorFlag(string kpmonitorId, int cdata)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("CDATA", cdata);
mst.Add("ROWID", kpmonitorId);
dp.UpdateData("SFCR.T_SMT_KP_MONNITOR", new string[] { "ROWID" }, mst);
}
public void InsertFixtureType(string typeid, string typename)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("typeId", typeid);
dic.Add("typename", typename);
dp.AddData("SFCR.T_FIXTURE_TYPE", dic);
}
/// <summary>
/// 获取所有的料站表头
/// </summary>
/// <returns></returns>
public System.Data.DataSet GetAllMasterid()
{
string table = "SFCR.T_SMT_KP_MASTER";
string fieldlist = "masterId";
int count = 0;
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
return(dp.GetData(table, fieldlist, null, out count));
}
public AdminService(IAdminProvider adminProvider)
{
if (adminProvider == null)
{
throw new ArgumentNullException(nameof(adminProvider));
}
_adminProvider = adminProvider;
}
public void UpdateMaintaindate(string fixtureid, string fixturemaintaindate)
{
IAdminProvider dp = (IAdminProvider)DpFactory.Create(typeof(IAdminProvider), DpFactory.ADMIN);
IDictionary <string, object> mst = new Dictionary <string, object>();
mst.Add("fixturemaintaindate", fixturemaintaindate);
mst.Add("fixtureId", fixtureid);
dp.UpdateData("SFCR.T_FIXTURE_INFO", new string[] { "fixtureId" }, mst);
}
public AdminApiController(IAdminProvider adminProvider)
{
AdminProvider = adminProvider;
}