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