protected void Button1_Click(object sender, EventArgs e) { string All_Title_Txt = ""; PopedomType pt = PopedomType.New; sys_FieldTable Ft = BusinessFacade.sys_FieldDisp(FieldID); string F_CName_Value = (string)Common.sink(F_CName.UniqueID, MethodType.Post, 50, 1, DataType.Str); string F_Remark_Value = (string)Common.sink(F_Remark.UniqueID, MethodType.Post, 200, 0, DataType.Str); Ft.F_CName = F_CName_Value; Ft.F_Remark = F_Remark_Value; if (CMD == "New") { string F_Key_Value = (string)Common.sink(F_Key.UniqueID, MethodType.Post, 50, 1, DataType.CharAndNum); Ft.F_Key = F_Key_Value; All_Title_Txt = "增加"; Ft.DB_Option_Action_ = "Insert"; } else if (CMD == "Edit") { pt = PopedomType.Edit; All_Title_Txt = "修改"; Ft.DB_Option_Action_ = "Update"; } if (BusinessFacade.sys_FieldCheckPK(Ft, pt)) { EventMessage.MessageBox(1, "操作失败", string.Format("存在相同的值({0})!", Ft.F_Key), Icon_Type.Alert, Common.GetHomeBaseUrl("default.aspx")); } BusinessFacade.sys_FieldInsertUpdate(Ft); EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", FieldID, All_Title_Txt), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx")); }
protected void Button1_Click(object sender, EventArgs e) { int FieldID = (int)Common.sink("FieldID", MethodType.Get, 255, 1, DataType.Int); sys_FieldTable ft = BusinessFacade.sys_FieldDisp(FieldID); string V_Text_Value = (string)Common.sink(V_Text_Input.UniqueID, MethodType.Post, 100, 1, DataType.Str); string V_Code_Value = (string)Common.sink(V_Code_Input.UniqueID, MethodType.Post, 100, 0, DataType.Str); int ValueID = (int)Common.sink("ValueID", MethodType.Get, 255, 0, DataType.Int); sys_FieldValueTable fvt = BusinessFacade.sys_FieldValueDisp(ValueID); fvt.V_Text = V_Text_Value; fvt.V_Code = V_Code_Value; fvt.V_F_Key = ft.F_Key; string Messages = ""; if (CMD == "Edit") { fvt.DB_Option_Action_ = "Update"; Messages = string.Format("修改应用字段值(ID:{0})成功!", fvt.ValueID); } else if (CMD == "New") { QueryParam qp = new QueryParam(); qp.Where = string.Format("where V_F_Key = '{0}'", Common.inSQL(ft.F_Key)); //qp.PageSize = 1; int RecordCount = 0; ArrayList lst = BusinessFacade.sys_FieldValueList(qp, out RecordCount); if (RecordCount == 0) { fvt.V_ShowOrder = 0; } else { fvt.V_ShowOrder = ((sys_FieldValueTable)lst[RecordCount - 1]).V_ShowOrder + 1; } fvt.DB_Option_Action_ = "Insert"; Messages = string.Format("增加应用字段值({0})成功!", fvt.V_Text); } BusinessFacade.sys_FieldValueInsertUpdate(fvt); EventMessage.EventWriteDB(1, Messages); ClientScriptManager cs = Page.ClientScript; cs.RegisterStartupScript(typeof(string), "TabJs", "<script language='javascript'>window.returnVal=\"" + Messages + "\";window.parent.hidePopWin(true);</script>"); }
private void OnStart() { Button2.Attributes.Add("onclick", "return doConfirm(this.form);"); if (CMD == "OrderBy") { Table_OrderBy_FieldValue.Visible = true; string F_Key = (string)Common.sink("F_Key", MethodType.Get, 50, 1, DataType.CharAndNum); QueryParam qp = new QueryParam(); qp.Where = string.Format("where V_F_Key = '{0}'", Common.inSQL(F_Key)); qp.Orderfld = " V_ShowOrder "; qp.OrderType = 0; int RecordCount = 0; ArrayList lst = BusinessFacade.sys_FieldValueList(qp, out RecordCount); OrderByListItems.DataTextField = "V_Text"; OrderByListItems.DataValueField = "ValueID"; OrderByListItems.DataSource = lst; OrderByListItems.DataBind(); Button3.OnClientClick = string.Format("selectAll({0})", OrderByListItems.UniqueID); } else { int FieldID = (int)Common.sink("FieldID", MethodType.Get, 255, 1, DataType.Int); sys_FieldTable ft = BusinessFacade.sys_FieldDisp(FieldID); F_Key.Text = ft.F_Key; F_CName.Text = ft.F_CName; Table_Manager_FieldValue.Visible = true; if (CMD == "Edit") { int ValueID = (int)Common.sink("ValueID", MethodType.Get, 255, 1, DataType.Int); V_Text_Input.Text = BusinessFacade.sys_FieldValueDisp(ValueID).V_Text; V_Code_Input.Text = BusinessFacade.sys_FieldValueDisp(ValueID).V_Code; } else { Button2.Visible = false; } } }
/// <summary> /// 将记录集转为sys_FieldTable实体类 /// </summary> /// <param name="dr">记录集</param> /// <returns>sys_FieldTable</returns> protected object Populatesys_Field(IDataReader dr) { sys_FieldTable nc = new sys_FieldTable(); if (!Convert.IsDBNull(dr["FieldID"])) { nc.FieldID = Convert.ToInt32(dr["FieldID"]); // 应用字段ID号 } if (!Convert.IsDBNull(dr["F_Key"])) { nc.F_Key = Convert.ToString(dr["F_Key"]).Trim(); // 应用字段关键字 } if (!Convert.IsDBNull(dr["F_CName"])) { nc.F_CName = Convert.ToString(dr["F_CName"]).Trim(); // 应用字段中文说明 } if (!Convert.IsDBNull(dr["F_Remark"])) { nc.F_Remark = Convert.ToString(dr["F_Remark"]).Trim(); // 描述说明 } return(nc); }
/// <summary> /// 新增/删除/修改 sys_Field /// </summary> /// <param name="fam">sys_FieldTable实体类</param> /// <returns>返回0操正常</returns> public override int sys_FieldInsertUpdate(sys_FieldTable fam) { int rInt = 0; using (SqlConnection Conn = GetSqlConnection()) { SqlCommand cmd = new SqlCommand("sys_FieldInsertUpdateDelete", Conn); cmd.CommandType = CommandType.StoredProcedure; //设置参数 cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录 cmd.Parameters.Add("@FieldID", SqlDbType.Int).Value = fam.FieldID; //应用字段ID号 cmd.Parameters.Add("@F_Key", SqlDbType.VarChar).Value = fam.F_Key; //应用字段关键字 cmd.Parameters.Add("@F_CName", SqlDbType.NVarChar).Value = fam.F_CName; //应用字段中文说明 cmd.Parameters.Add("@F_Remark", SqlDbType.NVarChar).Value = fam.F_Remark; //描述说明 Conn.Open(); rInt = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Dispose(); Conn.Dispose(); Conn.Close(); } return(rInt); }
/// <summary> /// 新增/删除/修改 sys_Field /// </summary> /// <param name="fam">sys_FieldTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_FieldInsertUpdate(sys_FieldTable fam);
private void OnStart() { sys_FieldTable Ft = BusinessFacade.sys_FieldDisp(FieldID); F_Key_Txt.Text = Ft.F_Key; F_CName_Txt.Text = Ft.F_CName; F_Remark_Txt.Text = Ft.F_Remark; QueryParam qp = new QueryParam(); qp.Where = string.Format("where V_F_Key = '{0}'", Common.inSQL(Ft.F_Key)); qp.Orderfld = " V_ShowOrder "; qp.OrderType = 0; int RecordCount = 0; ArrayList lst = BusinessFacade.sys_FieldValueList(qp, out RecordCount); Main_Value.DataSource = lst; Main_Value.DataBind(); if (CMD == "List") { HeadMenuButtonItem bi1 = new HeadMenuButtonItem(); bi1.ButtonPopedom = PopedomType.Edit; bi1.ButtonName = "应用字段"; bi1.ButtonUrl = string.Format("?CMD=Edit&FieldID={0}", FieldID); HeadMenuWebControls1.ButtonList.Add(bi1); HeadMenuButtonItem bi3 = new HeadMenuButtonItem(); bi3.ButtonPopedom = PopedomType.New; bi3.ButtonName = "应用字段值"; bi3.ButtonUrl = string.Format("showPopWin('应用字段值增加','FieldValueBox.aspx?FieldID={0}&CMD=New&{1}', 300, 160, AlertMessageBox,true);", FieldID, Common.RndNum(7)); bi3.ButtonUrlType = UrlType.JavaScript; HeadMenuWebControls1.ButtonList.Add(bi3); HeadMenuButtonItem bi4 = new HeadMenuButtonItem(); bi4.ButtonPopedom = PopedomType.Edit; bi4.ButtonName = "排序应用字段值"; bi4.ButtonIcon = "Orderby.gif"; bi4.ButtonUrl = string.Format("showPopWin('应用字段值排序','FieldValueBox.aspx?F_Key={0}&CMD=OrderBy&{1}', 180, 210, AlertMessageBox,true);", Ft.F_Key, Common.RndNum(7)); bi4.ButtonUrlType = UrlType.JavaScript; HeadMenuWebControls1.ButtonList.Add(bi4); Disp_Input.Visible = false; F_Key_Txt.Visible = true; F_CName_Txt.Visible = true; F_Remark_Txt.Visible = true; F_Key.Visible = false; F_CName.Visible = false; F_Remark.Visible = false; } else if (CMD == "Edit") { F_Key.Text = Ft.F_Key; F_CName.Text = Ft.F_CName; F_Remark.Text = Ft.F_Remark; F_Key.Visible = false; F_Key_Txt.Visible = true; HeadMenuButtonItem bi5 = new HeadMenuButtonItem(); bi5.ButtonIcon = "back.gif"; bi5.ButtonPopedom = PopedomType.List; bi5.ButtonName = "返回"; bi5.ButtonUrl = string.Format("?CMD=List&FieldID={0}", FieldID); HeadMenuWebControls1.ButtonList.Add(bi5); HeadMenuButtonItem bi2 = new HeadMenuButtonItem(); bi2.ButtonPopedom = PopedomType.Delete; bi2.ButtonName = "应用字段"; bi2.ButtonUrlType = UrlType.JavaScript; bi2.ButtonUrl = string.Format("DelData('?CMD=Delete&FieldID={0}')", FieldID); HeadMenuWebControls1.ButtonList.Add(bi2); Disp_Sub.Visible = false; } else if (CMD == "New") { Disp_Sub.Visible = false; } else if (CMD == "Delete") { Ft.DB_Option_Action_ = "Delete"; BusinessFacade.sys_FieldInsertUpdate(Ft); foreach (sys_FieldValueTable var in lst) { var.DB_Option_Action_ = "Delete"; BusinessFacade.sys_FieldValueInsertUpdate(var); } EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", FieldID, "删除应用字段"), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx")); } }