Пример #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        /// <param name="model">model</param>
        public int AddRecord(Base_ModuleData model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("set nocount on; ");
            strSql.Append("insert into Base_Module(");
            strSql.Append(@"ParentId,Code,FullName,CategoryId,NavigateUrl,ImageIndex,SelectedImageIndex,Target,SortCode,Enabled,
                            DeletionStateCode,IsPublic,IsMenu,Expand,AllowEdit,AllowDelete,Description,CreateOn,CreateUserId,CreateBy,
                            ModifiedOn,ModifiedUserId,ModifiedBy)");
            strSql.Append(" values (");
            strSql.Append(@"@ParentId,@Code,@FullName,@CategoryId,@NavigateUrl,@ImageIndex,@SelectedImageIndex,@Target,@SortCode,@Enabled,
                            @DeletionStateCode,@IsPublic,@IsMenu,@Expand,@AllowEdit,@AllowDelete,@Description,@CreateOn,@CreateUserId,@CreateBy,
                            @ModifiedOn,@ModifiedUserId,@ModifiedBy)");
            strSql.Append("; select @@identity; set nocount off; ");
            SqlParameter[] parameters = {
                    new SqlParameter("@ParentId", SqlDbType.Int),
                    new SqlParameter("@Code", SqlDbType.NVarChar,100),
                    new SqlParameter("@FullName", SqlDbType.NVarChar,100),
                    new SqlParameter("@CategoryId", SqlDbType.NVarChar,50),
                    new SqlParameter("@NavigateUrl", SqlDbType.NVarChar,200),
                    new SqlParameter("@ImageIndex", SqlDbType.NVarChar,50),
                    new SqlParameter("@SelectedImageIndex", SqlDbType.NVarChar,50),
                    new SqlParameter("@Target", SqlDbType.NVarChar,100),
                    new SqlParameter("@SortCode", SqlDbType.Int),
                    new SqlParameter("@Enabled", SqlDbType.Int),
                    new SqlParameter("@DeletionStateCode", SqlDbType.Int),
                    new SqlParameter("@IsPublic", SqlDbType.Int),
                    new SqlParameter("@IsMenu", SqlDbType.Int),
                    new SqlParameter("@Expand", SqlDbType.Int),
                    new SqlParameter("@AllowEdit", SqlDbType.Int),
                    new SqlParameter("@AllowDelete", SqlDbType.Int),
                    new SqlParameter("@Description", SqlDbType.NVarChar,200),
                    new SqlParameter("@CreateOn", SqlDbType.SmallDateTime),
                    new SqlParameter("@CreateUserId", SqlDbType.NVarChar,50),
                    new SqlParameter("@CreateBy", SqlDbType.NVarChar,50),
                    new SqlParameter("@ModifiedOn", SqlDbType.SmallDateTime),
                    new SqlParameter("@ModifiedUserId", SqlDbType.NVarChar,50),
                    new SqlParameter("@ModifiedBy", SqlDbType.NVarChar,50)
                };
            parameters[0].Value = model.ParentId;
            parameters[1].Value = model.Code;
            parameters[2].Value = model.FullName;
            parameters[3].Value = model.CategoryId;
            parameters[4].Value = model.NavigateUrl;
            parameters[5].Value = model.ImageIndex;
            parameters[6].Value = model.SelectedImageIndex;
            parameters[7].Value = model.Target;
            parameters[8].Value = model.SortCode;
            parameters[9].Value = model.Enabled;
            parameters[10].Value = model.DeletionStateCode;
            parameters[11].Value = model.IsPublic;
            parameters[12].Value = model.IsMenu;
            parameters[13].Value = model.Expand;
            parameters[14].Value = model.AllowEdit;
            parameters[15].Value = model.AllowDelete;
            parameters[16].Value = model.Description;
            parameters[17].Value = model.CreateOn == string.Empty ? null : model.CreateOn;
            parameters[18].Value = model.CreateUserId;
            parameters[19].Value = model.CreateBy;
            parameters[20].Value = model.ModifiedOn == string.Empty ? null : model.ModifiedOn;
            parameters[21].Value = model.ModifiedUserId;
            parameters[22].Value = model.ModifiedBy;

            int id = 0;
            try
            {
                object ret = SqlHelper.ExecuteScalar(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);

                if (ret != null && ret != DBNull.Value)
                {
                    id = Convert.ToInt32(ret);
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return id;
        }
Пример #2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        /// <param name="model">model</param>
        public bool ModifyRecord(Base_ModuleData model)
        {
            bool ret = false;
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update Base_Module set ");
            strSql.Append("ParentId=@ParentId,");
            strSql.Append("Code=@Code,");
            strSql.Append("FullName=@FullName,");
            strSql.Append("CategoryId=@CategoryId,");
            strSql.Append("NavigateUrl=@NavigateUrl,");
            strSql.Append("ImageIndex=@ImageIndex,");
            strSql.Append("SelectedImageIndex=@SelectedImageIndex,");
            strSql.Append("Target=@Target,");
            strSql.Append("SortCode=@SortCode,");
            strSql.Append("Enabled=@Enabled,");
            strSql.Append("DeletionStateCode=@DeletionStateCode,");
            strSql.Append("IsPublic=@IsPublic,");
            strSql.Append("IsMenu=@IsMenu,");
            strSql.Append("Expand=@Expand,");
            strSql.Append("AllowEdit=@AllowEdit,");
            strSql.Append("AllowDelete=@AllowDelete,");
            strSql.Append("Description=@Description,");
            strSql.Append("CreateOn=@CreateOn,");
            strSql.Append("CreateUserId=@CreateUserId,");
            strSql.Append("CreateBy=@CreateBy,");
            strSql.Append("ModifiedOn=@ModifiedOn,");
            strSql.Append("ModifiedUserId=@ModifiedUserId,");
            strSql.Append("ModifiedBy=@ModifiedBy");
            strSql.Append(" where Id = @Id ");
            SqlParameter[] parameters = {
                    new SqlParameter("@Id", SqlDbType.Int),
                    new SqlParameter("@ParentId", SqlDbType.Int),
                    new SqlParameter("@Code", SqlDbType.NVarChar,100),
                    new SqlParameter("@FullName", SqlDbType.NVarChar,100),
                    new SqlParameter("@CategoryId", SqlDbType.NVarChar,50),
                    new SqlParameter("@NavigateUrl", SqlDbType.NVarChar,200),
                    new SqlParameter("@ImageIndex", SqlDbType.NVarChar,50),
                    new SqlParameter("@SelectedImageIndex", SqlDbType.NVarChar,50),
                    new SqlParameter("@Target", SqlDbType.NVarChar,100),
                    new SqlParameter("@SortCode", SqlDbType.Int),
                    new SqlParameter("@Enabled", SqlDbType.Int),
                    new SqlParameter("@DeletionStateCode", SqlDbType.Int),
                    new SqlParameter("@IsPublic", SqlDbType.Int),
                    new SqlParameter("@IsMenu", SqlDbType.Int),
                    new SqlParameter("@Expand", SqlDbType.Int),
                    new SqlParameter("@AllowEdit", SqlDbType.Int),
                    new SqlParameter("@AllowDelete", SqlDbType.Int),
                    new SqlParameter("@Description", SqlDbType.NVarChar,200),
                    new SqlParameter("@CreateOn", SqlDbType.SmallDateTime),
                    new SqlParameter("@CreateUserId", SqlDbType.NVarChar,50),
                    new SqlParameter("@CreateBy", SqlDbType.NVarChar,50),
                    new SqlParameter("@ModifiedOn", SqlDbType.SmallDateTime),
                    new SqlParameter("@ModifiedUserId", SqlDbType.NVarChar,50),
                    new SqlParameter("@ModifiedBy", SqlDbType.NVarChar,50)
                };
            parameters[0].Value = model.Id;
            parameters[1].Value = model.ParentId;
            parameters[2].Value = model.Code;
            parameters[3].Value = model.FullName;
            parameters[4].Value = model.CategoryId;
            parameters[5].Value = model.NavigateUrl;
            parameters[6].Value = model.ImageIndex;
            parameters[7].Value = model.SelectedImageIndex;
            parameters[8].Value = model.Target;
            parameters[9].Value = model.SortCode;
            parameters[10].Value = model.Enabled;
            parameters[11].Value = model.DeletionStateCode;
            parameters[12].Value = model.IsPublic;
            parameters[13].Value = model.IsMenu;
            parameters[14].Value = model.Expand;
            parameters[15].Value = model.AllowEdit;
            parameters[16].Value = model.AllowDelete;
            parameters[17].Value = model.Description;
            parameters[18].Value = model.CreateOn == string.Empty ? null : model.CreateOn;
            parameters[19].Value = model.CreateUserId;
            parameters[20].Value = model.CreateBy;
            parameters[21].Value = model.ModifiedOn == string.Empty ? null : model.ModifiedOn;
            parameters[22].Value = model.ModifiedUserId;
            parameters[23].Value = model.ModifiedBy;

            try
            {
                SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);
                ret = true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return ret;
        }
Пример #3
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 /// <param name="model">model</param>
 public bool ModifyRecord(Base_ModuleData model)
 {
     return this.ase_ModuleDB.ModifyRecord(model);
 }
Пример #4
0
        /// <summary>
        /// 得到一个model
        /// </summary>
        /// <param name="Id">主键值</param>
        /// <returns>model</returns>
        public Base_ModuleData GetModel(int Id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append(@"select Id,ParentId,Code,FullName,CategoryId,NavigateUrl,ImageIndex,SelectedImageIndex,Target,SortCode,Enabled,
                            DeletionStateCode,IsPublic,IsMenu,Expand,AllowEdit,AllowDelete,Description,CreateOn,CreateUserId,CreateBy,
                            ModifiedOn,ModifiedUserId,ModifiedBy from Base_Module");
            strSql.Append(" where Id = @Id ");
            SqlParameter[] parameters = {
                    new SqlParameter("@Id", SqlDbType.Int)
                };
            parameters[0].Value = Id;

            Base_ModuleData model = new Base_ModuleData();
            DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                DataRow row = ds.Tables[0].Rows[0];
                if (row["Id"] != DBNull.Value)
                {
                    model.Id = Convert.ToInt32(row["Id"]);
                }
                if (row["ParentId"] != DBNull.Value)
                {
                    model.ParentId = Convert.ToInt32(row["ParentId"]);
                }
                if (row["Code"] != DBNull.Value)
                {
                    model.Code = Convert.ToString(row["Code"]);
                }
                if (row["FullName"] != DBNull.Value)
                {
                    model.FullName = Convert.ToString(row["FullName"]);
                }
                if (row["CategoryId"] != DBNull.Value)
                {
                    model.CategoryId = Convert.ToString(row["CategoryId"]);
                }
                if (row["NavigateUrl"] != DBNull.Value)
                {
                    model.NavigateUrl = Convert.ToString(row["NavigateUrl"]);
                }
                if (row["ImageIndex"] != DBNull.Value)
                {
                    model.ImageIndex = Convert.ToString(row["ImageIndex"]);
                }
                if (row["SelectedImageIndex"] != DBNull.Value)
                {
                    model.SelectedImageIndex = Convert.ToString(row["SelectedImageIndex"]);
                }
                if (row["Target"] != DBNull.Value)
                {
                    model.Target = Convert.ToString(row["Target"]);
                }
                if (row["SortCode"] != DBNull.Value)
                {
                    model.SortCode = Convert.ToInt32(row["SortCode"]);
                }
                if (row["Enabled"] != DBNull.Value)
                {
                    model.Enabled = Convert.ToInt32(row["Enabled"]);
                }
                if (row["DeletionStateCode"] != DBNull.Value)
                {
                    model.DeletionStateCode = Convert.ToInt32(row["DeletionStateCode"]);
                }
                if (row["IsPublic"] != DBNull.Value)
                {
                    model.IsPublic = Convert.ToInt32(row["IsPublic"]);
                }
                if (row["IsMenu"] != DBNull.Value)
                {
                    model.IsMenu = Convert.ToInt32(row["IsMenu"]);
                }
                if (row["Expand"] != DBNull.Value)
                {
                    model.Expand = Convert.ToInt32(row["Expand"]);
                }
                if (row["AllowEdit"] != DBNull.Value)
                {
                    model.AllowEdit = Convert.ToInt32(row["AllowEdit"]);
                }
                if (row["AllowDelete"] != DBNull.Value)
                {
                    model.AllowDelete = Convert.ToInt32(row["AllowDelete"]);
                }
                if (row["Description"] != DBNull.Value)
                {
                    model.Description = Convert.ToString(row["Description"]);
                }
                if (row["CreateOn"] != DBNull.Value)
                {
                    model.CreateOn = Convert.ToString(row["CreateOn"]);
                }
                if (row["CreateUserId"] != DBNull.Value)
                {
                    model.CreateUserId = Convert.ToString(row["CreateUserId"]);
                }
                if (row["CreateBy"] != DBNull.Value)
                {
                    model.CreateBy = Convert.ToString(row["CreateBy"]);
                }
                if (row["ModifiedOn"] != DBNull.Value)
                {
                    model.ModifiedOn = Convert.ToString(row["ModifiedOn"]);
                }
                if (row["ModifiedUserId"] != DBNull.Value)
                {
                    model.ModifiedUserId = Convert.ToString(row["ModifiedUserId"]);
                }
                if (row["ModifiedBy"] != DBNull.Value)
                {
                    model.ModifiedBy = Convert.ToString(row["ModifiedBy"]);
                }
                return model;
            }
            else
            {
                return null;
            }
        }
Пример #5
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 /// <param name="model">model</param>
 public int AddRecord(Base_ModuleData model)
 {
     return this.ase_ModuleDB.AddRecord(model);
 }