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(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; }
public int Update(UserInfo t) { DBHelper db = new DBHelper(); DbCommand cmd = db.GetStoredProcCommand("p_UserInfo_Update"); db.AddInParameter(cmd, "@UserID", DbType.String, t.UserID); db.AddInParameter(cmd, "@Link_Tel", DbType.String, t.Link_Tel); db.AddInParameter(cmd, "@Mob_Tel", DbType.String, t.Mob_Tel); db.AddInParameter(cmd, "@LoginID", DbType.String, t.LoginID); db.AddInParameter(cmd, "@Password", DbType.String, t.Password); db.AddInParameter(cmd, "@UserName", DbType.String, t.UserName); db.AddInParameter(cmd, "@Spell_Index", DbType.String, t.Spell_Index); db.AddInParameter(cmd, "@Sex", DbType.String, t.Sex); db.AddInParameter(cmd, "@IdentityCard", DbType.String, t.IdentityCard); db.AddInParameter(cmd, "@Birthday", DbType.String, t.Birthday); db.AddInParameter(cmd, "@EMail", DbType.String, t.EMail); db.AddInParameter(cmd, "@Addr", DbType.String, t.Addr); db.AddInParameter(cmd, "@State", DbType.String, t.State); return db.ExecuteNonQuery(cmd); }