コード例 #1
0
        public string GetProStoreSummary()
        {
            try
            {
                var cmd = new SqlCommand("Usp_GetStoreSummary")
                {
                    CommandType = CommandType.StoredProcedure
                };
                var mfun    = new MFunction();
                var dResult = mfun.GetSqlTableWithUsing(cmd);
                if (dResult == null || dResult.Rows.Count < 1)
                {
                    return("今日无入库");
                }

                var cResult = "";
                for (var i = 0; i < dResult.Rows.Count; i++)
                {
                    cResult = cResult + dResult.Rows[i]["cUser"] + "入库:" + dResult.Rows[i]["CNT"] + " ; ";
                }

                return(cResult);
            }
            catch (Exception ex)
            {
                return(ex.Message);
            }
        }
コード例 #2
0
 public string AddProStore(string cBarCode, string fromUserName)
 {
     try
     {
         var cmd = new SqlCommand("AddProStore")
         {
             CommandType = CommandType.StoredProcedure
         };
         cmd.Parameters.AddWithValue("@cBarCode", cBarCode);
         cmd.Parameters.AddWithValue("@fromUserName", fromUserName);
         var mfun    = new MFunction();
         var dResult = mfun.GetSqlTableWithUsing(cmd);
         return(dResult.Rows[0]["Msg"].ToString());
     }
     catch (Exception ex)
     {
         return(ex.Message);
     }
 }