/// <summary>
/// 增加一条数据
/// </summary>
public int Add(JMP.MDL.jmp_refund model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into jmp_refund(");
strSql.Append("r_money,r_date,r_time,r_static,r_auditor,r_auditortime,r_remark,r_name,r_tel,r_userid,r_appid,r_payid,r_tradeno,r_code,r_price");
strSql.Append(") values (");
strSql.Append("@r_money,@r_date,@r_time,@r_static,@r_auditor,@r_auditortime,@r_remark,@r_name,@r_tel,@r_userid,@r_appid,@r_payid,@r_tradeno,@r_code,@r_price");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@r_money", SqlDbType.Decimal, 9),
new SqlParameter("@r_date", SqlDbType.DateTime),
new SqlParameter("@r_time", SqlDbType.DateTime),
new SqlParameter("@r_static", SqlDbType.Int, 4),
new SqlParameter("@r_auditor", SqlDbType.NVarChar, 50),
new SqlParameter("@r_auditortime", SqlDbType.DateTime),
new SqlParameter("@r_remark", SqlDbType.NVarChar, -1),
new SqlParameter("@r_name", SqlDbType.NVarChar, 50),
new SqlParameter("@r_tel", SqlDbType.NVarChar, 50),
new SqlParameter("@r_userid", SqlDbType.Int, 4),
new SqlParameter("@r_appid", SqlDbType.Int, 4),
new SqlParameter("@r_payid", SqlDbType.Int, 4),
new SqlParameter("@r_tradeno", SqlDbType.NVarChar, -1),
new SqlParameter("@r_code", SqlDbType.NVarChar, -1),
new SqlParameter("@r_price", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.r_money;
parameters[1].Value = model.r_date;
parameters[2].Value = model.r_time;
parameters[3].Value = model.r_static;
parameters[4].Value = model.r_auditor;
parameters[5].Value = model.r_auditortime;
parameters[6].Value = model.r_remark;
parameters[7].Value = model.r_name;
parameters[8].Value = model.r_tel;
parameters[9].Value = model.r_userid;
parameters[10].Value = model.r_appid;
parameters[11].Value = model.r_payid;
parameters[12].Value = model.r_tradeno;
parameters[13].Value = model.r_code;
parameters[14].Value = model.r_price;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(JMP.MDL.jmp_refund model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update jmp_refund set ");
strSql.Append(" r_money = @r_money , ");
strSql.Append(" r_date = @r_date , ");
strSql.Append(" r_time = @r_time , ");
strSql.Append(" r_static = @r_static , ");
strSql.Append(" r_auditor = @r_auditor , ");
strSql.Append(" r_auditortime = @r_auditortime , ");
strSql.Append(" r_remark = @r_remark , ");
strSql.Append(" r_name = @r_name , ");
strSql.Append(" r_tel = @r_tel , ");
strSql.Append(" r_userid = @r_userid , ");
strSql.Append(" r_appid = @r_appid , ");
strSql.Append(" r_payid = @r_payid , ");
strSql.Append(" r_tradeno = @r_tradeno , ");
strSql.Append(" r_code = @r_code , ");
strSql.Append(" r_price = @r_price ");
strSql.Append(" where r_id=@r_id ");
SqlParameter[] parameters =
{
new SqlParameter("@r_id", SqlDbType.Int, 4),
new SqlParameter("@r_money", SqlDbType.Decimal, 9),
new SqlParameter("@r_date", SqlDbType.DateTime),
new SqlParameter("@r_time", SqlDbType.DateTime),
new SqlParameter("@r_static", SqlDbType.Int, 4),
new SqlParameter("@r_auditor", SqlDbType.NVarChar, 50),
new SqlParameter("@r_auditortime", SqlDbType.DateTime),
new SqlParameter("@r_remark", SqlDbType.NVarChar, -1),
new SqlParameter("@r_name", SqlDbType.NVarChar, 50),
new SqlParameter("@r_tel", SqlDbType.NVarChar, 50),
new SqlParameter("@r_userid", SqlDbType.Int, 4),
new SqlParameter("@r_appid", SqlDbType.Int, 4),
new SqlParameter("@r_payid", SqlDbType.Int, 4),
new SqlParameter("@r_tradeno", SqlDbType.NVarChar, -1),
new SqlParameter("@r_code", SqlDbType.NVarChar, -1),
new SqlParameter("@r_price", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.r_id;
parameters[1].Value = model.r_money;
parameters[2].Value = model.r_date;
parameters[3].Value = model.r_time;
parameters[4].Value = model.r_static;
parameters[5].Value = model.r_auditor;
parameters[6].Value = model.r_auditortime;
parameters[7].Value = model.r_remark;
parameters[8].Value = model.r_name;
parameters[9].Value = model.r_tel;
parameters[10].Value = model.r_userid;
parameters[11].Value = model.r_appid;
parameters[12].Value = model.r_payid;
parameters[13].Value = model.r_tradeno;
parameters[14].Value = model.r_code;
parameters[15].Value = model.r_price;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public JMP.MDL.jmp_refund GetModel(int r_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select r_id, r_money, r_date, r_time, r_static, r_auditor, r_auditortime, r_remark, r_name, r_tel, r_userid, r_appid, r_payid, r_tradeno, r_code, r_price ");
strSql.Append(" from jmp_refund ");
strSql.Append(" where r_id=@r_id");
SqlParameter[] parameters =
{
new SqlParameter("@r_id", SqlDbType.Int, 4)
};
parameters[0].Value = r_id;
JMP.MDL.jmp_refund model = new JMP.MDL.jmp_refund();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["r_id"].ToString() != "")
{
model.r_id = int.Parse(ds.Tables[0].Rows[0]["r_id"].ToString());
}
if (ds.Tables[0].Rows[0]["r_money"].ToString() != "")
{
model.r_money = decimal.Parse(ds.Tables[0].Rows[0]["r_money"].ToString());
}
if (ds.Tables[0].Rows[0]["r_date"].ToString() != "")
{
model.r_date = DateTime.Parse(ds.Tables[0].Rows[0]["r_date"].ToString());
}
if (ds.Tables[0].Rows[0]["r_time"].ToString() != "")
{
model.r_time = DateTime.Parse(ds.Tables[0].Rows[0]["r_time"].ToString());
}
if (ds.Tables[0].Rows[0]["r_static"].ToString() != "")
{
model.r_static = int.Parse(ds.Tables[0].Rows[0]["r_static"].ToString());
}
model.r_auditor = ds.Tables[0].Rows[0]["r_auditor"].ToString();
if (ds.Tables[0].Rows[0]["r_auditortime"].ToString() != "")
{
model.r_auditortime = DateTime.Parse(ds.Tables[0].Rows[0]["r_auditortime"].ToString());
}
model.r_remark = ds.Tables[0].Rows[0]["r_remark"].ToString();
model.r_name = ds.Tables[0].Rows[0]["r_name"].ToString();
model.r_tel = ds.Tables[0].Rows[0]["r_tel"].ToString();
if (ds.Tables[0].Rows[0]["r_userid"].ToString() != "")
{
model.r_userid = int.Parse(ds.Tables[0].Rows[0]["r_userid"].ToString());
}
if (ds.Tables[0].Rows[0]["r_appid"].ToString() != "")
{
model.r_appid = int.Parse(ds.Tables[0].Rows[0]["r_appid"].ToString());
}
if (ds.Tables[0].Rows[0]["r_payid"].ToString() != "")
{
model.r_payid = int.Parse(ds.Tables[0].Rows[0]["r_payid"].ToString());
}
model.r_tradeno = ds.Tables[0].Rows[0]["r_tradeno"].ToString();
model.r_code = ds.Tables[0].Rows[0]["r_code"].ToString();
if (ds.Tables[0].Rows[0]["r_price"].ToString() != "")
{
model.r_price = decimal.Parse(ds.Tables[0].Rows[0]["r_price"].ToString());
}
return(model);
}
else
{
return(null);
}
}