public int Add(Roles roles)
{
string sql = "insert into Roles(Roles_Id,Roles_Title,Roles_DeleteId,Roles_CreateTime,Roles_UpdateTime) " +
"values(@Roles_Id,@Roles_Title,@Roles_DeleteId,@Roles_CreateTime,@Roles_UpdateTime)";
return(SqlHelper <Roles> .ExceuteNonQuery(sql, roles));
}
public int Add(Intro Intro)
{
string sql = "insert into Intro(Intro_Id,Intro_Image,Intro_Content,Intro_DeleteId,Intro_CreateTime,Intro_UpdateTime) " +
"values(@Intro_Id,@Intro_Image,@Intro_Content,@Intro_DeleteId,@Intro_CreateTime,@Intro_UpdateTime)";
return(SqlHelper <Intro> .ExceuteNonQuery(sql, Intro));
}
public int Add(Order Order)
{
string sql = "insert into Order(Order_Id,Order_Name,Order_Phone,Order_Email,Order_Site,Order_relevan,Order_DeleteId,Order_CreateTime,Order_UpdateTime)"
+ " values(@Order_Id,@Order_Name,@Order_Phone,@Order_Email,@Order_Site,@Order_relevan,@Order_DeleteId,@Order_CreateTime,@Order_UpdateTime)";
return(SqlHelper <Order> .ExceuteNonQuery(sql, Order));
}
public int Add(SystemMenus model)
{
string sql = "insert into SystemMenus(SystemMenus_Id,SystemMenus_Title,SystemMenus_Link,SystemMenus_Icon,SystemMenus_DeleteId,SystemMenus_ParentId,SystemMenus_CreateTime,SystemMenus_UpdateTime) "
+ "values(@SystemMenus_Id,@SystemMenus_Title,@SystemMenus_Link,@SystemMenus_Icon,@SystemMenus_DeleteId,@SystemMenus_ParentId,@SystemMenus_CreateTime,@SystemMenus_UpdateTime)";
return(SqlHelper <SystemMenus> .ExceuteNonQuery(sql, model));
}
public int Add(Product product)
{
string sql = "insert into Product(Product_Id,Product_Title,Product_Image,Product_Intro,Product_Content,Product_Price,Product_DeleteId,Product_CreateTime,Product_UpdateTime) " +
"values(@Product_Id,@Product_Title,@Product_Image,@Product_Intro,@Product_Content,@Product_Price,@Product_DeleteId,@Product_CreateTime,@Product_UpdateTime)";
return(SqlHelper <Product> .ExceuteNonQuery(sql, product));
}
public int Edit(Contact model)
{
string sql =
"update Contact set Contact_Address=@Contact_Address,Contact_QQ1=@Contact_QQ1,Contact_QQ2=@Contact_QQ2,Contact_Wechat=@Contact_Wechat,Contact_Weibo=@Contact_Weibo,Contact_Phone=@Contact_Phone,Contact_Worktime=@Contact_Worktime,Contact_QRCode=@Contact_QRCode,Contact_UpdateTime=@Contact_UpdateTime,Contact_Fax = @Contact_Fax,Contact_Email = @Contact_Email where Contact_Id=@Contact_Id";
return(SqlHelper <Contact> .ExceuteNonQuery(sql, model));
}
public int Add(Culture Culture)
{
string sql = "insert into Culture(Culture_Id,Culture_Intro,Culture_Title1 ,Culture_Content1,Culture_Title2 ,Culture_Content2,Culture_Title3 ,Culture_Content3,Culture_Title4 ,Culture_Content4,Culture_Title5 ,Culture_Content5,Culture_DeleteId,Culture_CreateTime,Culture_UpdateTime) " +
"values(@Culture_Id,@Culture_Intro,@Culture_Title1 ,@Culture_Content1,@Culture_Title2 ,@Culture_Content2,@Culture_Title3 ,@Culture_Content3,@Culture_Title4 ,@Culture_Content4,@Culture_Title5 ,@Culture_Content5,@Culture_DeleteId,@Culture_CreateTime,@Culture_UpdateTime)";
return(SqlHelper <Culture> .ExceuteNonQuery(sql, Culture));
}
public int Add(Contact Contact)
{
string sql = "insert into Contact(Contact_Id, Contact_Title1 , Contact_Phone, Contact_Fax , Contact_Email , Contact_Title2 , Contact_Site , Contact_Image1 ,Contact_Image2 , Contact_Image3 ,Contact_DeleteId,Contact_CreateTime,Contact_UpdateTime) " +
"values(@Contact_Id,@Contact_Title1, @Contact_Phone ,@Contact_Fax, @Contact_Email , @Contact_Title2 , @Contact_Site ,@Contact_Image1 ,@Contact_Image2 , @Contact_Image3 , @Contact_DeleteId ,@Contact_CreateTime,@Contact_UpdateTime)";
return(SqlHelper <Contact> .ExceuteNonQuery(sql, Contact));
}
public int Add(Get Get)
{
string sql = "insert into Get(Get_Id,Get_Image,Get_Site1,Get_Phone1,Get_Site2,Get_Phone2,Get_Site3,Get_Phone3,Get_ProductId,Get_DeleteId,Get_CreateTime,Get_UpdateTime)"
+ " values(@Get_Id,@Get_Image,@Get_Site1,@Get_Phone1,@Get_Site2,@Get_Phone2,@Get_Site3,@Get_Phone3,@Get_ProductId,@Get_DeleteId,@Get_CreateTime,@Get_UpdateTime)";
return(SqlHelper <Get> .ExceuteNonQuery(sql, Get));
}
public int Add(Book Book)
{
string sql = "insert into Book(Book_Id,Book_Title,Book_Content,Book_Image ,Book_Price,Book_publish,Book_Author,Book_Intro,Book_Catalog ,Book_Read ,Book_DeleteId,Book_CreateTime,Book_UpdateTime) " +
"values(@Book_Id,@Book_Title,@Book_Content,@Book_Image ,@Book_Price,@Book_publish,@Book_Author,@Book_Intro,@Book_Catalog ,@Book_Read ,@Book_DeleteId,@Book_CreateTime,@Book_UpdateTime)";
return(SqlHelper <Book> .ExceuteNonQuery(sql, Book));
}
public int Add(Send Send)
{
string sql = "insert into Send(Send_Id,Send_Image,Send_Content,Send_DeleteId,Send_CreateTime,Send_UpdateTime) " +
"values(@Send_Id,@Send_Image,@Send_Content,@Send_DeleteId,@Send_CreateTime,@Send_UpdateTime)";
return(SqlHelper <Send> .ExceuteNonQuery(sql, Send));
}
public int Add(News News)
{
string sql = "insert into News(News_Id,News_Title,News_Image,News_Intro,News_Content,News_DeleteId,News_CreateTime,News_UpdateTime) " +
"values(@News_Id,@News_Title,@News_Image,@News_Intro,@News_Content,@News_DeleteId,@News_CreateTime,@News_UpdateTime)";
return(SqlHelper <News> .ExceuteNonQuery(sql, News));
}
public int Add(Map Map)
{
string sql = "insert into Map(Map_Id,Map_Site,Map_Phone,Map_DeleteId,Map_CreateTime,Map_UpdateTime) " +
"values(@Map_Id,@Map_Site,@Map_Phone,@Map_DeleteId,@Map_CreateTime,@Map_UpdateTime)";
return(SqlHelper <Map> .ExceuteNonQuery(sql, Map));
}
public int Add(Video Video)
{
string sql = "insert into Video(Video_Id,Video_Title,Video_Intro,Video_Path,Video_Image,Video_DeleteId,Video_CreateTime,Video_UpdateTime) " +
"values(@Video_Id,@Video_Title,@Video_Intro,@Video_Path,@Video_Image,@Video_DeleteId,@Video_CreateTime,@Video_UpdateTime)";
return(SqlHelper <Video> .ExceuteNonQuery(sql, Video));
}
public int Add(Users users)
{
string sql = "insert into Users(Users_Id,Users_Account,Users_Password,Users_NickName,Users_Photo,Users_RolesId,Users_DeleteId,Users_CreateTime,Users_UpdateTime)"
+ " values(@Users_Id,@Users_Account,@Users_Password,@Users_NickName,@Users_Photo,@Users_RolesId,@Users_DeleteId,@Users_CreateTime,@Users_UpdateTime)";
return(SqlHelper <Users> .ExceuteNonQuery(sql, users));
}
public int Add(Team Team)
{
string sql = "insert into Team(Team_Id,Team_Title,Team_Image,Team_Content,Team_DeleteId,Team_CreateTime,Team_UpdateTime) " +
"values(@Team_Id,@Team_Title,@Team_Image,@Team_Content,@Team_DeleteId,@Team_CreateTime,@Team_UpdateTime)";
return(SqlHelper <Team> .ExceuteNonQuery(sql, Team));
}
public int Edit(Product model)
{
string sql =
"update Product set LoanType_Id=@LoanType_Id,Product_Detail=@Product_Detail,Product_UpdateTime=@Product_UpdateTime whereProduct_Id = @Product_Id ";
return(SqlHelper <Product> .ExceuteNonQuery(sql, model));
}
public int Add(WebMenus model)
{
string sql = "insert into WebMenus(WebMenus_Id,WebMenus_Title,WebMenus_Link,WebMenus_Icon,WebMenus_DeleteId,WebMenus_ParentId,WebMenus_CreateTime,WebMenus_UpdateTime) "
+ "values(@WebMenus_Id,@WebMenus_Title,@WebMenus_Link,@WebMenus_Icon,@WebMenus_DeleteId,@WebMenus_ParentId,@WebMenus_CreateTime,@WebMenus_UpdateTime)";
return(SqlHelper <WebMenus> .ExceuteNonQuery(sql, model));
}
public int Add(Hint hint)
{
string sql = "insert into Hint(Hint_Id,Hint_Title,Hint_Phone,Hint_Image,Hint_QQ,Hint_DeleteId,Hint_CreateTime,Hint_UpdateTime)"
+ " values(@Hint_Id,@Hint_Title,@Hint_Phone,@Hint_Image,@Hint_QQ,@Hint_DeleteId,@Hint_CreateTime,@Hint_UpdateTime)";
return(SqlHelper <Hint> .ExceuteNonQuery(sql, hint));
}
public int Delete(Guid id)
{
string sql = "delete from UsersPermissions where UsersPermissions_Id = @UsersPermissions_Id";
return(SqlHelper <UsersPermissions> .ExceuteNonQuery(sql, new UsersPermissions()
{
UsersPermissions_Id = id
}));
}
public int Restore(Guid id)
{
string sql = "update Product set Product_DeleteId = 1 where Product_Id = @Product_Id";
return(SqlHelper <Product> .ExceuteNonQuery(sql, new Product()
{
Product_Id = id
}));
}
public int Delete(Guid id)
{
string sql = "delete from Product where Product_DeleteId = 0 and Product_Id = @Product_Id";
return(SqlHelper <Product> .ExceuteNonQuery(sql, new Product()
{
Product_Id = id
}));
}
public int Delete(Guid id)
{
string sql = "delete from Hint where Hint_DeleteId = 0 and Hint_Id = @Hint_Id";
return(SqlHelper <Hint> .ExceuteNonQuery(sql, new Hint()
{
Hint_Id = id
}));
}
public int Restore(Guid id)
{
string sql = "update Hint set Hint_DeleteId = 0 where Hint_Id = @Hint_Id";
return(SqlHelper <Hint> .ExceuteNonQuery(sql, new Hint()
{
Hint_Id = id
}));
}
public int Restore(Guid id)
{
string sql = "update Explanation set Explanation_DeleteId = 1 where Explanation_Id = @Explanation_Id";
return(SqlHelper <Explanation> .ExceuteNonQuery(sql, new Explanation()
{
Explanation_Id = id
}));
}
public int Delete(Guid id)
{
string sql = "delete from Explanation where Explanation_DeleteId = 0 and Explanation_Id=@Explanation_Id";
return(SqlHelper <Explanation> .ExceuteNonQuery(sql, new Explanation()
{
Explanation_Id = id
}));
}
public int Restore(Guid id)
{
string sql = "update LoanType set LoanType_DeleteId = 1 where LoanType_Id=@LoanType_Id";
return(SqlHelper <LoanType> .ExceuteNonQuery(sql, new LoanType()
{
LoanType_Id = id
}));
}
public int Delete(Guid id)
{
string sql = "delete from LoanType where LoanType_DeleteId = 0 and LoanType_Id=@LoanType_Id";
return(SqlHelper <LoanType> .ExceuteNonQuery(sql, new LoanType()
{
LoanType_Id = id
}));
}
public int Delete(Guid id)
{
string sql = "delete from Users where Users_DeleteId = 0 and Users_Id = @Users_Id";
return(SqlHelper <Users> .ExceuteNonQuery(sql, new Users()
{
Users_Id = id
}));
}
public int Restore(Guid id)
{
string sql = "update Users set Users_DeleteId = 0 where Users_Id = @Users_Id";
return(SqlHelper <Users> .ExceuteNonQuery(sql, new Users()
{
Users_Id = id
}));
}
