/// <summary> /// 得到一个对象实体 /// </summary> public DNSABC.Model.DNSABC_Messages GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,MessagesTypeID,UserID,Title,Contents,IP,State,UpdateTime,CreateTime from DNSABC_Messages "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; DNSABC.Model.DNSABC_Messages model = new DNSABC.Model.DNSABC_Messages(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["MessagesTypeID"] != null && ds.Tables[0].Rows[0]["MessagesTypeID"].ToString() != "") { model.MessagesTypeID = int.Parse(ds.Tables[0].Rows[0]["MessagesTypeID"].ToString()); } if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } if (ds.Tables[0].Rows[0]["Title"] != null && ds.Tables[0].Rows[0]["Title"].ToString() != "") { model.Title = ds.Tables[0].Rows[0]["Title"].ToString(); } if (ds.Tables[0].Rows[0]["Contents"] != null && ds.Tables[0].Rows[0]["Contents"].ToString() != "") { model.Contents = ds.Tables[0].Rows[0]["Contents"].ToString(); } if (ds.Tables[0].Rows[0]["IP"] != null && ds.Tables[0].Rows[0]["IP"].ToString() != "") { model.IP = ds.Tables[0].Rows[0]["IP"].ToString(); } if (ds.Tables[0].Rows[0]["State"] != null && ds.Tables[0].Rows[0]["State"].ToString() != "") { model.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString()); } if (ds.Tables[0].Rows[0]["UpdateTime"] != null && ds.Tables[0].Rows[0]["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateTime"].ToString()); } if (ds.Tables[0].Rows[0]["CreateTime"] != null && ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } return(model); } else { return(null); } }
private void ShowInfo(int Id) { DNSABC.BLL.DNSABC_Messages bll = new DNSABC.BLL.DNSABC_Messages(); DNSABC.Model.DNSABC_Messages model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.lblMessagesTypeID.Text = model.MessagesTypeID.ToString(); this.lblUserID.Text = model.UserID.ToString(); this.lblTitle.Text = model.Title; this.lblContents.Text = model.Contents; this.lblIP.Text = model.IP; this.lblState.Text = model.State.ToString(); this.lblUpdateTime.Text = model.UpdateTime.ToString(); this.lblCreateTime.Text = model.CreateTime.ToString(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DNSABC.Model.DNSABC_Messages model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DNSABC_Messages set "); strSql.Append("MessagesTypeID=@MessagesTypeID,"); strSql.Append("UserID=@UserID,"); strSql.Append("Title=@Title,"); strSql.Append("Contents=@Contents,"); strSql.Append("IP=@IP,"); strSql.Append("State=@State,"); strSql.Append("UpdateTime=@UpdateTime,"); strSql.Append("CreateTime=@CreateTime"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@MessagesTypeID", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.VarChar, 200), new SqlParameter("@Contents", SqlDbType.VarChar, 8000), new SqlParameter("@IP", SqlDbType.VarChar, 20), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.MessagesTypeID; parameters[1].Value = model.UserID; parameters[2].Value = model.Title; parameters[3].Value = model.Contents; parameters[4].Value = model.IP; parameters[5].Value = model.State; parameters[6].Value = model.UpdateTime; parameters[7].Value = model.CreateTime; parameters[8].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(DNSABC.Model.DNSABC_Messages model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DNSABC_Messages("); strSql.Append("Id,MessagesTypeID,UserID,Title,Contents,IP,State,UpdateTime,CreateTime)"); strSql.Append(" values ("); strSql.Append("@Id,@MessagesTypeID,@UserID,@Title,@Contents,@IP,@State,@UpdateTime,@CreateTime)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@MessagesTypeID", SqlDbType.Int, 4), new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.VarChar, 200), new SqlParameter("@Contents", SqlDbType.VarChar, 8000), new SqlParameter("@IP", SqlDbType.VarChar, 20), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.Id; parameters[1].Value = model.MessagesTypeID; parameters[2].Value = model.UserID; parameters[3].Value = model.Title; parameters[4].Value = model.Contents; parameters[5].Value = model.IP; parameters[6].Value = model.State; parameters[7].Value = model.UpdateTime; parameters[8].Value = model.CreateTime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtId.Text)) { strErr += "编号格式错误!\\n"; } if (!PageValidate.IsNumber(txtMessagesTypeID.Text)) { strErr += "处理类型ID 系统配置参数格式错误!\\n"; } if (!PageValidate.IsNumber(txtUserID.Text)) { strErr += "用户ID格式错误!\\n"; } if (this.txtTitle.Text.Trim().Length == 0) { strErr += "标题不能为空!\\n"; } if (this.txtContents.Text.Trim().Length == 0) { strErr += "内容不能为空!\\n"; } if (this.txtIP.Text.Trim().Length == 0) { strErr += "IP地址不能为空!\\n"; } if (!PageValidate.IsNumber(txtState.Text)) { strErr += "状态 0为处理中 1为关闭格式错误!\\n"; } if (!PageValidate.IsDateTime(txtUpdateTime.Text)) { strErr += "更新时间格式错误!\\n"; } if (!PageValidate.IsDateTime(txtCreateTime.Text)) { strErr += "发布时间格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int Id = int.Parse(this.txtId.Text); int MessagesTypeID = int.Parse(this.txtMessagesTypeID.Text); int UserID = int.Parse(this.txtUserID.Text); string Title = this.txtTitle.Text; string Contents = this.txtContents.Text; string IP = this.txtIP.Text; int State = int.Parse(this.txtState.Text); DateTime UpdateTime = DateTime.Parse(this.txtUpdateTime.Text); DateTime CreateTime = DateTime.Parse(this.txtCreateTime.Text); DNSABC.Model.DNSABC_Messages model = new DNSABC.Model.DNSABC_Messages(); model.Id = Id; model.MessagesTypeID = MessagesTypeID; model.UserID = UserID; model.Title = Title; model.Contents = Contents; model.IP = IP; model.State = State; model.UpdateTime = UpdateTime; model.CreateTime = CreateTime; DNSABC.BLL.DNSABC_Messages bll = new DNSABC.BLL.DNSABC_Messages(); bll.Add(model); ROYcms.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }