protected void btnAdd_Click(object sender, EventArgs e) { MBusinessTypeData model = new MBusinessTypeData(); MBusinessTypeBB businessTypeBB = new MBusinessTypeBB(); try { if (this.State == "1") { this.SetModel(ref model); businessTypeBB.AddRecord(model); } else if (this.State == "2") { model = businessTypeBB.GetModel(this.IdValue); this.SetModel(ref model); businessTypeBB.ModifyRecord(model); } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",4);", true); return; } finally { businessTypeBB.Dispose(); } }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public int AddRecord(MBusinessTypeData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("set nocount on; "); strSql.Append("insert into MBusinessType("); strSql.Append("messageNo,messageNm,tableNm,recordKeyField,keyIsInt,titleField,itemNo,remark,isRun,stopMark)"); strSql.Append(" values ("); strSql.Append("@messageNo,@messageNm,@tableNm,@recordKeyField,@keyIsInt,@titleField,@itemNo,@remark,@isRun,@stopMark)"); strSql.Append("; select @@identity; set nocount off; "); SqlParameter[] parameters = { new SqlParameter("@messageNo", SqlDbType.NVarChar,20), new SqlParameter("@messageNm", SqlDbType.NVarChar,20), new SqlParameter("@tableNm", SqlDbType.NVarChar,50), new SqlParameter("@recordKeyField", SqlDbType.NVarChar,50), new SqlParameter("@keyIsInt", SqlDbType.Bit), new SqlParameter("@titleField", SqlDbType.NVarChar,50), new SqlParameter("@itemNo", SqlDbType.NVarChar,20), new SqlParameter("@remark", SqlDbType.NVarChar,200), new SqlParameter("@isRun", SqlDbType.Bit), new SqlParameter("@stopMark", SqlDbType.NVarChar,200) }; parameters[0].Value = model.messageNo; parameters[1].Value = model.messageNm; parameters[2].Value = model.tableNm; parameters[3].Value = model.recordKeyField; parameters[4].Value = model.keyIsInt; parameters[5].Value = model.titleField; parameters[6].Value = model.itemNo; parameters[7].Value = model.remark; parameters[8].Value = model.isRun; parameters[9].Value = model.stopMark; int id = 0; try { object ret = SqlHelper.ExecuteScalar(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ret != null && ret != DBNull.Value) { id = Convert.ToInt32(ret); } } catch (Exception ex) { throw ex; } return id; }
private void ShowInfo(string id) { MBusinessTypeBB businessTypeBB = new MBusinessTypeBB(); MBusinessTypeData model = new MBusinessTypeData(); try { model = businessTypeBB.GetModel(id); this.messageNo.Text = model.messageNo; this.messageNm.Text = model.messageNm; this.tableNm.Text = model.tableNm; this.recordKeyField.Text = model.recordKeyField; this.keyIsInt.Text = model.keyIsInt.ToString(); this.titleField.Text = model.titleField; this.itemNo.Text = model.itemNo; this.remark.Text = model.remark; this.isRun.Text = model.isRun.ToString(); } finally { businessTypeBB.Dispose(); } }
private void SetModel(ref MBusinessTypeData model) { model.messageNo = this.messageNo.Text; model.messageNm = this.messageNm.Text; model.tableNm = this.tableNm.Text; model.recordKeyField = this.recordKeyField.Text; model.keyIsInt = this.keyIsInt.Checked; model.titleField = this.titleField.Text; model.itemNo = this.itemNo.Text; model.remark = this.remark.Text; model.isRun = this.isRun.Checked; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Request.Params["id"] != null && Request.Params["id"].Trim() != "") { this.IdValue = Request.Params["id"]; } if (Request.Params["state"] != null && Request.Params["state"].Trim() != string.Empty) { this.State = Request.Params["state"].ToString(); switch (this.State) { case "1": //add break; case "2": //update //���ؿؼ� MBusinessTypeBB businessTypeBB = new MBusinessTypeBB(); MBusinessTypeData businessTypeData = new MBusinessTypeData(); try { businessTypeData = businessTypeBB.GetModel(this.IdValue); //����й��������˴�Ҫ��֤�Ƿ������� this.ShowInfo(this.IdValue); } finally { businessTypeBB.Dispose(); } break; default: break; } } } this.BindGrid(this.IdValue); }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public bool ModifyRecord(MBusinessTypeData model) { return this.businessTypeDB.ModifyRecord(model); }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public int AddRecord(MBusinessTypeData model) { return this.businessTypeDB.AddRecord(model); }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public bool ModifyRecord(MBusinessTypeData model) { bool ret = false; StringBuilder strSql = new StringBuilder(); strSql.Append("update MBusinessType set "); strSql.Append("messageNm=@messageNm,"); strSql.Append("tableNm=@tableNm,"); strSql.Append("recordKeyField=@recordKeyField,"); strSql.Append("keyIsInt=@keyIsInt,"); strSql.Append("titleField=@titleField,"); strSql.Append("itemNo=@itemNo,"); strSql.Append("remark=@remark,"); strSql.Append("isRun=@isRun,"); strSql.Append("stopMark=@stopMark"); strSql.Append(" where messageNo = @messageNo "); SqlParameter[] parameters = { new SqlParameter("@messageNo", SqlDbType.NVarChar,20), new SqlParameter("@messageNm", SqlDbType.NVarChar,20), new SqlParameter("@tableNm", SqlDbType.NVarChar,50), new SqlParameter("@recordKeyField", SqlDbType.NVarChar,50), new SqlParameter("@keyIsInt", SqlDbType.Bit), new SqlParameter("@titleField", SqlDbType.NVarChar,50), new SqlParameter("@itemNo", SqlDbType.NVarChar,20), new SqlParameter("@remark", SqlDbType.NVarChar,200), new SqlParameter("@isRun", SqlDbType.Bit), new SqlParameter("@stopMark", SqlDbType.NVarChar,200) }; parameters[0].Value = model.messageNo; parameters[1].Value = model.messageNm; parameters[2].Value = model.tableNm; parameters[3].Value = model.recordKeyField; parameters[4].Value = model.keyIsInt; parameters[5].Value = model.titleField; parameters[6].Value = model.itemNo; parameters[7].Value = model.remark; parameters[8].Value = model.isRun; parameters[9].Value = model.stopMark; try { SqlHelper.ExecuteNonQuery(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); ret = true; } catch (Exception ex) { throw ex; } return ret; }
/// <summary> /// �õ�һ��model /// </summary> /// <param name="messageNo">����ֵ</param> /// <returns>model</returns> public MBusinessTypeData GetModel(string messageNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from MBusinessType"); strSql.Append(" where messageNo = @messageNo "); SqlParameter[] parameters = { new SqlParameter("@messageNo", SqlDbType.NVarChar,20) }; parameters[0].Value = messageNo; MBusinessTypeData model = new MBusinessTypeData(); DataSet ds = SqlHelper.ExecuteDataset(this.connection, this.transaction, CommandType.Text, strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { DataRow row = ds.Tables[0].Rows[0]; if (row["messageNo"] != DBNull.Value) { model.messageNo = Convert.ToString(row["messageNo"]); } if (row["messageNm"] != DBNull.Value) { model.messageNm = Convert.ToString(row["messageNm"]); } if (row["tableNm"] != DBNull.Value) { model.tableNm = Convert.ToString(row["tableNm"]); } if (row["recordKeyField"] != DBNull.Value) { model.recordKeyField = Convert.ToString(row["recordKeyField"]); } if (row["keyIsInt"] != DBNull.Value) { model.keyIsInt = Convert.ToBoolean(row["keyIsInt"]); } if (row["titleField"] != DBNull.Value) { model.titleField = Convert.ToString(row["titleField"]); } if (row["itemNo"] != DBNull.Value) { model.itemNo = Convert.ToString(row["itemNo"]); } if (row["remark"] != DBNull.Value) { model.remark = Convert.ToString(row["remark"]); } if (row["isRun"] != DBNull.Value) { model.isRun = Convert.ToBoolean(row["isRun"]); } if (row["stopMark"] != DBNull.Value) { model.stopMark = Convert.ToString(row["stopMark"]); } return model; } else { return null; } }