public static object cDeleteAdo(MODEL.QueryModel obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@id", obj.ID);
string sql = @"
delete from test_system where id = @id
";
return(cSourceData.ExecuteData(sql, cmd));
}
public static object cSelectAdo(MODEL.QueryModel obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@id", obj.ID);
string sql = @"
select ID,isnull(NAME,'') NAME ,isnull(EMAIL,'') EMAIL from test_system where SYSTEM_NAME ='ado'
";
return(cConverter.ConvertDataTable <MODEL.QueryModel>(cSourceData.GetData(sql, cmd).Tables[0]));
}
public static object cInsertAdo(MODEL.QueryModel obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@name", obj.NAME);
cmd.Parameters.AddWithValue("@email", obj.EMAIL);
string sql = @"
insert into test_system(name,email,SYSTEM_NAME)values(@name,@email,'ado')
";
return(cSourceData.ExecuteData(sql, cmd));
}
public static object cUpdateAdo(MODEL.QueryModel obj)
{
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@id", obj.ID);
cmd.Parameters.AddWithValue("@name", obj.NAME);
cmd.Parameters.AddWithValue("@email", obj.EMAIL);
string sql = @"
update test_system
set name = @name,
email = @email ,
SYSTEM_NAME ='ado'
where id=@id
";
return(cSourceData.ExecuteData(sql, cmd));
}
public static object cDeleteAdo(MODEL.QueryModel data)
{
return(DAL.QueryAdoDAL.cDeleteAdo(data));
}
public static object cInsertAdo(MODEL.QueryModel data)
{
return(DAL.QueryAdoDAL.cInsertAdo(data));
}
public static object cDeleteAdo(string data)
{
MODEL.QueryModel obj = cHelper.Deserialize <MODEL.QueryModel>(data);
return(DAL.QueryAdoDAL.cDeleteAdo(obj));
}