/// <summary>
/// 获得账户信息
/// </summary>
/// <param name="userAcount"></param>
/// <returns></returns>
public List <User> GetUserForAcount(object userAcount)
{
using (StoreAccess access = new StoreAccess())
{
string strSQL = access.CommandFormate("SELECT [Name],[Remark],[Access] FROM [Table_User] WHERE Id = {0}Id");
return(access.ExcuteSelect <User>(strSQL, parameter =>
{
parameter.Add(parameter.CreateParameter("Id", Convert.ToInt32(userAcount)));
}));
}
}
/// <summary>
/// 通过物料编码获取相关信息
/// </summary>
/// <param name="materialNumber">物料编码</param>
/// <param name="code">到货编号</param>
/// <returns></returns>
public List <InvoiceVerify> GetMaterialMaeeage(string materialNumber, string code)
{
using (StoreAccess access = new StoreAccess())
{
string strSQL = access.CommandFormate("SELECT * FROM [Table_InvoiceVerify] WHERE [InvoiceNumber] = {0}InvoiceNumber AND [MaterialNumber] = {0}MaterialNumber");
return(access.ExcuteSelect <InvoiceVerify>(strSQL, parmater =>
{
parmater.Add(parmater.CreateParameter("InvoiceNumber", code));
parmater.Add(parmater.CreateParameter("MaterialNumber", materialNumber));
}));
}
}