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);
}
