/// <summary> /// 查询规则 /// </summary> public InterfaceOutPut QueryRule(String Data) { InterfaceOutPut output = new InterfaceOutPut(); output.result = 1; try { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); InQueryRule InParams = javaScriptSerializer.Deserialize <InQueryRule>(Data); OutQueryRule OutParams = new OutQueryRule(); output.data = OutParams; string strSql = "SELECT * from Tab_MealTicket_Rule where strWorkShopGUID = @strWorkShopGUID and iType = @iType"; SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("strWorkShopGUID", InParams.WorkShopGUID), new SqlParameter("iType", InParams.AType) }; DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { MealTicketRule rule = new MealTicketRule(); PS.PSMealTicket.MealTicketRuleFromDB(rule, dt.Rows[i]); OutParams.RuleList.Add(rule); } output.result = 0; } catch (Exception ex) { output.resultStr = ex.Message; LogClass.log("Interface.QueryRule:" + ex.Message); throw ex; } return(output); }
public static void MealTicketRuleFromDB(MealTicketRule Rule, DataRow DR) { Rule.strName = DR["strName"].ToString(); Rule.strGUID = DR["strGUID"].ToString(); Rule.strWorkShopGUID = DR["strWorkShopGUID"].ToString(); Rule.iA = TFParse.DBToInt(DR["iA"], 0); Rule.iB = TFParse.DBToInt(DR["iB"], 0); Rule.iType = TFParse.DBToInt(DR["iType"], 0); }