protected void btnAdd_Click(object sender, EventArgs e) { WListData model = new WListData(); WListBB listBB = new WListBB(); try { if (this.State == "1") { this.SetModel(ref model); listBB.AddRecord(model); } else if (this.State == "2") { model = listBB.GetModel(this.IdValue); this.SetModel(ref model); listBB.ModifyRecord(model); } } catch (Exception ex) { this.ClientScript.RegisterStartupScript(this.GetType(), "ShowErr", "ShowErr(\"" + Server.UrlEncode(ex.Message) + "\",4);", true); return; } finally { listBB.Dispose(); } }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public int AddRecord(WListData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("set nocount on; "); strSql.Append("insert into WList("); strSql.Append("workflowNo,workflowNm,workTableNm,recordKeyField,keyIsInt,titleField,itemNo,remark,isRun,stopMark)"); strSql.Append(" values ("); strSql.Append("@workflowNo,@workflowNm,@workTableNm,@recordKeyField,@keyIsInt,@titleField,@itemNo,@remark,@isRun,@stopMark)"); strSql.Append("; select @@identity; set nocount off; "); SqlParameter[] parameters = { new SqlParameter("@workflowNo", SqlDbType.NVarChar,50), new SqlParameter("@workflowNm", SqlDbType.NVarChar,50), new SqlParameter("@workTableNm", 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.workflowNo; parameters[1].Value = model.workflowNm; parameters[2].Value = model.workTableNm; 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) { WListBB listBB = new WListBB(); WListData model = new WListData(); try { model = listBB.GetModel(id); this.workflowNo.Text = model.workflowNo; this.workflowNm.Text = model.workflowNm; this.workTableNm.Text = model.workTableNm; 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 { listBB.Dispose(); } }
private void SetModel(ref WListData model) { model.workflowNo = this.workflowNo.Text; model.workflowNm = this.workflowNm.Text; model.workTableNm = this.workTableNm.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 //���ؿؼ� WListBB listBB = new WListBB(); WListData listData = new WListData(); try { listData = listBB.GetModel(this.IdValue); //����й��������˴�Ҫ��֤�Ƿ������� this.ShowInfo(this.IdValue); } finally { listBB.Dispose(); } break; default: break; } } } this.BindGrid(this.IdValue); }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public bool ModifyRecord(WListData model) { bool ret = false; StringBuilder strSql = new StringBuilder(); strSql.Append("update WList set "); strSql.Append("workflowNm=@workflowNm,"); strSql.Append("workTableNm=@workTableNm,"); 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 workflowNo = @workflowNo "); SqlParameter[] parameters = { new SqlParameter("@workflowNo", SqlDbType.NVarChar,50), new SqlParameter("@workflowNm", SqlDbType.NVarChar,50), new SqlParameter("@workTableNm", 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.workflowNo; parameters[1].Value = model.workflowNm; parameters[2].Value = model.workTableNm; 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="workflowNo">����ֵ</param> /// <returns>model</returns> public WListData GetModel(string workflowNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from WList"); strSql.Append(" where workflowNo = @workflowNo "); SqlParameter[] parameters = { new SqlParameter("@workflowNo", SqlDbType.NVarChar,50) }; parameters[0].Value = workflowNo; WListData model = new WListData(); 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["workflowNo"] != DBNull.Value) { model.workflowNo = Convert.ToString(row["workflowNo"]); } if (row["workflowNm"] != DBNull.Value) { model.workflowNm = Convert.ToString(row["workflowNm"]); } if (row["workTableNm"] != DBNull.Value) { model.workTableNm = Convert.ToString(row["workTableNm"]); } 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; } }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public bool ModifyRecord(WListData model) { return this.listDB.ModifyRecord(model); }
/// <summary> /// ����һ������ /// </summary> /// <param name="model">model</param> public int AddRecord(WListData model) { return this.listDB.AddRecord(model); }