/// <summary> /// 获得数据List /// </summary> public DrinkInfoArray GetDrinkDataList(DrinkQueryParam QueryCondition) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from VIEW_Drink_query where dtCreateTime >= @dtBeginTime and dtCreateTime <= @dtEndTime "); strSql.Append(GetWhere(QueryCondition)); strSql.Append(" order by dtCreateTime desc"); SqlParameter[] sqlParams = { new SqlParameter("dtBeginTime", QueryCondition.dtBeginTime), new SqlParameter("dtEndTime", QueryCondition.dtEndTime), new SqlParameter("strPlaceID", QueryCondition.PlaceId), new SqlParameter("strAreaGUID", QueryCondition.strJwdId), new SqlParameter("strWorkShopGUID", QueryCondition.WorkShopGUID), new SqlParameter("strTrainmanNumber", QueryCondition.TrainmanNumber), new SqlParameter("nVerifyID", QueryCondition.VerifyID), new SqlParameter("nWorkTypeID", QueryCondition.DrinkTypeID), new SqlParameter("nDrinkResult", QueryCondition.DrinkResultID), new SqlParameter("strTrainmanName", QueryCondition.TrainmanName + "%"), new SqlParameter("nCadreTypeID", QueryCondition.CadreTypeID), new SqlParameter("strDepartmentID", QueryCondition.DepartmentID), }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql.ToString(), sqlParams).Tables[0]; DrinkInfoArray list = new DrinkInfoArray(); foreach (DataRow dr in dt.Rows) { DrinkInfo _Drink_Query = new DrinkInfo(); DrinkDataRowToModel(_Drink_Query, dr); list.Add(_Drink_Query); } return(list); }
public string GetWhere(DrinkQueryParam model) { StringBuilder strSqlOption = new StringBuilder(); strSqlOption.Append(!string.IsNullOrEmpty(model.PlaceId) ? " and strPlaceID = @strPlaceID" : ""); strSqlOption.Append(!string.IsNullOrEmpty(model.strJwdId) ? " and strAreaGUID = @strAreaGUID" : ""); strSqlOption.Append(!string.IsNullOrEmpty(model.WorkShopGUID) ? " and strWorkShopGUID = @strWorkShopGUID" : ""); strSqlOption.Append(!string.IsNullOrEmpty(model.TrainmanNumber) ? " and strTrainmanNumber = @strTrainmanNumber" : ""); strSqlOption.Append(model.VerifyID > -1 ? " and nVerifyID = @nVerifyID" : ""); strSqlOption.Append(model.DrinkTypeID > -1 ? " and nWorkTypeID = @nWorkTypeID" : ""); strSqlOption.Append(model.DrinkResultID > -1 ? " and nDrinkResult = @nDrinkResult" : ""); strSqlOption.Append(!string.IsNullOrEmpty(model.TrainmanName) ? " and strTrainmanName like @strTrainmanName" : ""); strSqlOption.Append(!string.IsNullOrEmpty(model.DepartmentID) ? " and strDepartmentID = @strDepartmentID" : ""); strSqlOption.Append(model.CadreTypeID != "" && model.CadreTypeID != "-1" ? " and nCadreTypeID = @nCadreTypeID" : ""); return(strSqlOption.ToString()); }