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