Beispiel #1
0
 /// <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)));
         }));
     }
 }
Beispiel #2
0
 /// <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));
         }));
     }
 }