public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtLogTitle.Text.Trim().Length == 0) { strErr += "LogTitle不能为空!\\n"; } if (this.txtLogType.Text.Trim().Length == 0) { strErr += "LogType不能为空!\\n"; } if (!PageValidate.IsDateTime(txtLogDate.Text)) { strErr += "LogDate格式错误!\\n"; } if (this.txtLogMemo.Text.Trim().Length == 0) { strErr += "LogMemo不能为空!\\n"; } if (this.txtLogData.Text.Trim().Length == 0) { strErr += "LogData不能为空!\\n"; } if (this.txtLogOperator.Text.Trim().Length == 0) { strErr += "LogOperator不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int LogID = int.Parse(this.lblLogID.Text); string LogTitle = this.txtLogTitle.Text; string LogType = this.txtLogType.Text; DateTime LogDate = DateTime.Parse(this.txtLogDate.Text); string LogMemo = this.txtLogMemo.Text; string LogData = this.txtLogData.Text; string LogOperator = this.txtLogOperator.Text; WebDemo.Model.WebDemo.LogData model = new WebDemo.Model.WebDemo.LogData(); model.LogID = LogID; model.LogTitle = LogTitle; model.LogType = LogType; model.LogDate = LogDate; model.LogMemo = LogMemo; model.LogData = LogData; model.LogOperator = LogOperator; WebDemo.BLL.WebDemo.LogData bll = new WebDemo.BLL.WebDemo.LogData(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
private void ShowInfo(int LogID) { WebDemo.BLL.WebDemo.LogData bll = new WebDemo.BLL.WebDemo.LogData(); WebDemo.Model.WebDemo.LogData model = bll.GetModel(LogID); this.lblLogID.Text = model.LogID.ToString(); this.txtLogTitle.Text = model.LogTitle; this.txtLogType.Text = model.LogType; this.txtLogDate.Text = model.LogDate.ToString(); this.txtLogMemo.Text = model.LogMemo; this.txtLogData.Text = model.LogData; this.txtLogOperator.Text = model.LogOperator; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.LogData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LogData set "); strSql.Append("LogTitle=@LogTitle,"); strSql.Append("LogType=@LogType,"); strSql.Append("LogDate=@LogDate,"); strSql.Append("LogMemo=@LogMemo,"); strSql.Append("LogData=@LogData,"); strSql.Append("LogOperator=@LogOperator"); strSql.Append(" where LogID=@LogID"); SqlParameter[] parameters = { new SqlParameter("@LogTitle", SqlDbType.VarChar, 200), new SqlParameter("@LogType", SqlDbType.VarChar, 50), new SqlParameter("@LogDate", SqlDbType.DateTime), new SqlParameter("@LogMemo", SqlDbType.VarChar, 5000), new SqlParameter("@LogData", SqlDbType.VarChar, 5000), new SqlParameter("@LogOperator", SqlDbType.VarChar, 100), new SqlParameter("@LogID", SqlDbType.Int, 4) }; parameters[0].Value = model.LogTitle; parameters[1].Value = model.LogType; parameters[2].Value = model.LogDate; parameters[3].Value = model.LogMemo; parameters[4].Value = model.LogData; parameters[5].Value = model.LogOperator; parameters[6].Value = model.LogID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(WebDemo.Model.WebDemo.LogData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LogData("); strSql.Append("LogTitle,LogType,LogDate,LogMemo,LogData,LogOperator)"); strSql.Append(" values ("); strSql.Append("@LogTitle,@LogType,@LogDate,@LogMemo,@LogData,@LogOperator)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@LogTitle", SqlDbType.VarChar, 200), new SqlParameter("@LogType", SqlDbType.VarChar, 50), new SqlParameter("@LogDate", SqlDbType.DateTime), new SqlParameter("@LogMemo", SqlDbType.VarChar, 5000), new SqlParameter("@LogData", SqlDbType.VarChar, 5000), new SqlParameter("@LogOperator", SqlDbType.VarChar, 100) }; parameters[0].Value = model.LogTitle; parameters[1].Value = model.LogType; parameters[2].Value = model.LogDate; parameters[3].Value = model.LogMemo; parameters[4].Value = model.LogData; parameters[5].Value = model.LogOperator; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.LogData DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.LogData model = new WebDemo.Model.WebDemo.LogData(); if (row != null) { if (row["LogID"] != null && row["LogID"].ToString() != "") { model.LogID = int.Parse(row["LogID"].ToString()); } if (row["LogTitle"] != null) { model.LogTitle = row["LogTitle"].ToString(); } if (row["LogType"] != null) { model.LogType = row["LogType"].ToString(); } if (row["LogDate"] != null && row["LogDate"].ToString() != "") { model.LogDate = DateTime.Parse(row["LogDate"].ToString()); } if (row["LogMemo"] != null) { model.LogMemo = row["LogMemo"].ToString(); } if (row["LogData"] != null) { model.LogData = row["LogData"].ToString(); } if (row["LogOperator"] != null) { model.LogOperator = row["LogOperator"].ToString(); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.LogData GetModel(int LogID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 LogID,LogTitle,LogType,LogDate,LogMemo,LogData,LogOperator from LogData "); strSql.Append(" where LogID=@LogID"); SqlParameter[] parameters = { new SqlParameter("@LogID", SqlDbType.Int, 4) }; parameters[0].Value = LogID; WebDemo.Model.WebDemo.LogData model = new WebDemo.Model.WebDemo.LogData(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }