protected void buttonOK_Click(object sender, EventArgs e) { if (CheckInput()) { try { var bulletin = new saBulletinTypeInfo(); bulletin.sName = this.txtName.Text.Trim(); bulletin.iSort = int.Parse(this.txtSort.Text.Trim()); bulletin.bUsable = !this.cbxIsActive.Checked; if (this.IsModifyAction) { int id; int.TryParse(Request["iIden"], out id); bulletin.iIden = id; saBulletinType.Current.UpdateBulletinType(bulletin); Response.Clear(); ClientScript.RegisterStartupScript(this.GetType(), string.Empty, "<script type=\"text/javascript\">alert('{0}');location.href='BulletinTypeManage.aspx';</script>".FormatEx(Resources.GlobalResources.ModifiedSuccess)); } else { bulletin.iIden = IdenGenerator.Current.NewIden(saBulletinTypeInfo.sTableName); bulletin.bUsable = true; bulletin.iCreator = this.iUserID; saBulletinType.Current.CreateBulletinType(bulletin); Response.Clear(); ClientScript.RegisterStartupScript(this.GetType(), string.Empty, "<script type=\"text/javascript\">alert('{0}');location.href='BulletinTypeManage.aspx';</script>".FormatEx(Resources.GlobalResources.AddedSuccess)); } } catch (Exception ex) { hasError = true; errorMsg = ex.Message; } } else { hasError = true; } }
public void Update(saBulletinTypeInfo saBulletinType) { string errMessage = string.Empty; if (!CheckUQ.CheckUqBeforeUpdate(saBulletinTypeInfo.sTableName, saBulletinType, out errMessage)) throw new Exception(errMessage); StringBuilder strSql = new StringBuilder(); strSql.Append("update saBulletinType set "); strSql.Append("sName=@sName,"); strSql.Append("bUsable=@bUsable,"); strSql.Append("iSort=@iSort"); strSql.Append(" where iIden=@iIden "); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "iIden", DbType.Int32, saBulletinType.iIden); db.AddInParameter(dbCommand, "sName", DbType.String, saBulletinType.sName); db.AddInParameter(dbCommand, "iSort", DbType.Int32, saBulletinType.iSort); db.AddInParameter(dbCommand, "bUsable", DbType.Boolean, saBulletinType.bUsable); db.ExecuteNonQuery(dbCommand); }
public void Create(saBulletinTypeInfo saBulletinType) { string errMessage = string.Empty; if (!CheckUQ.CheckUqBeforeInsert(saBulletinTypeInfo.sTableName, saBulletinType, out errMessage)) throw new Exception(errMessage); StringBuilder strSql = new StringBuilder(); strSql.Append("insert into saBulletinType("); strSql.Append("iIden,sName,iSort,bUsable)"); strSql.Append(" values ("); strSql.Append("@iIden,@sName,@iSort,@bUsable)"); Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()); db.AddInParameter(dbCommand, "iIden", DbType.Int32, saBulletinType.iIden); db.AddInParameter(dbCommand, "sName", DbType.String, saBulletinType.sName); db.AddInParameter(dbCommand, "iSort", DbType.Int32, saBulletinType.iSort); db.AddInParameter(dbCommand, "bUsable", DbType.Boolean, saBulletinType.bUsable); db.ExecuteScalar(dbCommand); }
/// <summary> /// 对象实体绑定数据 /// </summary> private static myPortal.Model.saBulletinTypeInfo ReaderBind(IDataReader dataReader) { myPortal.Model.saBulletinTypeInfo model = new myPortal.Model.saBulletinTypeInfo(); object ojb; ojb = dataReader["iIden"]; if (ojb != null && ojb != DBNull.Value) { model.iIden = (int)ojb; } model.sName = dataReader["sName"].ToString(); ojb = dataReader["iSort"]; if (ojb != null && ojb != DBNull.Value) { model.iSort = (int)ojb; } ojb = dataReader["bUsable"]; if (ojb != null && ojb != DBNull.Value) { model.bUsable = (bool)ojb; } return model; }
public void CreateBulletinType(saBulletinTypeInfo bulletin) { dal.Create(bulletin); CacheService.Current.RemoveObject(CacheKey.DicBulletinType); }