public void InsUserGroupManagerForm(UserGroupManagerVO user) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(ConnectionString); cmd.CommandText = @"insert into UserGroup_Master (UserGroup_Code,UserGroup_Name,Admin,Use_YN,Ins_Date) values (@UserGroup_Code,@UserGroup_Name,'N',@Use_YN,GETDATE())"; cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@UserGroup_Code", user.UserGroup_Code); cmd.Parameters.AddWithValue("@UserGroup_Name", user.UserGroup_Name); cmd.Parameters.AddWithValue("@Use_YN", user.Use_YN); cmd.Connection.Open(); cmd.ExecuteScalar(); cmd.Connection.Close(); } }
public void UpdateUserGroupManagerForm(UserGroupManagerVO user) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = new SqlConnection(ConnectionString); cmd.CommandText = @"update UserGroup_Master set UserGroup_Name = @UserGroup_Name, Use_YN = @Use_YN where UserGroup_Code = @UserGroup_Code"; cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@UserGroup_Code", user.UserGroup_Code); cmd.Parameters.AddWithValue("@UserGroup_Name", user.UserGroup_Name); cmd.Parameters.AddWithValue("@Use_YN", user.Use_YN); cmd.Connection.Open(); cmd.ExecuteScalar(); cmd.Connection.Close(); } }
public void UpdateUserGroupManagerForm(UserGroupManagerVO user) { UserDAC dac = new UserDAC(); dac.UpdateUserGroupManagerForm(user); }
public void InsUserGroupManagerForm(UserGroupManagerVO user) { UserDAC dac = new UserDAC(); dac.InsUserGroupManagerForm(user); }