public string GetWhere(Query_In model)
{
StringBuilder builder = new StringBuilder();
if (!string.IsNullOrEmpty(model.WorkShopGUID))
{
builder.AppendFormat(" and strWorkShopGUID =@strWorkShopGUID");
}
if (!string.IsNullOrEmpty(model.TrainmanNumber))
{
builder.AppendFormat(" and strTrainmanNumber =@strTrainmanNumber");
}
if (model.VerifyID > -1)
{
builder.AppendFormat(" and nVerifyID =@nVerifyID");
}
if (model.DrinkTypeID > -1)
{
builder.AppendFormat(" and nWorkTypeID =@nWorkTypeID");
}
if (model.DrinkResultID > -1)
{
builder.AppendFormat(" and nDrinkResult =@nDrinkResult");
}
if (!string.IsNullOrEmpty(model.TrainmanName))
{
builder.AppendFormat(" and strTrainmanName like @strTrainmanName");
}
return(builder.ToString());
}
public Query_Out QueryDrink(string input)
{
Query_Out json = new Query_Out();
json.data = new List <RRsDrink>();
RRsDrink drink = null;
Query_In model = null;
try
{
model = Newtonsoft.Json.JsonConvert.DeserializeObject <Query_In>(input);
string strSql = "select * from VIEW_Drink_Query where dtCreateTime >= @dtBeginTime and dtCreateTime <=@dtEndTime ";
strSql += GetWhere(model);
strSql += " order by dtCreateTime desc";
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("dtBeginTime", model.dtBeginTime),
new SqlParameter("dtEndTime", model.dtEndTime),
new SqlParameter("strWorkShopGUID", model.WorkShopGUID),
new SqlParameter("strTrainmanNumber", model.TrainmanNumber),
new SqlParameter("nVerifyID", model.VerifyID),
new SqlParameter("nWorkTypeID", model.DrinkTypeID),
new SqlParameter("nDrinkResult", model.DrinkResultID),
new SqlParameter("strTrainmanName", model.TrainmanName),
};
DataTable table =
SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParameters).Tables[0];
DateTime dtCreateTime;
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
drink = GetSingleDrinkInfo(row);
json.data.Add(drink);
}
json.result = "0";
json.resultStr = "获取测酒记录成功";
}
else
{
json.result = "1";
json.resultStr = "获取测酒记录失败";
}
}
catch (Exception ex)
{
TF.CommonUtility.LogClass.logex(ex, "");
throw ex;
}
return(json);
}
