public static List <DataObject.SysGroupFunctionRole> GetData(Int32 Id)
{
List <DataObject.SysGroupFunctionRole> lstSysGroupFunctionRole = new List <DataObject.SysGroupFunctionRole>();
String Select = "";
SqlCommand cmd = null;
SqlConnection conn = Common.Connection.SqlConnect();
if (Id > 0)
{
Select = "Select * from SYS_GROUP_FUNCTION_ROLE Where ID = @ID";
cmd = new SqlCommand(Select);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@ID", Id);
}
else
{
Select = "Select * from SYS_GROUP_FUNCTION_ROLE";
cmd = new SqlCommand(Select);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
}
conn.Open();
using (SqlDataReader oReader = cmd.ExecuteReader())
{
while (oReader.Read())
{
DataObject.SysGroupFunctionRole obj = new DataObject.SysGroupFunctionRole();
obj.ID = Int32.Parse(oReader["ID"].ToString());
obj.FUNC_ID = Int32.Parse(oReader["FUNC_ID"].ToString());
obj.ROLE_ID = Int32.Parse(oReader["ROLE_ID"].ToString());
obj.IsCreate = (Boolean)(oReader["IsCreate"]);
obj.IsEdit = (Boolean)(oReader["IsEdit"]);
obj.IsDelete = (Boolean)(oReader["IsDelete"]);
obj.IsView = (Boolean)(oReader["IsView"]);
lstSysGroupFunctionRole.Add(obj);
}
}
conn.Close();
return(lstSysGroupFunctionRole);
}
public static void InsertData(DataObject.SysGroupFunctionRole obj)
{
String Insert = "INSERT INTO SYS_GROUP_FUNCTION_ROLE (FUNC_ID,ROLE_ID,IsCreate,IsEdit,IsDelete,IsView) VALUES ";
Insert += "(@FUNC_ID,@ROLE_ID,@IsCreate,@IsEdit,@IsDelete,@IsView)";
SqlConnection conn = Common.Connection.SqlConnect();
SqlCommand cmd = new SqlCommand(Insert);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@FUNC_ID", obj.FUNC_ID);
cmd.Parameters.AddWithValue("@ROLE_ID", obj.ROLE_ID);
cmd.Parameters.AddWithValue("@IsCreate", obj.IsCreate);
cmd.Parameters.AddWithValue("@IsEdit", obj.IsEdit);
cmd.Parameters.AddWithValue("@IsDelete", obj.IsDelete);
cmd.Parameters.AddWithValue("@IsView", obj.IsView);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public static void UpdateData(DataObject.SysGroupFunctionRole obj)
{
SqlConnection conn = Common.Connection.SqlConnect();
String Update = "UPDATE SYS_GROUP_FUNCTION_ROLE SET FUNC_ID = @FUNC_ID, ROLE_ID = @ROLE_ID,IsCreate = @IsCreate,";
Update += "IsEdit = @IsEdit, IsDelete = @IsDelete, IsView = @IsView Where ID = @ID";
SqlCommand cmd = new SqlCommand(Update);
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@FUNC_ID", obj.FUNC_ID);
cmd.Parameters.AddWithValue("@ROLE_ID", obj.ROLE_ID);
cmd.Parameters.AddWithValue("@IsCreate", obj.IsCreate);
cmd.Parameters.AddWithValue("@IsEdit", obj.IsEdit);
cmd.Parameters.AddWithValue("@IsDelete", obj.IsDelete);
cmd.Parameters.AddWithValue("@IsView", obj.IsView);
cmd.Parameters.AddWithValue("@ID", obj.ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
public void Insert(DataObject.SysGroupFunctionRole obj)
{
Servies.ServiesSysGroupFunctionRole.InsertData(obj);
}
