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