/// <summary> /// 获取威富通配置接口 /// </summary> /// <returns></returns> public string wftpzjk(int tid) { string str = ""; mo = bll.strzf("WFT", tid); if (mo != null) { str = mo.l_str + "," + mo.l_id.ToString(); } return(str); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_interface model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into jmp_interface("); strSql.Append("l_risk,l_daymoney,l_time,l_minimum,l_maximum,l_CostRatio,l_str,l_sort,l_isenable,l_paymenttype_id,l_apptypeid,l_corporatename,l_priority,l_jsonstr"); strSql.Append(") values ("); strSql.Append("@l_risk,@l_daymoney,@l_time,@l_minimum,@l_maximum,@l_CostRatio,@l_str,@l_sort,@l_isenable,@l_paymenttype_id,@l_apptypeid,@l_corporatename,@l_priority,@l_jsonstr"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@l_risk", SqlDbType.Int, 4), new SqlParameter("@l_daymoney", SqlDbType.Decimal, 9), new SqlParameter("@l_time", SqlDbType.DateTime), new SqlParameter("@l_minimum", SqlDbType.Decimal, 9), new SqlParameter("@l_maximum", SqlDbType.Decimal, 9), new SqlParameter("@l_CostRatio", SqlDbType.Decimal, 9), new SqlParameter("@l_str", SqlDbType.NVarChar, -1), new SqlParameter("@l_sort", SqlDbType.Int, 4), new SqlParameter("@l_isenable", SqlDbType.Int, 4), new SqlParameter("@l_paymenttype_id", SqlDbType.Int, 4), new SqlParameter("@l_apptypeid", SqlDbType.NVarChar, -1), new SqlParameter("@l_corporatename", SqlDbType.NVarChar, -1), new SqlParameter("@l_priority", SqlDbType.Int, 4), new SqlParameter("@l_jsonstr", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.l_risk; parameters[1].Value = model.l_daymoney; parameters[2].Value = model.l_time; parameters[3].Value = model.l_minimum; parameters[4].Value = model.l_maximum; parameters[5].Value = model.l_CostRatio; parameters[6].Value = model.l_str; parameters[7].Value = model.l_sort; parameters[8].Value = model.l_isenable; parameters[9].Value = model.l_paymenttype_id; parameters[10].Value = model.l_apptypeid; parameters[11].Value = model.l_corporatename; parameters[12].Value = model.l_priority; parameters[13].Value = model.l_jsonstr; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获取微信配置接口 /// </summary> /// <param name="type"></param> /// <returns></returns> public string wxpzjk(int tid) { string str = ""; mo = bll.strzf("WX", tid); if (mo != null) { str = mo.l_str; } return(str); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_interface model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update jmp_interface set "); strSql.Append(" l_risk = @l_risk , "); strSql.Append(" l_daymoney = @l_daymoney , "); strSql.Append(" l_time = @l_time , "); strSql.Append(" l_minimum = @l_minimum , "); strSql.Append(" l_maximum = @l_maximum , "); strSql.Append(" l_CostRatio = @l_CostRatio , "); strSql.Append(" l_str = @l_str , "); strSql.Append(" l_sort = @l_sort , "); strSql.Append(" l_isenable = @l_isenable , "); strSql.Append(" l_paymenttype_id = @l_paymenttype_id , "); strSql.Append(" l_apptypeid = @l_apptypeid , "); strSql.Append(" l_corporatename = @l_corporatename , "); strSql.Append(" l_priority = @l_priority , "); strSql.Append(" l_jsonstr = @l_jsonstr "); strSql.Append(" where l_id=@l_id "); SqlParameter[] parameters = { new SqlParameter("@l_id", SqlDbType.Int, 4), new SqlParameter("@l_risk", SqlDbType.Int, 4), new SqlParameter("@l_daymoney", SqlDbType.Decimal, 9), new SqlParameter("@l_time", SqlDbType.DateTime), new SqlParameter("@l_minimum", SqlDbType.Decimal, 9), new SqlParameter("@l_maximum", SqlDbType.Decimal, 9), new SqlParameter("@l_CostRatio", SqlDbType.Decimal, 9), new SqlParameter("@l_str", SqlDbType.NVarChar, -1), new SqlParameter("@l_sort", SqlDbType.Int, 4), new SqlParameter("@l_isenable", SqlDbType.Int, 4), new SqlParameter("@l_paymenttype_id", SqlDbType.Int, 4), new SqlParameter("@l_apptypeid", SqlDbType.NVarChar, -1), new SqlParameter("@l_corporatename", SqlDbType.NVarChar, -1), new SqlParameter("@l_priority", SqlDbType.Int, 4), new SqlParameter("@l_jsonstr", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.l_id; parameters[1].Value = model.l_risk; parameters[2].Value = model.l_daymoney; parameters[3].Value = model.l_time; parameters[4].Value = model.l_minimum; parameters[5].Value = model.l_maximum; parameters[6].Value = model.l_CostRatio; parameters[7].Value = model.l_str; parameters[8].Value = model.l_sort; parameters[9].Value = model.l_isenable; parameters[10].Value = model.l_paymenttype_id; parameters[11].Value = model.l_apptypeid; parameters[12].Value = model.l_corporatename; parameters[13].Value = model.l_priority; parameters[14].Value = model.l_jsonstr; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.jmp_interface GetModel(int l_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select l_id, l_risk, l_daymoney, l_time, l_minimum, l_maximum, l_CostRatio, l_str, l_sort, l_isenable, l_paymenttype_id, l_apptypeid, l_corporatename, l_priority, l_jsonstr "); strSql.Append(" from jmp_interface "); strSql.Append(" where l_id=@l_id"); SqlParameter[] parameters = { new SqlParameter("@l_id", SqlDbType.Int, 4) }; parameters[0].Value = l_id; JMP.MDL.jmp_interface model = new JMP.MDL.jmp_interface(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["l_id"].ToString() != "") { model.l_id = int.Parse(ds.Tables[0].Rows[0]["l_id"].ToString()); } if (ds.Tables[0].Rows[0]["l_risk"].ToString() != "") { model.l_risk = int.Parse(ds.Tables[0].Rows[0]["l_risk"].ToString()); } if (ds.Tables[0].Rows[0]["l_daymoney"].ToString() != "") { model.l_daymoney = decimal.Parse(ds.Tables[0].Rows[0]["l_daymoney"].ToString()); } if (ds.Tables[0].Rows[0]["l_time"].ToString() != "") { model.l_time = DateTime.Parse(ds.Tables[0].Rows[0]["l_time"].ToString()); } if (ds.Tables[0].Rows[0]["l_minimum"].ToString() != "") { model.l_minimum = decimal.Parse(ds.Tables[0].Rows[0]["l_minimum"].ToString()); } if (ds.Tables[0].Rows[0]["l_maximum"].ToString() != "") { model.l_maximum = decimal.Parse(ds.Tables[0].Rows[0]["l_maximum"].ToString()); } if (ds.Tables[0].Rows[0]["l_CostRatio"].ToString() != "") { model.l_CostRatio = decimal.Parse(ds.Tables[0].Rows[0]["l_CostRatio"].ToString()); } model.l_str = ds.Tables[0].Rows[0]["l_str"].ToString(); if (ds.Tables[0].Rows[0]["l_sort"].ToString() != "") { model.l_sort = int.Parse(ds.Tables[0].Rows[0]["l_sort"].ToString()); } if (ds.Tables[0].Rows[0]["l_isenable"].ToString() != "") { model.l_isenable = int.Parse(ds.Tables[0].Rows[0]["l_isenable"].ToString()); } if (ds.Tables[0].Rows[0]["l_paymenttype_id"].ToString() != "") { model.l_paymenttype_id = int.Parse(ds.Tables[0].Rows[0]["l_paymenttype_id"].ToString()); } model.l_apptypeid = ds.Tables[0].Rows[0]["l_apptypeid"].ToString(); model.l_corporatename = ds.Tables[0].Rows[0]["l_corporatename"].ToString(); if (ds.Tables[0].Rows[0]["l_priority"].ToString() != "") { model.l_priority = int.Parse(ds.Tables[0].Rows[0]["l_priority"].ToString()); } model.l_jsonstr = ds.Tables[0].Rows[0]["l_jsonstr"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 获得数据列表 /// </summary> public List <JMP.MDL.jmp_interface> DataTableToList(DataTable dt) { List <JMP.MDL.jmp_interface> modelList = new List <JMP.MDL.jmp_interface>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { JMP.MDL.jmp_interface model; for (int n = 0; n < rowsCount; n++) { model = new JMP.MDL.jmp_interface(); if (dt.Rows[n]["l_id"].ToString() != "") { model.l_id = int.Parse(dt.Rows[n]["l_id"].ToString()); } if (dt.Rows[n]["l_risk"].ToString() != "") { model.l_risk = int.Parse(dt.Rows[n]["l_risk"].ToString()); } if (dt.Rows[n]["l_daymoney"].ToString() != "") { model.l_daymoney = decimal.Parse(dt.Rows[n]["l_daymoney"].ToString()); } if (dt.Rows[n]["l_time"].ToString() != "") { model.l_time = DateTime.Parse(dt.Rows[n]["l_time"].ToString()); } if (dt.Rows[n]["l_minimum"].ToString() != "") { model.l_minimum = decimal.Parse(dt.Rows[n]["l_minimum"].ToString()); } if (dt.Rows[n]["l_maximum"].ToString() != "") { model.l_maximum = decimal.Parse(dt.Rows[n]["l_maximum"].ToString()); } if (dt.Rows[n]["l_CostRatio"].ToString() != "") { model.l_CostRatio = decimal.Parse(dt.Rows[n]["l_CostRatio"].ToString()); } model.l_str = dt.Rows[n]["l_str"].ToString(); if (dt.Rows[n]["l_sort"].ToString() != "") { model.l_sort = int.Parse(dt.Rows[n]["l_sort"].ToString()); } if (dt.Rows[n]["l_isenable"].ToString() != "") { model.l_isenable = int.Parse(dt.Rows[n]["l_isenable"].ToString()); } if (dt.Rows[n]["l_paymenttype_id"].ToString() != "") { model.l_paymenttype_id = int.Parse(dt.Rows[n]["l_paymenttype_id"].ToString()); } model.l_apptypeid = dt.Rows[n]["l_apptypeid"].ToString(); model.l_corporatename = dt.Rows[n]["l_corporatename"].ToString(); if (dt.Rows[n]["l_priority"].ToString() != "") { model.l_priority = int.Parse(dt.Rows[n]["l_priority"].ToString()); } model.l_jsonstr = dt.Rows[n]["l_jsonstr"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_interface model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_interface model) { return(dal.Add(model)); }