public DataSet GettMatchPlateDtl() { ValidateUser(); QueryObject query1 = GetQueryObject("RF_OldTrayNOGoods"); if (query1 == null) { throw new RFException("查询对象[RF_OldTrayNOGoods]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query1.Sql, paras.Values.ToArray()); ds.Tables[0].TableName = "Master"; QueryObject query2 = GetQueryObject("RF_NewTrayGoods"); if (query2 == null) { throw new RFException("查询对象[RF_NewTrayGoods]不存在"); } DataSet ds2 = Bss_Helper.GetDataSet_SQL(query2.Sql, paras.Values.ToArray()); DataTable dt = ds2.Tables[0]; dt.TableName = "Detail"; ds.Tables.Add(dt.Copy()); return(ds); }
public DataTable QueryStore() { QueryObject query = GetQueryObject("SelPostion1"); if (query == null) { throw new RFException("查询对象[SelPostion1]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
public DataTable GetUserInvTask() { QueryObject query = GetQueryObject("RF_StockSearch"); if (query == null) { throw new RFException("查询对象[RF_StockSearch]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
/// <summary> /// 查询模块列表 /// </summary> /// <returns></returns> public DataTable GetModuleList() { QueryObject query = GetQueryObject("RF_Menu"); if (query == null) { throw new RFException("查询对象[RF_Menu]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
public DataTable QueryGoods() { ValidateUser(); QueryObject query = GetQueryObject("RF_LocationGoods"); if (query == null) { throw new RFException("查询对象[RF_LocationGoods]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
public DataTable QueryCS2AcptQty2() { //ValidateUser(); QueryObject query = GetQueryObject("RF_SelCS2AcptGoods2"); if (query == null) { throw new RFException("查询对象[RF_SelCS2AcptGoods2]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
public DataTable RF_CS2TrayType() { //ValidateUser(); QueryObject query = GetQueryObject("RF_CS2TrayType"); if (query == null) { throw new RFException("查询对象[RF_CS2TrayType]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
public DataTable RFGoodsQuery(string RFGoodsQuery) { ValidateUser(); QueryObject query = GetQueryObject(RFGoodsQuery); if (query == null) { throw new RFException("查询对象[" + RFGoodsQuery + "]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
public DataTable GetPaperInfo() { ValidateUser(); QueryObject query = GetQueryObject("GetStorebyPaperNO"); if (query == null) { throw new RFException("查询对象[GetStorebyPaperNO]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
public DataTable Execute(string StdQueryName) { ValidateUser(); QueryObject query = GetQueryObject(StdQueryName); if (query == null) { throw new RFException("查询对象[" + StdQueryName + "]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
public DataTable ValidatPaperNO() { ValidateUser(); QueryObject query = GetQueryObject("RF_TPShelvesVerify"); if (query == null) { throw new RFException("查询对象[RF_TPShelvesVerify]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); return(ds.Tables[0]); }
public DataTable GetRF_Assignment() { ValidateUser(); QueryObject query = GetQueryObject("RF_Assignment"); if (query == null) { throw new RFException("查询对象[RF_Assignment]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); if (ds != null && ds.Tables.Count > 0) { return(ds.Tables[0]); } else { return(null); } }
public string GetBatchBuildTypeID() { //ValidateUser(); QueryObject query = GetQueryObject("RF_GetBatchBuildType"); if (query == null) { throw new RFException("查询对象[RF_GetBatchBuildType]不存在"); } DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { return(ds.Tables[0].Rows[0][0].ToString()); } else { return("1"); } }
/// <summary> /// 登录验证 /// </summary> /// <param name="user_id"></param> /// <param name="password"></param> /// <param name="user_name"></param> /// <param name="token"></param> /// <returns></returns> public bool Login(string user_id, string password, ref string user_name, ref string token) { SetParameter("UserNO", user_id); //SetParameter("Password", EncryptPwd(password)); SetParameter("Password", password); QueryObject query = GetQueryObject("RF_Login"); if (query == null) { throw new RFException("查询对象[RF_Login]不存在"); } paras.Remove("LocalStoreNO"); DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray()); if (ds.Tables[0].Rows.Count == 0) { return(false); } user_name = ds.Tables[0].Rows[0]["OperName"].ToString(); RFBase.LocalStoreNO = ds.Tables[0].Rows[0]["LocalStoreNO"].ToString(); token = RFService.Instance.UserRegist(user_id); return(true); }