示例#1
0
        /// <summary>
        /// 根据条件查询用户信息
        /// </summary>
        /// <param name="con"></param>
        /// <param name="type">[id,name,phone]选其一(必填)</param>
        /// <returns></returns>
        public User_Table GetUserTableByConn(string con, string type)
        {
            string        sql = "";
            User_Table    obj = null;
            SqlDataReader dr  = null;

            switch (type.ToLower())
            {
            case "id":
                sql = "Select * from User_Table where U_id=@U_id";
                dr  = DBHerlper.ExecuteReader(
                    sql, CommandType.Text, new SqlParameter[] {
                    new SqlParameter("@U_id", con)
                });
                break;

            case "name":
                sql = "Select * from User_Table where U_UserName=@U_UserName";
                dr  = DBHerlper.ExecuteReader(
                    sql, CommandType.Text, new SqlParameter[] {
                    new SqlParameter("@U_UserName", con)
                });
                break;

            case "phone":
                sql = "Select * from User_Table where U_Phone=@U_Phone";
                dr  = DBHerlper.ExecuteReader(
                    sql, CommandType.Text, new SqlParameter[] {
                    new SqlParameter("@U_Phone", con)
                });
                break;
            }
            if (dr.Read())
            {
                obj = new User_Table()
                {
                    U_PhoneVerify       = dr["U_PhoneVerify"].ToString(),
                    IDT_id              = Convert.ToInt32(dr["IDT_id"]),
                    U_ComPanyAddress    = dr["U_ComPanyAddress"].ToString(),
                    U_Company           = dr["U_Company"].ToString(),
                    M_id                = Convert.ToInt32(dr["M_id"]),
                    U_CreateUserDate    = dr["U_CreateUserDate"].ToString(),
                    U_Head              = dr["U_Head"].ToString(),
                    U_id                = Convert.ToInt32(dr["U_id"]),
                    U_IDS               = dr["U_IDS"].ToString(),
                    U_LastLoginAddress  = dr["U_LastLoginAddress"].ToString(),
                    U_LastLoginDatetime = dr["U_LastLoginDatetime"].ToString(),
                    U_LoginAddress      = dr["U_LoginAddress"].ToString(),
                    U_LoginDatetime     = dr["U_LoginDatetime"].ToString(),
                    U_Sex               = dr["U_Sex"].ToString(),
                    U_Name              = dr["U_Name"].ToString(),
                    U_Phone             = dr["U_Phone"].ToString(),
                    U_UserName          = dr["U_UserName"].ToString(),
                    U_UserPwd           = dr["U_UserPwd"].ToString(),
                    LS_id               = Convert.ToInt32(dr["LS_id"])
                };
            }
            dr.Close();
            return(obj);
        }
示例#2
0
        /// <summary>
        /// 获取全部的产品
        /// </summary>
        /// <returns></returns>
        public List <Product_Table> GetProductTableAll()
        {
            List <Product_Table> list = new List <Product_Table>();
            SqlDataReader        dr   = DBHerlper.ExecuteReader(GetSqlString("Select"),
                                                                CommandType.StoredProcedure);

            while (dr.Read())
            {
                Product_Table obj = new Product_Table()
                {
                    E_id         = Convert.ToInt32(dr["E_id"]),
                    HP_id        = Convert.ToInt32(dr["HP_id"]),
                    NP_id        = Convert.ToInt32(dr["NP_id"]),
                    PT_id        = Convert.ToInt32(dr["PT_id"]),
                    P_Company    = dr["P_Company"].ToString(),
                    P_Date       = Convert.ToDateTime(dr["P_Date"]),
                    P_id         = Convert.ToInt32(dr["P_id"]),
                    P_Name       = dr["P_Name"].ToString(),
                    P_No         = dr["P_No"].ToString(),
                    P_Price      = Convert.ToDouble(dr["P_Price"]),
                    P_CoverImage = dr["P_CoverImage"].ToString(),
                    P_Introduce  = dr["P_Introduce"].ToString()
                };
                list.Add(obj);
            }
            dr.Close();
            return(list);
        }
示例#3
0
        /// <summary>
        /// 根据输入的属性名称查询产品信息
        /// </summary>
        /// <param name="con"></param>
        /// <returns></returns>
        public Product_Table GetProductTableByConn(string tyepAttrName, string con)
        {
            Product_Table obj      = null;
            string        attrName = "@" + tyepAttrName;
            SqlDataReader dr       = DBHerlper.ExecuteReader(
                "Select * from Product_Table where " + tyepAttrName + "=" + attrName,
                CommandType.Text, new SqlParameter[] {
                new SqlParameter(attrName, con)
            });

            if (dr.Read())
            {
                obj = new Product_Table()
                {
                    E_id         = Convert.ToInt32(dr["E_id"]),
                    HP_id        = Convert.ToInt32(dr["HP_id"]),
                    NP_id        = Convert.ToInt32(dr["NP_id"]),
                    PT_id        = Convert.ToInt32(dr["PT_id"]),
                    P_Company    = dr["P_Company"].ToString(),
                    P_Date       = Convert.ToDateTime(dr["P_Date"]),
                    P_id         = Convert.ToInt32(dr["P_id"]),
                    P_Name       = dr["P_Name"].ToString(),
                    P_No         = dr["P_No"].ToString(),
                    P_Price      = Convert.ToDouble(dr["P_Price"]),
                    P_CoverImage = dr["P_CoverImage"].ToString(),
                    P_Introduce  = dr["P_Introduce"].ToString()
                };
            }
            dr.Close();
            return(obj);
        }
示例#4
0
        /// <summary>
        /// 根据ID查询招聘职位信息
        /// </summary>
        /// <param name="con"></param>
        /// <returns></returns>
        public JoinUs_Table GetJoinUsTableByConn(string con)
        {
            JoinUs_Table  obj = null;
            SqlDataReader dr  = DBHerlper.ExecuteReader(
                "Select * from JoinUs_Table where JU_id=@JU_id",
                CommandType.Text, new SqlParameter[] {
                new SqlParameter("@JU_id", con)
            });

            if (dr.Read())
            {
                obj = new JoinUs_Table()
                {
                    JUP_id            = Convert.ToInt32(dr["JUP_id"]),
                    JU_id             = Convert.ToInt32(dr["JU_id"]),
                    JU_Name           = dr["JU_Name"].ToString(),
                    JU_Address        = dr["JU_Address"].ToString(),
                    JU_SubmitDateTime = Convert.ToDateTime(dr["JU_SubmitDateTime"]),
                    JU_Phone          = dr["JU_Phone"].ToString(),
                    JU_Sex            = dr["JU_Sex"].ToString()
                };
            }
            dr.Close();
            return(obj);
        }
示例#5
0
 /// <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)
     }));
 }
示例#6
0
        /// <summary>
        /// 获取全部的用户
        /// </summary>
        /// <returns></returns>
        public List <User_Table> GetUserTableAll()
        {
            List <User_Table> list = new List <User_Table>();
            SqlDataReader     dr   = DBHerlper.ExecuteReader(GetSqlString("Select"),
                                                             CommandType.StoredProcedure);

            while (dr.Read())
            {
                User_Table obj = new User_Table()
                {
                    U_PhoneVerify       = dr["U_PhoneVerify"].ToString(),
                    IDT_id              = Convert.ToInt32(dr["IDT_id"]),
                    U_ComPanyAddress    = dr["U_ComPanyAddress"].ToString(),
                    U_Company           = dr["U_Company"].ToString(),
                    M_id                = Convert.ToInt32(dr["M_id"]),
                    U_CreateUserDate    = dr["U_CreateUserDate"].ToString(),
                    U_Head              = dr["U_Head"].ToString(),
                    U_id                = Convert.ToInt32(dr["U_id"]),
                    U_IDS               = dr["U_IDS"].ToString(),
                    U_LastLoginAddress  = dr["U_LastLoginAddress"].ToString(),
                    U_LastLoginDatetime = dr["U_LastLoginDatetime"].ToString(),
                    U_LoginAddress      = dr["U_LoginAddress"].ToString(),
                    U_LoginDatetime     = dr["U_LoginDatetime"].ToString(),
                    U_Sex               = dr["U_Sex"].ToString(),
                    U_Name              = dr["U_Name"].ToString(),
                    U_Phone             = dr["U_Phone"].ToString(),
                    U_UserName          = dr["U_UserName"].ToString(),
                    U_UserPwd           = dr["U_UserPwd"].ToString(),
                    LS_id               = Convert.ToInt32(dr["LS_id"])
                };
                list.Add(obj);
            }
            dr.Close();
            return(list);
        }
        /// <summary>
        /// 获取全部的产品试用申请
        /// </summary>
        /// <returns></returns>
        public List <ProductTryOur_Table> GetProductTryOurTableAll()
        {
            List <ProductTryOur_Table> list = new List <ProductTryOur_Table>();
            SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"),
                                                       CommandType.StoredProcedure);

            while (dr.Read())
            {
                ProductTryOur_Table obj = new ProductTryOur_Table()
                {
                    E_id           = Convert.ToInt32(dr["E_id"]),
                    PTO_Activate   = Convert.ToInt32(dr["PTO_Activate"]),
                    PTO_ApplyFor   = Convert.ToDateTime(dr["PTO_ApplyFor"]),
                    PTO_AuditDate  = Convert.ToDateTime(dr["PTO_AuditDate"]),
                    PTO_ExpireDate = Convert.ToDateTime(dr["PTO_ExpireDate"]),
                    PTO_id         = Convert.ToInt32(dr["PTO_id"]),
                    TO_id          = Convert.ToInt32(dr["TO_id"]),
                    PTO_Remark     = dr["PTO_Remark"].ToString(),
                    PTO_Name       = dr["TO_id"].ToString(),
                    U_id           = Convert.ToInt32(dr["U_id"])
                };
                list.Add(obj);
            }
            dr.Close();
            return(list);
        }
示例#8
0
        /// <summary>
        /// 根据ID查询购物车信息
        /// </summary>
        /// <param name="con"></param>
        /// <returns></returns>
        public Shop_Table GetShopTableByConn(string attrName, string con)
        {
            string        name = "@" + attrName;
            Shop_Table    obj  = null;
            SqlDataReader dr   = DBHerlper.ExecuteReader(
                "Select * from Shop_Table where " + attrName + "=" + name,
                CommandType.Text, new SqlParameter[] {
                new SqlParameter(name, con)
            });

            if (dr.Read())
            {
                obj = new Shop_Table()
                {
                    P_No        = dr["P_No"].ToString(),
                    Shop_Date   = dr["Shop_Date"].ToString(),
                    Shop_Id     = Convert.ToInt32(dr["Shop_Id"]),
                    Shop_Number = dr["Shop_Number"].ToString(),
                    Shop_User   = dr["Shop_User"].ToString()
                };
            }
            dr.Close();
            DBHerlper.CloseConn();
            return(obj);
        }
示例#9
0
        /// <summary>
        /// 获取全部的订单
        /// </summary>
        /// <returns></returns>
        public List <Order_Table> GetOrderTableAll()
        {
            List <Order_Table> list = new List <Order_Table>();
            SqlDataReader      dr   = DBHerlper.ExecuteReader(GetSqlString("Select"),
                                                              CommandType.StoredProcedure);

            while (dr.Read())
            {
                Order_Table obj = new Order_Table()
                {
                    O_id         = Convert.ToInt32(dr["O_id"]),
                    OState_id    = (int)dr["OState_id"],
                    O_DateTime   = (DateTime)dr["O_DateTime"],
                    E_id         = (int)dr["E_id"],
                    O_DealWay    = dr["O_DealWay"].ToString(),
                    O_LeaveWords = dr["O_LeaveWords"].ToString(),
                    O_Remark     = dr["O_Remark"].ToString(),
                    P_id         = (int)dr["P_id"],
                    U_id         = (int)dr["U_id"]
                };
                list.Add(obj);
            }
            dr.Close();
            return(list);
        }
示例#10
0
        /// <summary>
        /// 根据条件查询订单信息
        /// </summary>
        /// <param name="con"></param>
        /// <returns></returns>
        public List <Order_Table> GetOrderTableByConn(string attr, string con)
        {
            List <Order_Table> list  = new List <Order_Table> ();
            string             attrs = "@" + attr;
            SqlDataReader      dr    = DBHerlper.ExecuteReader(
                "Select * from Order_Table where " + attr + "=" + attrs,
                CommandType.Text, new SqlParameter[] {
                new SqlParameter(attrs, con)
            });

            if (dr.Read())
            {
                Order_Table obj = new Order_Table()
                {
                    O_id         = Convert.ToInt32(dr["O_id"]),
                    OState_id    = (int)dr["OState_id"],
                    O_DateTime   = (DateTime)dr["O_DateTime"],
                    E_id         = (int)dr["E_id"],
                    O_DealWay    = dr["O_DealWay"].ToString(),
                    O_LeaveWords = dr["O_LeaveWords"].ToString(),
                    O_Remark     = dr["O_Remark"].ToString(),
                    P_id         = (int)dr["P_id"],
                    U_id         = (int)dr["U_id"]
                };
                list.Add(obj);
            }
            dr.Close();
            return(list);
        }
示例#11
0
        /// <summary>
        /// 根据ID查询密保信息
        /// </summary>
        /// <param name="con"></param>
        /// <returns></returns>
        public IssueAnswer_Table GetIssueAnswerTableByConn(string con)
        {
            IssueAnswer_Table obj = null;
            SqlDataReader     dr  = DBHerlper.ExecuteReader(
                "Select * from IssueAnswer_Table where IA_id=@IA_id",
                CommandType.Text, new SqlParameter[] {
                new SqlParameter("@IA_id", con)
            });

            if (dr.Read())
            {
                obj = new IssueAnswer_Table()
                {
                    IA_Answer1 = dr["IA_Answer1"].ToString(),
                    IA_Answer2 = dr["IA_Answer2"].ToString(),
                    IA_Answer3 = dr["IA_Answer3"].ToString(),
                    IA_id      = Convert.ToInt32(dr["IA_id"]),
                    IA_Issue1  = dr["IA_Issue1"].ToString(),
                    IA_Issue2  = dr["IA_Issue2"].ToString(),
                    IA_Issue3  = dr["IA_Issue3"].ToString(),
                    U_UserName = dr["U_UserName"].ToString()
                };
            }
            dr.Close();
            return(obj);
        }
示例#12
0
        /// <summary>
        /// 根据条件查询订单信息并且进行分页
        /// </summary>
        /// <param name="id">用户ID</param>
        /// <param name="pageNo">当前页(用户选中的页数)</param>
        /// <param name="pageSize">显示数据</param>
        /// <returns></returns>
        public List <Order_Table> GetOrderTableByConn_Page(int id, int pageNo, int pageSize)
        {
            List <Order_Table> list = new List <Order_Table>();
            SqlDataReader      dr   = DBHerlper.ExecuteReader(
                "proc_OrderPage",
                CommandType.Text, new SqlParameter[] {
                new SqlParameter("@U_id", id),
                new SqlParameter("@PageNo", pageNo),
                new SqlParameter("@PageSize", pageSize)
            });

            if (dr.Read())
            {
                Order_Table obj = new Order_Table()
                {
                    O_id         = Convert.ToInt32(dr["O_id"]),
                    OState_id    = (int)dr["OState_id"],
                    O_DateTime   = (DateTime)dr["O_DateTime"],
                    E_id         = (int)dr["E_id"],
                    O_DealWay    = dr["O_DealWay"].ToString(),
                    O_LeaveWords = dr["O_LeaveWords"].ToString(),
                    O_Remark     = dr["O_Remark"].ToString(),
                    P_id         = (int)dr["P_id"],
                    U_id         = (int)dr["U_id"]
                };
                list.Add(obj);
            }
            dr.Close();
            return(list);
        }
        /// <summary>
        /// 根据ID查询产品试用申请信息
        /// </summary>
        /// <param name="con"></param>
        /// <returns></returns>
        public ProductTryOur_Table GetProductTryOurTableByConn(string con)
        {
            ProductTryOur_Table obj = null;
            SqlDataReader       dr  = DBHerlper.ExecuteReader(
                "Select * from ProductTryOur_Table where PTO_id=@PTO_id",
                CommandType.Text, new SqlParameter[] {
                new SqlParameter("@PTO_id", con)
            });

            if (dr.Read())
            {
                obj = new ProductTryOur_Table()
                {
                    E_id           = Convert.ToInt32(dr["E_id"]),
                    PTO_Activate   = Convert.ToInt32(dr["PTO_Activate"]),
                    PTO_ApplyFor   = Convert.ToDateTime(dr["PTO_ApplyFor"]),
                    PTO_AuditDate  = Convert.ToDateTime(dr["PTO_AuditDate"]),
                    PTO_ExpireDate = Convert.ToDateTime(dr["PTO_ExpireDate"]),
                    PTO_id         = Convert.ToInt32(dr["PTO_id"]),
                    TO_id          = Convert.ToInt32(dr["TO_id"]),
                    PTO_Remark     = dr["PTO_Remark"].ToString(),
                    PTO_Name       = dr["TO_id"].ToString(),
                    U_id           = Convert.ToInt32(dr["U_id"])
                };
            }
            dr.Close();
            return(obj);
        }
示例#14
0
 /// <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)
     }));
 }
示例#15
0
 /// <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)
     }));
 }
示例#16
0
 /// <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)
     }));
 }
示例#17
0
 /// <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)
     }));
 }
示例#18
0
 /// <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)
     }));
 }
示例#19
0
 /// <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)
     }));
 }
示例#20
0
 /// <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)
     }));
 }
示例#21
0
 /// <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)
     }));
 }
示例#22
0
 /// <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)
     }));
 }
示例#23
0
 /// <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)
     }));
 }
示例#24
0
 /// <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)
     }));
 }
示例#25
0
 /// <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)
     }));
 }
示例#26
0
 /// <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)
     }));
 }
示例#27
0
 /// <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)
     }));
 }
示例#28
0
 /// <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)
     }));
 }
示例#29
0
 /// <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)
     }));
 }
示例#30
0
 /// <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)
     }));
 }