/// <summary> /// 更新一条数据 /// </summary> public bool Update(DNSABC.Model.DNSABC_Log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update DNSABC_Log set "); strSql.Append("UserID=@UserID,"); strSql.Append("LogType=@LogType,"); strSql.Append("Content=@Content,"); strSql.Append("Operator=@Operator,"); strSql.Append("Ip=@Ip,"); strSql.Append("AdminID=@AdminID,"); strSql.Append("ObjectType=@ObjectType,"); strSql.Append("ObjectID=@ObjectID,"); strSql.Append("Remark=@Remark,"); strSql.Append("CreateTime=@CreateTime"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@LogType", SqlDbType.Int, 4), new SqlParameter("@Content", SqlDbType.VarChar, 500), new SqlParameter("@Operator", SqlDbType.VarChar, 50), new SqlParameter("@Ip", SqlDbType.VarChar, 20), new SqlParameter("@AdminID", SqlDbType.Int, 4), new SqlParameter("@ObjectType", SqlDbType.VarChar, 50), new SqlParameter("@ObjectID", SqlDbType.VarChar, 50), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.UserID; parameters[1].Value = model.LogType; parameters[2].Value = model.Content; parameters[3].Value = model.Operator; parameters[4].Value = model.Ip; parameters[5].Value = model.AdminID; parameters[6].Value = model.ObjectType; parameters[7].Value = model.ObjectID; parameters[8].Value = model.Remark; parameters[9].Value = model.CreateTime; parameters[10].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
private void ShowInfo(int Id) { DNSABC.BLL.DNSABC_Log bll = new DNSABC.BLL.DNSABC_Log(); DNSABC.Model.DNSABC_Log model = bll.GetModel(Id); this.lblId.Text = model.Id.ToString(); this.lblUserID.Text = model.UserID.ToString(); this.lblLogType.Text = model.LogType.ToString(); this.lblContent.Text = model.Content; this.lblOperator.Text = model.Operator; this.lblIp.Text = model.Ip; this.lblAdminID.Text = model.AdminID.ToString(); this.lblObjectType.Text = model.ObjectType; this.lblObjectID.Text = model.ObjectID; this.lblRemark.Text = model.Remark; this.lblCreateTime.Text = model.CreateTime.ToString(); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(DNSABC.Model.DNSABC_Log model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into DNSABC_Log("); strSql.Append("UserID,LogType,Content,Operator,Ip,AdminID,ObjectType,ObjectID,Remark,CreateTime)"); strSql.Append(" values ("); strSql.Append("@UserID,@LogType,@Content,@Operator,@Ip,@AdminID,@ObjectType,@ObjectID,@Remark,@CreateTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@LogType", SqlDbType.Int, 4), new SqlParameter("@Content", SqlDbType.VarChar, 500), new SqlParameter("@Operator", SqlDbType.VarChar, 50), new SqlParameter("@Ip", SqlDbType.VarChar, 20), new SqlParameter("@AdminID", SqlDbType.Int, 4), new SqlParameter("@ObjectType", SqlDbType.VarChar, 50), new SqlParameter("@ObjectID", SqlDbType.VarChar, 50), new SqlParameter("@Remark", SqlDbType.VarChar, 500), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.UserID; parameters[1].Value = model.LogType; parameters[2].Value = model.Content; parameters[3].Value = model.Operator; parameters[4].Value = model.Ip; parameters[5].Value = model.AdminID; parameters[6].Value = model.ObjectType; parameters[7].Value = model.ObjectID; parameters[8].Value = model.Remark; parameters[9].Value = model.CreateTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtUserID.Text)) { strErr += "用户ID格式错误!\\n"; } if (!PageValidate.IsNumber(txtLogType.Text)) { strErr += "日志类型格式错误!\\n"; } if (this.txtContent.Text.Trim().Length == 0) { strErr += "内容不能为空!\\n"; } if (this.txtOperator.Text.Trim().Length == 0) { strErr += "操作人不能为空!\\n"; } if (this.txtIp.Text.Trim().Length == 0) { strErr += "操作IP 考虑反向代理的情况不能为空!\\n"; } if (!PageValidate.IsNumber(txtAdminID.Text)) { strErr += "【管理员字段】管理员ID格式错误!\\n"; } if (this.txtObjectType.Text.Trim().Length == 0) { strErr += "业务编码【管理员字段】不能为空!\\n"; } if (this.txtObjectID.Text.Trim().Length == 0) { strErr += "业务标识【管理员字段】不能为空!\\n"; } if (this.txtRemark.Text.Trim().Length == 0) { strErr += "备注【管理员字段】不能为空!\\n"; } if (!PageValidate.IsDateTime(txtCreateTime.Text)) { strErr += "操作时间格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int UserID = int.Parse(this.txtUserID.Text); int LogType = int.Parse(this.txtLogType.Text); string Content = this.txtContent.Text; string Operator = this.txtOperator.Text; string Ip = this.txtIp.Text; int AdminID = int.Parse(this.txtAdminID.Text); string ObjectType = this.txtObjectType.Text; string ObjectID = this.txtObjectID.Text; string Remark = this.txtRemark.Text; DateTime CreateTime = DateTime.Parse(this.txtCreateTime.Text); DNSABC.Model.DNSABC_Log model = new DNSABC.Model.DNSABC_Log(); model.UserID = UserID; model.LogType = LogType; model.Content = Content; model.Operator = Operator; model.Ip = Ip; model.AdminID = AdminID; model.ObjectType = ObjectType; model.ObjectID = ObjectID; model.Remark = Remark; model.CreateTime = CreateTime; DNSABC.BLL.DNSABC_Log bll = new DNSABC.BLL.DNSABC_Log(); bll.Add(model); ROYcms.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public DNSABC.Model.DNSABC_Log GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,UserID,LogType,Content,Operator,Ip,AdminID,ObjectType,ObjectID,Remark,CreateTime from DNSABC_Log "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; DNSABC.Model.DNSABC_Log model = new DNSABC.Model.DNSABC_Log(); 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]["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]["LogType"] != null && ds.Tables[0].Rows[0]["LogType"].ToString() != "") { model.LogType = int.Parse(ds.Tables[0].Rows[0]["LogType"].ToString()); } if (ds.Tables[0].Rows[0]["Content"] != null && ds.Tables[0].Rows[0]["Content"].ToString() != "") { model.Content = ds.Tables[0].Rows[0]["Content"].ToString(); } if (ds.Tables[0].Rows[0]["Operator"] != null && ds.Tables[0].Rows[0]["Operator"].ToString() != "") { model.Operator = ds.Tables[0].Rows[0]["Operator"].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]["AdminID"] != null && ds.Tables[0].Rows[0]["AdminID"].ToString() != "") { model.AdminID = int.Parse(ds.Tables[0].Rows[0]["AdminID"].ToString()); } if (ds.Tables[0].Rows[0]["ObjectType"] != null && ds.Tables[0].Rows[0]["ObjectType"].ToString() != "") { model.ObjectType = ds.Tables[0].Rows[0]["ObjectType"].ToString(); } if (ds.Tables[0].Rows[0]["ObjectID"] != null && ds.Tables[0].Rows[0]["ObjectID"].ToString() != "") { model.ObjectID = ds.Tables[0].Rows[0]["ObjectID"].ToString(); } if (ds.Tables[0].Rows[0]["Remark"] != null && ds.Tables[0].Rows[0]["Remark"].ToString() != "") { model.Remark = ds.Tables[0].Rows[0]["Remark"].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); } }