コード例 #1
0
        /// <summary>
        /// 更新责任编辑数据
        /// </summary>
        /// <param name="UpdateUserResponsible">更新责编</param>
        /// <returns>操作结果</returns>
        public static int UpdateUserResponsible(UserResponsibleEditor userResponsibleEditor)
        {
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_ID", SqlDbType.Int).Value                       = userResponsibleEditor.Id;          //主键ID
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_RoleID", SqlDbType.Int).Value                   = userResponsibleEditor.RoleInfo.Id; //角色编号
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Name", SqlDbType.VarChar, 100).Value            = userResponsibleEditor.Name;        //用户名
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Pwd", SqlDbType.VarChar, 50).Value              = userResponsibleEditor.Pwd;         //用户密码
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_CreateTime", SqlDbType.DateTime).Value          = userResponsibleEditor.CreateTime;  //创建时间
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_RealName", SqlDbType.VarChar, 50).Value         = userResponsibleEditor.RealName;    //真实姓名
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Sex", SqlDbType.Bit).Value                      = userResponsibleEditor.Sex;         //用户性别
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Birthday", SqlDbType.DateTime).Value            = userResponsibleEditor.Birthday;    //用户生日
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Tel", SqlDbType.VarChar, 50).Value              = userResponsibleEditor.Tel;         //联系电话
            DBVisit.ObjDBAccess.CmdParas.Add("@UserInfo_Email", SqlDbType.VarChar, 50).Value            = userResponsibleEditor.Email;       //Email
            DBVisit.ObjDBAccess.CmdParas.Add("@ResponsibleEditor_ColumnID", SqlDbType.Int).Value        = userResponsibleEditor.ColumnID;    //负责栏目编号
            DBVisit.ObjDBAccess.CmdParas.Add("@ResponsibleEditor_Remark", SqlDbType.VarChar, 100).Value = userResponsibleEditor.Remark;      //责编备注
            DBVisit.ObjDBAccess.CmdParas.Add("@IsSuccess", SqlDbType.Bit).Direction                     = ParameterDirection.Output;         //是否执行成功 参数类型设置为output

            //执行
            DBVisit.ObjDBAccess.ExcuteProcReturnInt("porc_UpdateUserResponsibleEditorInfo");
            bool isOK = Convert.ToBoolean(DBVisit.ObjDBAccess.CmdParas["@IsSuccess"].Value);

            if (isOK)
            {
                return(1);
            }
            else
            {
                return(0);
            }
        }
コード例 #2
0
        /// <summary>
        /// 增加数据到UserResponsible表中
        /// </summary>
        /// <returns></returns>
        public static int InsertUserResponsible(UserResponsibleEditor userResponsibleEditor)
        {
            SqlParameter isSuccessParam = new SqlParameter();

            isSuccessParam.ParameterName = "@IsSuccess";
            isSuccessParam.Direction     = ParameterDirection.Output;
            SqlParameter[] sqlPm = new SqlParameter[]         //创建一个参数列表
            {
                new SqlParameter("@UserInfo_RoleID", userResponsibleEditor.RoleInfo.Id),
                new SqlParameter("@UserInfo_Name", userResponsibleEditor.Name),
                new SqlParameter("@UserInfo_Pwd", userResponsibleEditor.Pwd),
                new SqlParameter("@UserInfo_CreateTime", userResponsibleEditor.CreateTime),
                new SqlParameter("@UserInfo_RealName", userResponsibleEditor.RealName),
                new SqlParameter("@UserInfo_Sex", userResponsibleEditor.Sex),
                new SqlParameter("@UserInfo_Birthday", userResponsibleEditor.Birthday),
                new SqlParameter("@UserInfo_Tel", userResponsibleEditor.Tel),
                new SqlParameter("@UserInfo_Email", userResponsibleEditor.Email),
                new SqlParameter("@ResponsibleEditor_ColumnID", userResponsibleEditor.ColumnID),
                new SqlParameter("@ResponsibleEditor_Remark", userResponsibleEditor.Remark),
                new SqlParameter("@UserInfo_Email", userResponsibleEditor.Email),
                isSuccessParam
            };
            DBVisit.ObjDBAccess.CmdParas.AddRange(sqlPm);                                 //将参数加入到SqlCommand的SqlParameter集合中去
            DBVisit.ObjDBAccess.ExcuteProcReturnInt("por_InsertUserResponbleEditorById"); //执行存储过程
            bool isOK = Convert.ToBoolean(DBVisit.ObjDBAccess.CmdParas["@IsSuccess"].Value);

            if (isOK)
            {
                return(1);
            }
            else
            {
                return(0);
            }
        }
コード例 #3
0
        /// <summary>
        /// 根据ID查找责任编辑
        /// </summary>
        /// <param name="id">要查找的ID</param>
        /// <returns>返回查找的对象</returns>
        public static UserResponsibleEditor GetUserResponsibleEditorById(int id)
        {
            SqlParameter sqlPm = new SqlParameter("@id", id);                                                       //创建一个查询参数

            DBVisit.ObjDBAccess.CmdParas.Add(sqlPm);                                                                //将创建的参数加入到SqlCommand对象中的SqlParameter
            UserResponsibleEditor userResponsibleEditor = new UserResponsibleEditor();                              //创建一个对象 用来返回Dataset
            DataTable             ds = DBVisit.ObjDBAccess.ExecuteProc("pro_GetUserResponbleEditorById").Tables[0]; //执行查找操作 返回找DataSet

            userResponsibleEditor.Birthday   = Convert.ToDateTime(ds.Rows[0]["UserInfo_CreateTime"]);
            userResponsibleEditor.ColumnID   = Convert.ToInt32(ds.Rows[0]["ResponsibleEditor_ColumnID"]);
            userResponsibleEditor.CreateTime = Convert.ToDateTime(ds.Rows[0]["UserInfo_CreateTime"]);
            userResponsibleEditor.Email      = Convert.ToString(ds.Rows[0]["UserInfo_Email"]);
            userResponsibleEditor.Id         = id;
            userResponsibleEditor.Name       = Convert.ToString(ds.Rows[0]["UserInfo_Name"]);
            userResponsibleEditor.Pwd        = Convert.ToString(ds.Rows[0]["UserInfo_Pwd"]);
            userResponsibleEditor.RealName   = Convert.ToString(ds.Rows[0]["UserInfo_RealName"]);
            userResponsibleEditor.Remark     = Convert.ToString(ds.Rows[0]["ResponsibleEditor_Remark"]);
            userResponsibleEditor.RoleInfo   = RoleService.GetRoleById(int.Parse(ds.Rows[0]["UserInfo_RoleID"].ToString()));
            userResponsibleEditor.Sex        = Convert.ToBoolean(ds.Rows[0]["UserInfo_Sex"]);
            userResponsibleEditor.Tel        = Convert.ToString(ds.Rows[0]["UserInfo_Tel"]);
            return(userResponsibleEditor);           //返回找到的对象
        }
コード例 #4
0
        /// <summary>
        /// 查询所有的责任编辑
        /// </summary>
        /// <returns>返回List<UserResponsibleEditor> </returns>
        public static List <UserResponsibleEditor> GetUserResponsibleAll()
        {
            List <UserResponsibleEditor> list = new List <UserResponsibleEditor>();                    //创建一个UserResponsibleEditor泛型用来存储找到的全部信息
            DataTable dt = DBVisit.ObjDBAccess.ExecuteProc("pro_GetUserResponbleEditorAll").Tables[0]; //创建一个对象 用来返回Dataset

            foreach (DataRow dr in dt.Rows)                                                            //遍历所有的行数 给每条记录创建一个对象
            {
                UserResponsibleEditor userResponsibleEditor = new UserResponsibleEditor();
                userResponsibleEditor.Birthday   = Convert.ToDateTime(dr["UserInfo_CreateTime"]);
                userResponsibleEditor.ColumnID   = Convert.ToInt32(dr["ResponsibleEditor_ColumnID"]);
                userResponsibleEditor.CreateTime = Convert.ToDateTime(dr["UserInfo_CreateTime"]);
                userResponsibleEditor.Email      = Convert.ToString(dr["UserInfo_Email"]);
                userResponsibleEditor.Id         = Convert.ToInt32(dr["ResponsibleEditor_ID"]);
                userResponsibleEditor.Name       = Convert.ToString(dr["UserInfo_Name"]);
                userResponsibleEditor.Pwd        = Convert.ToString(dr["UserInfo_Pwd"]);
                userResponsibleEditor.RealName   = Convert.ToString(dr["UserInfo_RealName"]);
                userResponsibleEditor.Remark     = Convert.ToString(dr["ResponsibleEditor_Remark"]);
                userResponsibleEditor.RoleInfo   = RoleService.GetRoleById(int.Parse(dr["UserInfo_RoleID"].ToString()));
                userResponsibleEditor.Sex        = Convert.ToBoolean(dr["UserInfo_Sex"]);
                userResponsibleEditor.Tel        = Convert.ToString(dr["UserInfo_Tel"]);
                list.Add(userResponsibleEditor); //加入到UserResponsibleEditor泛型中
            }
            return(list);                        //返回UserResponsibleEditor泛型
        }