/// <summary>
/// 移除公司信息
/// </summary>
/// <param name="con">参数条件</param>
/// <returns></returns>
public int Delete_CompanyTableData(string con)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure, new SqlParameter[] {
new SqlParameter("@Com_id", con)
}));
}
/// <summary>
/// 更改用户
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_UserTableData(User_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@U_PhoneVerify", obj.U_PhoneVerify),
new SqlParameter("@IDT_id", obj.IDT_id),
new SqlParameter("@U_ComPanyAddress", obj.U_ComPanyAddress),
new SqlParameter("@U_Company", obj.U_Company),
new SqlParameter("@M_id", obj.M_id),
new SqlParameter("@U_CreateUserDate", obj.U_CreateUserDate),
new SqlParameter("@U_Head", obj.U_Head),
new SqlParameter("@U_id", obj.U_id),
new SqlParameter("@U_IDS", obj.U_IDS),
new SqlParameter("@U_LastLoginAddress", obj.U_LastLoginAddress),
new SqlParameter("@U_LastLoginDatetime", obj.U_LastLoginDatetime),
new SqlParameter("@U_LoginAddress", obj.U_LoginAddress),
new SqlParameter("@U_LoginDatetime", obj.U_LoginDatetime),
new SqlParameter("@U_Sex", obj.U_Sex),
new SqlParameter("@U_Name", obj.U_Name),
new SqlParameter("@U_Phone", obj.U_Phone),
new SqlParameter("@U_UserName", obj.U_UserName),
new SqlParameter("@U_UserPwd", obj.U_UserPwd),
new SqlParameter("@LS_id", obj.LS_id)
}));
}
/// <summary>
/// 更改员工
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_EmployeeTableData(Employee_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@E_id", obj.E_id),
new SqlParameter("@Dep_id", obj.Dep_id),
new SqlParameter("@E_Address", obj.E_Address),
new SqlParameter("@E_Date", obj.E_Date),
new SqlParameter("@E_Education", obj.E_Education),
new SqlParameter("@E_IdS", obj.E_IdS),
new SqlParameter("@E_LastLoginAddress", obj.E_LastLoginAddress),
new SqlParameter("@E_LastLoginDate", obj.E_LastLoginDate),
new SqlParameter("@E_LoginAddress", obj.E_LoginAddress),
new SqlParameter("@E_LoginDate", obj.E_LoginDate),
new SqlParameter("@E_Name", obj.E_Name),
new SqlParameter("@E_Pay", obj.E_Pay),
new SqlParameter("@E_Phone", obj.E_Phone),
new SqlParameter("@E_School", obj.E_School),
new SqlParameter("@E_Sex", obj.E_Sex),
new SqlParameter("@E_UserName", obj.E_UserName),
new SqlParameter("@IDT_id", obj.IDT_id),
new SqlParameter("@LS_ID", obj.LS_ID),
new SqlParameter("@Post_id", obj.Post_id),
new SqlParameter("@E_UserPwd", obj.E_UserPwd)
}));
}
/// <summary>
/// 添加登录状态
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_LoginStateTableData(LoginState_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@LS_Name", obj.LS_Name)
}));
}
/// <summary>
/// 移除部门
/// </summary>
/// <param name="con">参数条件</param>
/// <returns></returns>
public int Delete_DepartmentTableData(string con)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Delete"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@Dep_id", con)
}));
}
/// <summary>
/// 添加职位
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_PostTableData(Post_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@Post_Name", obj.Post_Name)
}));
}
/// <summary>
/// 更改试用审核状态
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_TryOutTableData(TryOut_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@TO_id", obj.TO_id),
new SqlParameter("@TO_Name", obj.TO_Name)
}));
}
/// <summary>
/// 更改订单状态
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_OrderStateTableData(OrderState_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@OState_id", obj.OState_id),
new SqlParameter("@OState_Name", obj.OState_Name)
}));
}
/// <summary>
/// 更改部门
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_DepartmentTableData(Department_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@Dep_Name", obj.Dep_Name),
new SqlParameter("@Dep_id", obj.Dep_id)
}));
}
/// <summary>
/// 添加招聘职位
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_JoinUsPostTableData(JoinUsPost_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@JUP_Name", obj.JUP_Name),
new SqlParameter("@JUP_Number", obj.JUP_Number)
}));
}
/// <summary>
/// 添加邮箱
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_MailTableData(Mail_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@M_Mail", obj.M_Mail),
new SqlParameter("@M_YesNo", obj.M_YesNo)
}));
}
/// <summary>
/// 更改证件类型
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_IDTypeTableData(IDType_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@IDT_Name", obj.IDT_Name),
new SqlParameter("@IDT_id", obj.IDT_id)
}));
}
/// <summary>
/// 更改是否热门产品
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_HotProductTableData(HotProduct_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@HP_Name", obj.HP_Name),
new SqlParameter("@HP_id", obj.HP_id)
}));
}
/// <summary>
/// 添加解决方案
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_SolutionTableData(Solution_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@P_id", obj.P_id),
new SqlParameter("@S_Content", obj.S_Content),
new SqlParameter("@S_Datetime", obj.S_Datetime),
new SqlParameter("@S_tatle", obj.S_tatle)
}));
}
/// <summary>
/// 添加购物车
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_ShopTableData(Shop_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@P_No", obj.P_No),
new SqlParameter("@Shop_Date", obj.Shop_Date),
new SqlParameter("@Shop_Number", obj.Shop_Number),
new SqlParameter("@Shop_User", obj.Shop_User)
}));
}
/// <summary>
/// 添加评价
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_EvaluateTableData(Evaluate_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@U_id", obj.U_id),
new SqlParameter("@P_id", obj.P_id),
new SqlParameter("@Eva_Datetime", obj.Eva_Datetime),
new SqlParameter("@Eva_Content", obj.Eva_Content)
}));
}
/// <summary>
/// 添加新闻
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_NewsTableData(News_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@News_Content", obj.News_Content),
new SqlParameter("@News_Date", obj.News_Date),
new SqlParameter("@News_Anthor", obj.News_Anthor),
new SqlParameter("@News_Name", obj.News_Name)
}));
}
/// <summary>
/// 更改反馈
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_FeedbackTableData(Feedback_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@U_id", obj.U_id),
new SqlParameter("@P_id", obj.P_id),
new SqlParameter("@Feed_id", obj.Feed_id),
new SqlParameter("@Feed_Datetime", obj.Feed_Datetime),
new SqlParameter("@Feed_Content", obj.Feed_Content)
}));
}
/// <summary>
/// 更改招聘
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Update_JoinUsTableData(JoinUs_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Update"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@JUP_id", obj.JUP_id),
new SqlParameter("@JU_Name", obj.JU_Name),
new SqlParameter("@JU_Phone", obj.JU_Phone),
new SqlParameter("@JU_Sex", obj.JU_Sex),
new SqlParameter("@JU_Address", obj.JU_Address),
new SqlParameter("@JU_SubmitDateTime", obj.JU_SubmitDateTime)
}));
}
/// <summary>
/// 添加公司信息
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_CompanyTableData(Company_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure, new SqlParameter[] {
new SqlParameter("@Com_Scope", obj.Com_Scope),
new SqlParameter("@Com_Course", obj.Com_Course),
new SqlParameter("@Com_Honer", obj.Com_Honer),
new SqlParameter("@Com_Introduce", obj.Com_Introduce),
new SqlParameter("@Com_Logo", obj.Com_Logo),
new SqlParameter("@Com_Name", obj.Com_Name),
new SqlParameter("@Com_Purpose", obj.Com_Purpose),
new SqlParameter("@Com_Scale", obj.Com_Scale)
}));
}
/// <summary>
/// 添加密保
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_IssueAnswerTableData(IssueAnswer_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@IA_Answer1", obj.IA_Answer1),
new SqlParameter("@IA_Answer2", obj.IA_Answer2),
new SqlParameter("@IA_Answer3", obj.IA_Answer3),
new SqlParameter("@IA_Issue1", obj.IA_Issue1),
new SqlParameter("@IA_Issue2", obj.IA_Issue2),
new SqlParameter("@IA_Issue3", obj.IA_Issue3),
new SqlParameter("@U_UserName", obj.U_UserName)
}));
}
/// <summary>
/// 添加订单
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_OrderTableData(Order_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@O_id", obj.O_id),
new SqlParameter("@O_DateTime", obj.O_DateTime),
new SqlParameter("@E_id", obj.E_id),
new SqlParameter("@O_DealWay", obj.O_DealWay),
new SqlParameter("@O_LeaveWords", obj.O_LeaveWords),
new SqlParameter("@O_Remark", obj.O_Remark),
new SqlParameter("@P_id", obj.P_id),
new SqlParameter("@U_id", obj.U_id)
}));
}
/// <summary>
/// 添加产品试用申请
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_ProductTryOurTableData(ProductTryOur_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@E_id", obj.E_id),
new SqlParameter("@PTO_Activate", obj.PTO_Activate),
new SqlParameter("@PTO_ApplyFor", obj.PTO_ApplyFor),
new SqlParameter("@PTO_AuditDate", obj.PTO_AuditDate),
new SqlParameter("@PTO_ExpireDate", obj.PTO_ExpireDate),
new SqlParameter("@TO_id", obj.TO_id),
new SqlParameter("@PTO_Remark", obj.PTO_Remark),
new SqlParameter("@PTO_Name", obj.PTO_Name),
new SqlParameter("@U_id", obj.U_id)
}));
}
/// <summary>
/// 添加产品
/// </summary>
/// <param name="obj">带入参数</param>
/// <returns></returns>
public int Insert_ProductTableData(Product_Table obj)
{
return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"),
CommandType.StoredProcedure,
new SqlParameter[] {
new SqlParameter("@E_id", obj.E_id),
new SqlParameter("@HP_id", obj.HP_id),
new SqlParameter("@NP_id", obj.NP_id),
new SqlParameter("@PT_id", obj.PT_id),
new SqlParameter("@P_Company", obj.P_Company),
new SqlParameter("@P_Date", obj.P_Date),
new SqlParameter("@P_Name", obj.P_Name),
new SqlParameter("@P_No", obj.P_No),
new SqlParameter("@P_CoverImage", obj.P_CoverImage),
new SqlParameter("@P_Introduce", obj.P_Introduce),
new SqlParameter("@P_Price", obj.P_Price)
}));
}