public FeedbackInfomation QueryStocktakingBillInfos(StocktakingQuery sq) { FeedbackInfomation fi = new FeedbackInfomation(); try { DataSet ds = MySMDAL.SelectStocktakingBillsInfo(sq); if (DataValidate.CheckDataSetNotEmpty(ds)) { fi.Result = ds; fi.FeedbackMessage = ""; fi.ErrorStatus = STATUS_ADAPTER.QUERY_NORMAL; } else { fi.Result = null; fi.FeedbackMessage = Tips.QERUY_RESULT_EMPTY; fi.ErrorStatus = STATUS_ADAPTER.QUERY_NODATA; } return(fi); } catch (Exception ex) { fi.Result = null; fi.FeedbackMessage = Tips.QUERY_FAILED + ":" + ex.Message.ToString(); fi.ErrorStatus = STATUS_ADAPTER.QUERY_ERROR; return(fi); } }
public DataSet SelectStocktakingBillsInfo(StocktakingQuery sq) { StringBuilder sqlsb = new StringBuilder($" select * from StocktakingView where CmstID = {sq.CmstID} "); if (sq.CompanyID > 0) { sqlsb.Append($" and CompanyID = {sq.CompanyID} "); } if (sq.DepotID > 0) { sqlsb.Append($" and DepotID = {sq.DepotID} "); } if (sq.ReservoirID > 0) { sqlsb.Append($" and ReservoirID = {sq.ReservoirID} "); } sqlsb.Append($" and MakeTime >= '{sq.StartTime.ToString("yyyy-MM-dd HH:mm:ss")}' and MakeTime <= '{sq.EndTime.ToString("yyyy-MM-dd HH:mm:ss")}' "); DataSet ds = SqlDataHelper.ExecuteDataSet(SqlDataHelper.GetConnection(), CommandType.Text, sqlsb.ToString()); return(ds); }
public string QueryStocktakingBillInfos(StocktakingQuery sq) { return(JsonConvert.SerializeObject(MySMBLL.QueryStocktakingBillInfos(sq))); }