コード例 #1
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Bsam.Core.Model.Models.Model.Role model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Role set ");
            strSql.Append("IsDeleted=@IsDeleted,");
            strSql.Append("Name=@Name,");
            strSql.Append("Description=@Description,");
            strSql.Append("OrderSort=@OrderSort,");
            strSql.Append("Enabled=@Enabled,");
            strSql.Append("CreateId=@CreateId,");
            strSql.Append("CreateBy=@CreateBy,");
            strSql.Append("CreateTime=@CreateTime,");
            strSql.Append("ModifyId=@ModifyId,");
            strSql.Append("ModifyBy=@ModifyBy,");
            strSql.Append("ModifyTime=@ModifyTime");
            strSql.Append(" where Id=@Id");
            SQLiteParameter[] parameters =
            {
                new SQLiteParameter("@IsDeleted",   DbType.bit,         1),
                new SQLiteParameter("@Name",        DbType.String),
                new SQLiteParameter("@Description", DbType.String),
                new SQLiteParameter("@OrderSort",   DbType.Int32,       8),
                new SQLiteParameter("@Enabled",     DbType.bit,         1),
                new SQLiteParameter("@CreateId",    DbType.Int32,       8),
                new SQLiteParameter("@CreateBy",    DbType.String),
                new SQLiteParameter("@CreateTime",  DbType.DateTime),
                new SQLiteParameter("@ModifyId",    DbType.Int32,       8),
                new SQLiteParameter("@ModifyBy",    DbType.String,    255),
                new SQLiteParameter("@ModifyTime",  DbType.DateTime),
                new SQLiteParameter("@Id",          DbType.Int32, 8)
            };
            parameters[0].Value  = model.IsDeleted;
            parameters[1].Value  = model.Name;
            parameters[2].Value  = model.Description;
            parameters[3].Value  = model.OrderSort;
            parameters[4].Value  = model.Enabled;
            parameters[5].Value  = model.CreateId;
            parameters[6].Value  = model.CreateBy;
            parameters[7].Value  = model.CreateTime;
            parameters[8].Value  = model.ModifyId;
            parameters[9].Value  = model.ModifyBy;
            parameters[10].Value = model.ModifyTime;
            parameters[11].Value = model.Id;

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

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
コード例 #2
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(Bsam.Core.Model.Models.Model.Role model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Role(");
            strSql.Append("IsDeleted,Name,Description,OrderSort,Enabled,CreateId,CreateBy,CreateTime,ModifyId,ModifyBy,ModifyTime)");
            strSql.Append(" values (");
            strSql.Append("@IsDeleted,@Name,@Description,@OrderSort,@Enabled,@CreateId,@CreateBy,@CreateTime,@ModifyId,@ModifyBy,@ModifyTime)");
            strSql.Append(";select LAST_INSERT_ROWID()");
            SQLiteParameter[] parameters =
            {
                new SQLiteParameter("@IsDeleted",   DbType.bit,         1),
                new SQLiteParameter("@Name",        DbType.String),
                new SQLiteParameter("@Description", DbType.String),
                new SQLiteParameter("@OrderSort",   DbType.Int32,       8),
                new SQLiteParameter("@Enabled",     DbType.bit,         1),
                new SQLiteParameter("@CreateId",    DbType.Int32,       8),
                new SQLiteParameter("@CreateBy",    DbType.String),
                new SQLiteParameter("@CreateTime",  DbType.DateTime),
                new SQLiteParameter("@ModifyId",    DbType.Int32,       8),
                new SQLiteParameter("@ModifyBy",    DbType.String,    255),
                new SQLiteParameter("@ModifyTime",  DbType.DateTime)
            };
            parameters[0].Value  = model.IsDeleted;
            parameters[1].Value  = model.Name;
            parameters[2].Value  = model.Description;
            parameters[3].Value  = model.OrderSort;
            parameters[4].Value  = model.Enabled;
            parameters[5].Value  = model.CreateId;
            parameters[6].Value  = model.CreateBy;
            parameters[7].Value  = model.CreateTime;
            parameters[8].Value  = model.ModifyId;
            parameters[9].Value  = model.ModifyBy;
            parameters[10].Value = model.ModifyTime;

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

            if (obj == null)
            {
                return(0);
            }
            else
            {
                return(Convert.ToInt32(obj));
            }
        }
コード例 #3
0
 private void ShowInfo(int Id)
 {
     Bsam.Core.Model.Models.BLL.Role   bll   = new Bsam.Core.Model.Models.BLL.Role();
     Bsam.Core.Model.Models.Model.Role model = bll.GetModel(Id);
     this.lblId.Text           = model.Id.ToString();
     this.chkIsDeleted.Checked = model.IsDeleted;
     this.txtName.Text         = model.Name;
     this.txtDescription.Text  = model.Description;
     this.txtOrderSort.Text    = model.OrderSort.ToString();
     this.chkEnabled.Checked   = model.Enabled;
     this.txtCreateId.Text     = model.CreateId.ToString();
     this.txtCreateBy.Text     = model.CreateBy;
     this.txtCreateTime.Text   = model.CreateTime.ToString();
     this.txtModifyId.Text     = model.ModifyId.ToString();
     this.txtModifyBy.Text     = model.ModifyBy;
     this.txtModifyTime.Text   = model.ModifyTime.ToString();
 }
コード例 #4
0
 private void ShowInfo(int Id)
 {
     Bsam.Core.Model.Models.BLL.Role   bll   = new Bsam.Core.Model.Models.BLL.Role();
     Bsam.Core.Model.Models.Model.Role model = bll.GetModel(Id);
     this.lblId.Text          = model.Id.ToString();
     this.lblIsDeleted.Text   = model.IsDeleted?"是":"否";
     this.lblName.Text        = model.Name;
     this.lblDescription.Text = model.Description;
     this.lblOrderSort.Text   = model.OrderSort.ToString();
     this.lblEnabled.Text     = model.Enabled?"是":"否";
     this.lblCreateId.Text    = model.CreateId.ToString();
     this.lblCreateBy.Text    = model.CreateBy;
     this.lblCreateTime.Text  = model.CreateTime.ToString();
     this.lblModifyId.Text    = model.ModifyId.ToString();
     this.lblModifyBy.Text    = model.ModifyBy;
     this.lblModifyTime.Text  = model.ModifyTime.ToString();
 }
コード例 #5
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Bsam.Core.Model.Models.Model.Role GetModel(int Id)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select Id,IsDeleted,Name,Description,OrderSort,Enabled,CreateId,CreateBy,CreateTime,ModifyId,ModifyBy,ModifyTime from Role ");
            strSql.Append(" where Id=@Id");
            SQLiteParameter[] parameters =
            {
                new SQLiteParameter("@Id", DbType.Int32, 4)
            };
            parameters[0].Value = Id;

            Bsam.Core.Model.Models.Model.Role model = new Bsam.Core.Model.Models.Model.Role();
            DataSet ds = DbHelperSQLite.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
コード例 #6
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Bsam.Core.Model.Models.Model.Role DataRowToModel(DataRow row)
 {
     Bsam.Core.Model.Models.Model.Role model = new Bsam.Core.Model.Models.Model.Role();
     if (row != null)
     {
         if (row["Id"] != null && row["Id"].ToString() != "")
         {
             model.Id = int.Parse(row["Id"].ToString());
         }
         if (row["IsDeleted"] != null && row["IsDeleted"].ToString() != "")
         {
             if ((row["IsDeleted"].ToString() == "1") || (row["IsDeleted"].ToString().ToLower() == "true"))
             {
                 model.IsDeleted = true;
             }
             else
             {
                 model.IsDeleted = false;
             }
         }
         if (row["Name"] != null)
         {
             model.Name = row["Name"].ToString();
         }
         if (row["Description"] != null)
         {
             model.Description = row["Description"].ToString();
         }
         if (row["OrderSort"] != null && row["OrderSort"].ToString() != "")
         {
             model.OrderSort = int.Parse(row["OrderSort"].ToString());
         }
         if (row["Enabled"] != null && row["Enabled"].ToString() != "")
         {
             if ((row["Enabled"].ToString() == "1") || (row["Enabled"].ToString().ToLower() == "true"))
             {
                 model.Enabled = true;
             }
             else
             {
                 model.Enabled = false;
             }
         }
         if (row["CreateId"] != null && row["CreateId"].ToString() != "")
         {
             model.CreateId = int.Parse(row["CreateId"].ToString());
         }
         if (row["CreateBy"] != null)
         {
             model.CreateBy = row["CreateBy"].ToString();
         }
         if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
         {
             model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
         }
         if (row["ModifyId"] != null && row["ModifyId"].ToString() != "")
         {
             model.ModifyId = int.Parse(row["ModifyId"].ToString());
         }
         if (row["ModifyBy"] != null)
         {
             model.ModifyBy = row["ModifyBy"].ToString();
         }
         if (row["ModifyTime"] != null && row["ModifyTime"].ToString() != "")
         {
             model.ModifyTime = DateTime.Parse(row["ModifyTime"].ToString());
         }
     }
     return(model);
 }
コード例 #7
0
        public void btnSave_Click(object sender, EventArgs e)
        {
            string strErr = "";

            if (this.txtName.Text.Trim().Length == 0)
            {
                strErr += "Name不能为空!\\n";
            }
            if (this.txtDescription.Text.Trim().Length == 0)
            {
                strErr += "Description不能为空!\\n";
            }
            if (!PageValidate.IsNumber(txtOrderSort.Text))
            {
                strErr += "OrderSort格式错误!\\n";
            }
            if (!PageValidate.IsNumber(txtCreateId.Text))
            {
                strErr += "CreateId格式错误!\\n";
            }
            if (this.txtCreateBy.Text.Trim().Length == 0)
            {
                strErr += "CreateBy不能为空!\\n";
            }
            if (!PageValidate.IsDateTime(txtCreateTime.Text))
            {
                strErr += "CreateTime格式错误!\\n";
            }
            if (!PageValidate.IsNumber(txtModifyId.Text))
            {
                strErr += "ModifyId格式错误!\\n";
            }
            if (this.txtModifyBy.Text.Trim().Length == 0)
            {
                strErr += "ModifyBy不能为空!\\n";
            }
            if (!PageValidate.IsDateTime(txtModifyTime.Text))
            {
                strErr += "ModifyTime格式错误!\\n";
            }

            if (strErr != "")
            {
                MessageBox.Show(this, strErr);
                return;
            }
            int      Id          = int.Parse(this.lblId.Text);
            bool     IsDeleted   = this.chkIsDeleted.Checked;
            string   Name        = this.txtName.Text;
            string   Description = this.txtDescription.Text;
            int      OrderSort   = int.Parse(this.txtOrderSort.Text);
            bool     Enabled     = this.chkEnabled.Checked;
            int      CreateId    = int.Parse(this.txtCreateId.Text);
            string   CreateBy    = this.txtCreateBy.Text;
            DateTime CreateTime  = DateTime.Parse(this.txtCreateTime.Text);
            int      ModifyId    = int.Parse(this.txtModifyId.Text);
            string   ModifyBy    = this.txtModifyBy.Text;
            DateTime ModifyTime  = DateTime.Parse(this.txtModifyTime.Text);


            Bsam.Core.Model.Models.Model.Role model = new Bsam.Core.Model.Models.Model.Role();
            model.Id          = Id;
            model.IsDeleted   = IsDeleted;
            model.Name        = Name;
            model.Description = Description;
            model.OrderSort   = OrderSort;
            model.Enabled     = Enabled;
            model.CreateId    = CreateId;
            model.CreateBy    = CreateBy;
            model.CreateTime  = CreateTime;
            model.ModifyId    = ModifyId;
            model.ModifyBy    = ModifyBy;
            model.ModifyTime  = ModifyTime;

            Bsam.Core.Model.Models.BLL.Role bll = new Bsam.Core.Model.Models.BLL.Role();
            bll.Update(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx");
        }