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