Пример #1
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public XHD.Model.Sys_role GetModel(int RoleID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  RoleID,Factory_Id,RoleName,RoleDscript,RoleSort,CreateID,CreateDate,UpdateID,UpdateDate from Sys_role ");
            strSql.Append(" where RoleID=@RoleID limit 1");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@RoleID", MySqlDbType.Int32, 4)
            };
            parameters[0].Value = RoleID;

            XHD.Model.Sys_role model = new XHD.Model.Sys_role();
            DataSet            ds    = DbHelperMySQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["RoleID"] != null && ds.Tables[0].Rows[0]["RoleID"].ToString() != "")
                {
                    model.RoleID = int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["RoleName"] != null && ds.Tables[0].Rows[0]["RoleName"].ToString() != "")
                {
                    model.RoleName = ds.Tables[0].Rows[0]["RoleName"].ToString();
                }
                if (ds.Tables[0].Rows[0]["RoleDscript"] != null && ds.Tables[0].Rows[0]["RoleDscript"].ToString() != "")
                {
                    model.RoleDscript = ds.Tables[0].Rows[0]["RoleDscript"].ToString();
                }
                if (ds.Tables[0].Rows[0]["RoleSort"] != null && ds.Tables[0].Rows[0]["RoleSort"].ToString() != "")
                {
                    model.RoleSort = int.Parse(ds.Tables[0].Rows[0]["RoleSort"].ToString());
                }
                if (ds.Tables[0].Rows[0]["CreateID"] != null && ds.Tables[0].Rows[0]["CreateID"].ToString() != "")
                {
                    model.CreateID = int.Parse(ds.Tables[0].Rows[0]["CreateID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["CreateDate"] != null && ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
                {
                    model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["UpdateID"] != null && ds.Tables[0].Rows[0]["UpdateID"].ToString() != "")
                {
                    model.UpdateID = int.Parse(ds.Tables[0].Rows[0]["UpdateID"].ToString());
                }
                if (ds.Tables[0].Rows[0]["UpdateDate"] != null && ds.Tables[0].Rows[0]["UpdateDate"].ToString() != "")
                {
                    model.UpdateDate = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateDate"].ToString());
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }
Пример #2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(XHD.Model.Sys_role model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Sys_role set ");
            strSql.Append("RoleName=@RoleName,");
            strSql.Append("RoleDscript=@RoleDscript,");
            strSql.Append("RoleSort=@RoleSort,");
            strSql.Append("CreateID=@CreateID,");
            strSql.Append("CreateDate=@CreateDate,");
            strSql.Append("UpdateID=@UpdateID,");
            strSql.Append("UpdateDate=@UpdateDate");
            strSql.Append(" where RoleID=@RoleID");
            SqlParameter[] parameters =
            {
                new SqlParameter("@RoleName",    SqlDbType.VarChar,   255),
                new SqlParameter("@RoleDscript", SqlDbType.VarChar,   255),
                new SqlParameter("@RoleSort",    SqlDbType.NChar,      10),
                new SqlParameter("@CreateID",    SqlDbType.Int,         4),
                new SqlParameter("@CreateDate",  SqlDbType.DateTime),
                new SqlParameter("@UpdateID",    SqlDbType.Int,         4),
                new SqlParameter("@UpdateDate",  SqlDbType.DateTime),
                new SqlParameter("@RoleID",      SqlDbType.Int, 4)
            };
            parameters[0].Value = model.RoleName;
            parameters[1].Value = model.RoleDscript;
            parameters[2].Value = model.RoleSort;
            parameters[3].Value = model.CreateID;
            parameters[4].Value = model.CreateDate;
            parameters[5].Value = model.UpdateID;
            parameters[6].Value = model.UpdateDate;
            parameters[7].Value = model.RoleID;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Пример #3
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(XHD.Model.Sys_role model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Sys_role(");
            strSql.Append("Factory_Id,RoleName,RoleDscript,RoleSort,CreateID,CreateDate,UpdateID,UpdateDate)");
            strSql.Append(" values (");
            strSql.Append("@Factory_Id,@RoleName,@RoleDscript,@RoleSort,@CreateID,@CreateDate,@UpdateID,@UpdateDate)");
            strSql.Append(";select @@IDENTITY");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@Factory_Id",  MySqlDbType.VarChar,    60),
                new MySqlParameter("@RoleName",    MySqlDbType.VarChar,   255),
                new MySqlParameter("@RoleDscript", MySqlDbType.VarChar,   255),
                new MySqlParameter("@RoleSort",    MySqlDbType.Int32,       4),
                new MySqlParameter("@CreateID",    MySqlDbType.Int32,       4),
                new MySqlParameter("@CreateDate",  MySqlDbType.DateTime),
                new MySqlParameter("@UpdateID",    MySqlDbType.Int32,       4),
                new MySqlParameter("@UpdateDate",  MySqlDbType.DateTime)
            };
            parameters[0].Value = model.Factory_Id;
            parameters[1].Value = model.RoleName;
            parameters[2].Value = model.RoleDscript;
            parameters[3].Value = model.RoleSort;
            parameters[4].Value = model.CreateID;
            parameters[5].Value = model.CreateDate;
            parameters[6].Value = model.UpdateID;
            parameters[7].Value = model.UpdateDate;

            object obj = DbHelperMySQL.GetSingle(strSql.ToString(), parameters);

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
Пример #4
0
        /// <summary>
        /// �õ�һ������ʵ��
        /// </summary>
        public XHD.Model.Sys_role GetModel(int RoleID)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 RoleID,RoleName,RoleDscript,RoleSort,CreateID,CreateDate,UpdateID,UpdateDate from Sys_role ");
            strSql.Append(" where RoleID=@RoleID");
            SqlParameter[] parameters = {
                    new SqlParameter("@RoleID", SqlDbType.Int,4)
            };
            parameters[0].Value = RoleID;

            XHD.Model.Sys_role model=new XHD.Model.Sys_role();
            DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                if(ds.Tables[0].Rows[0]["RoleID"]!=null && ds.Tables[0].Rows[0]["RoleID"].ToString()!="")
                {
                    model.RoleID=int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString());
                }
                if(ds.Tables[0].Rows[0]["RoleName"]!=null && ds.Tables[0].Rows[0]["RoleName"].ToString()!="")
                {
                    model.RoleName=ds.Tables[0].Rows[0]["RoleName"].ToString();
                }
                if(ds.Tables[0].Rows[0]["RoleDscript"]!=null && ds.Tables[0].Rows[0]["RoleDscript"].ToString()!="")
                {
                    model.RoleDscript=ds.Tables[0].Rows[0]["RoleDscript"].ToString();
                }
                if(ds.Tables[0].Rows[0]["RoleSort"]!=null && ds.Tables[0].Rows[0]["RoleSort"].ToString()!="")
                {
                    model.RoleSort=ds.Tables[0].Rows[0]["RoleSort"].ToString();
                }
                if(ds.Tables[0].Rows[0]["CreateID"]!=null && ds.Tables[0].Rows[0]["CreateID"].ToString()!="")
                {
                    model.CreateID=int.Parse(ds.Tables[0].Rows[0]["CreateID"].ToString());
                }
                if(ds.Tables[0].Rows[0]["CreateDate"]!=null && ds.Tables[0].Rows[0]["CreateDate"].ToString()!="")
                {
                    model.CreateDate=DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
                }
                if(ds.Tables[0].Rows[0]["UpdateID"]!=null && ds.Tables[0].Rows[0]["UpdateID"].ToString()!="")
                {
                    model.UpdateID=int.Parse(ds.Tables[0].Rows[0]["UpdateID"].ToString());
                }
                if(ds.Tables[0].Rows[0]["UpdateDate"]!=null && ds.Tables[0].Rows[0]["UpdateDate"].ToString()!="")
                {
                    model.UpdateDate=DateTime.Parse(ds.Tables[0].Rows[0]["UpdateDate"].ToString());
                }
                return model;
            }
            else
            {
                return null;
            }
        }