public int Update(Model.BM_COMMON t,Trans trans)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetStoredProcCommand("p_BM_COMMON_update");
db.AddInParameter(cmd, "@bg_id", DbType.Int32, t.bg_id);
db.AddInParameter(cmd, "@bg_lx", DbType.String, t.bg_lx);
db.AddInParameter(cmd, "@bg_lxmc", DbType.String, t.bg_lxmc);
db.AddInParameter(cmd, "@bg_bm", DbType.String, t.bg_bm);
db.AddInParameter(cmd, "@bg_mc", DbType.String, t.bg_mc);
db.AddInParameter(cmd, "@bg_pysx", DbType.String, t.bg_pysx);
db.AddInParameter(cmd, "@bg_xh", DbType.Int32, t.bg_xh);
db.AddInParameter(cmd, "@bg_bz", DbType.String, t.bg_bz);
return db.ExecuteNonQuery(cmd,trans);
}
public int Update(Role Role)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetStoredProcCommand("p_Role_update");
db.AddInParameter(cmd, "@Role_Code", DbType.Guid, Role.Role_Code);
db.AddInParameter(cmd, "@Role_Name", DbType.String, Role.Role_Name);
db.AddInParameter(cmd, "@DES", DbType.String, Role.DES);
return db.ExecuteNonQuery(cmd);
}
public int Save(Model.BM_COMMON t,Trans trans)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetStoredProcCommand("p_BM_COMMON_insert");//返回主键
db.AddInParameter(cmd, "@bg_lx", DbType.String, t.bg_lx);
db.AddInParameter(cmd, "@bg_lxmc", DbType.String, t.bg_lxmc);
db.AddInParameter(cmd, "@bg_bm", DbType.String, t.bg_bm);
db.AddInParameter(cmd, "@bg_mc", DbType.String, t.bg_mc);
db.AddInParameter(cmd, "@bg_pysx", DbType.String, t.bg_pysx);
db.AddInParameter(cmd, "@bg_xh", DbType.Int32, t.bg_xh);
db.AddInParameter(cmd, "@bg_bz", DbType.String, t.bg_bz);
object res = db.ExecuteScalar(cmd,trans);
return res == null ? -1 : Convert.ToInt32(res);
}
public int Save(Role Role)
{
DBHelper db = new DBHelper();
DbCommand cmd = db.GetStoredProcCommand("p_Role_insert");//返回主键
db.AddInParameter(cmd, "@Role_Name", DbType.String, Role.Role_Name);
db.AddInParameter(cmd, "@DES", DbType.String, Role.DES);
object res = db.ExecuteScalar(cmd);
return res == null ? -1 :1;
}
