/// <summary> /// 加载平台信息 /// </summary> private void LoadPlatform() { ChannelMO _mo = new ChannelMO(); ChannelEO _eo = _mo.GetByPK(Request.QueryString["Chid"].ToString()); if (!string.IsNullOrEmpty(_eo.CnName)) { this.txtChannelName.Text = _eo.CnName; this.txtChannelId.Text = _eo.CnChannelId; this.txtDescription.Text = _eo.CnDescription; this.rblState.SelectedValue = _eo.CnState; } }
/// <summary> /// 更新数据 /// </summary> /// <param name = "item">要更新的实体对象</param> /// <param name="tm">事务管理对象</param> /// <return>受影响的行数</return> public virtual int PutById(ChannelEO item, TransactionManager tm = null) { const string sql = @"UPDATE channel SET Cn_channelId=@Cn_channelId, Cn_name=@Cn_name, Cn_description=@Cn_description, Ur_id=@Ur_id, Cn_addTime=@Cn_addTime, Cn_state=@Cn_state, Cn_Del=@Cn_Del, Cn_text1=@Cn_text1, Cn_text2=@Cn_text2 WHERE Cn_id=@Cn_id"; return(Database.CreateSqlDao(sql) .AddInParameter("@Cn_channelId", item.CnChannelId != null ? (object)item.CnChannelId : DBNull.Value, DbType.String, 50) .AddInParameter("@Cn_name", item.CnName != null ? (object)item.CnName : DBNull.Value, DbType.String, 50) .AddInParameter("@Cn_description", item.CnDescription != null ? (object)item.CnDescription : DBNull.Value, DbType.String, -1) .AddInParameter("@Ur_id", item.UrId != null ? (object)item.UrId : DBNull.Value, DbType.String, 50) .AddInParameter("@Cn_addTime", item.CnAddTime.HasValue ? (object)item.CnAddTime.Value : DBNull.Value, DbType.Date, 3) .AddInParameter("@Cn_state", item.CnState != null ? (object)item.CnState : DBNull.Value, DbType.AnsiStringFixedLength, 1) .AddInParameter("@Cn_Del", item.CnDel != null ? (object)item.CnDel : DBNull.Value, DbType.AnsiStringFixedLength, 1) .AddInParameter("@Cn_text1", item.CnText1 != null ? (object)item.CnText1 : DBNull.Value, DbType.String, 200) .AddInParameter("@Cn_text2", item.CnText2 != null ? (object)item.CnText2 : DBNull.Value, DbType.String, 200) .AddInParameter("@Cn_id", item.CnId, DbType.String, 50) .ExecNonQuery(tm)); }
/// <summary> /// 新增、修改信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnOK_Click(object sender, EventArgs e) { if (this.CheckForm() == false) { CloseDivImplementation(); return; } ChannelEO _eo = new ChannelEO(); _eo.CnName = txtChannelName.Text; _eo.CnChannelId = txtChannelId.Text; _eo.CnDel = "0"; _eo.CnDescription = txtDescription.Text; _eo.CnState = rblState.Text; _eo.UrId = GetUserID(); _eo.CnAddTime = DateTime.Now; //创建平台信息 if (Request.QueryString["State"] == "A") { //判断平台名称是否存在 if (this.CheckChannelID() == false) { this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.Channe_lID + this.txtChannelId.Text.Trim() + Resources.Resource.Already_exist; CloseDivImplementation(); return; } _eo.CnId = GetBigGuid(); if (_mo.Add(_eo) > 0) { //插入操作日志 InsertLog(Resources.Resource.Create_channel_information, string.Format("Cn_name:{0},Cn_channelId:{1}", _eo.CnName, _eo.CnId), -6, GetPlatformIdByValue(1)); CloseDivImplementation(); Jswork.Alert(Resources.Resource.Channel_information_to_create_success, "ChannelList.aspx"); } else { this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.Create_channel_information_creation_failed;//"创建渠信息创建失败"; } } //修改平台信息 if (Request.QueryString["State"] == "U") { //判断平台名称是否存在 if (this.CheckChannelID() == false) { //Jswork.Alert("平台名称 " + this.txtPfname.Text.Trim() + " 已存在", this.Page); this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.Channe_lID + this.txtChannelId.Text.Trim() + Resources.Resource.Already_exist; CloseDivImplementation(); return; } _eo.CnId = Request.QueryString["Chid"].ToString(); if (_mo.PutById(_eo) > 0) { //插入操作日志 InsertLog(Resources.Resource.Modify_channel_information, string.Format("CnId:{0},CnChannelId:{1}", _eo.CnId, _eo.CnChannelId), 5008, GetPlatformIdByValue(1)); CloseDivImplementation(); Jswork.Alert(Resources.Resource.Channel_information_to_modify_the_success_of, "ChannelList.aspx"); } else { this.divAlert.Visible = true; this.lblAlert.Text = Resources.Resource.Channel_information_modification_failed; //"渠道信息修改失败"; } } CloseDivImplementation(); }