//保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("../login.aspx"); string ls_tip = "保存成功!"; HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); //判断是否已存在该字段 HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield(); Hyoa_flowfield.hy_tableid = this.txttableid.Text; Hyoa_flowfield.hy_mudelid = this.txtmudelid.Text; Hyoa_flowfield.hy_flowid = this.txtflowid.Text; Hyoa_flowfield.hy_fieldid = this.txtfieldid.Text; Hyoa_flowfield.hy_fieldname = this.txtfieldname.Text; Hyoa_flowfield.hy_fieldtype = this.ddlfieldtype.SelectedValue; Hyoa_flowfield.hy_ifreadonly = this.ddlifreadonly.SelectedValue; Hyoa_flowfield.hy_defaultvaluetype = System.Int32.Parse(this.ddldefaultvaluetype.SelectedValue); Hyoa_flowfield.hy_defaultvalue = this.txtdefaultvalue.Text; Hyoa_flowfield.hy_optiontype = System.Int32.Parse(this.ddloptiontype.SelectedValue); Hyoa_flowfield.hy_options = this.txtoptions.Text; Hyoa_flowfield.hy_onclick = this.txtonclick.Text; Hyoa_flowfield.hy_ondblclick = this.txtondblclick.Text; Hyoa_flowfield.hy_onchange = this.txtonchange.Text; Hyoa_flowfield.hy_onkeydown = this.txtonkeydown.Text; Hyoa_flowfield.hy_onkeyup = this.txtonkeyup.Text; Hyoa_flowfield.hy_onfocus = this.txtonfocus.Text; Hyoa_flowfield.hy_onblur = this.txtonblur.Text; Hyoa_flowfield.hy_sqlfield = ""; Hyoa_flowfield.hy_class = this.txtclass.Text; Hyoa_flowfield.hy_width = this.txtwidth.Text; Hyoa_flowfield.hy_height = this.txtheight.Text; Hyoa_flowfield.hy_tdnums = System.Int32.Parse(this.ddltdnums.SelectedValue); Hyoa_flowfield.hy_config = ""; Hyoa_flowfield.hy_sort = float.Parse(this.txtsort.Text); Hyoa_flowfield.hy_wordlimit = System.Int32.Parse(this.txtwordlimit.Text); Hyoa_flowfield.hy_required = this.ddlrequired.SelectedValue; Hyoa_flowfield.hy_align = this.ddlalign.SelectedValue; Hyoa_flowfield.hy_ifhiddle = this.ddlifhiddle.SelectedValue; Hyoa_flowfield.hy_ifdbsybt = this.ddlifdbsybt.SelectedValue; Hyoa_flowfield.hy_field1 = ""; Hyoa_flowfield.hy_field2 = ""; Hyoa_flowfield.hy_field3 = ""; Hyoa_flowfield.hy_field4 = ""; Hyoa_flowfield.hy_field5 = ""; //新文档时 if (this.txtop.Value == "add") { DataTable dt = Hyoa_flowfield.GetSQLfieldBymudelidAndFieldidAndTableid(this.txtmudelid.Text, this.txtfieldid.Text, this.txttableid.Text); if (dt.Rows.Count > 0) { Response.Write("<script>alert('该字段ID在当前表单中已存在,请重新输入!');</script>"); return; } Hyoa_flowfield.ID = Hyoa_global.GetRandom(); Hyoa_flowfield.Insert(); CreateSQLField(); } else { Hyoa_flowfield.ID = this.txtdocid.Value; Hyoa_flowfield.Update(); EditSQLField(); } //处理完成后的提示及跳转 if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');self.close();</script>"); } }
//保存 protected void Button_Save_Click(object sender, EventArgs e) { if (this.Session["hyuid"].ToString() == "") this.Response.Redirect("/login.aspx"); string ls_tip = "保存成功!"; HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield(); //新文档时 if (this.txtop.Value == "add") { Hyoa_flowfield.ID = Hyoa_global.GetRandom(); Hyoa_flowfield.hy_tableid = this.txttableid.Text; Hyoa_flowfield.hy_mudelid = this.txtmudelid.Text; Hyoa_flowfield.hy_flowid = this.txtflowid.Text; Hyoa_flowfield.hy_fieldid = this.txtfieldid.Text; Hyoa_flowfield.hy_fieldname = this.txtfieldname.Text; Hyoa_flowfield.hy_fieldtype = this.ddlfieldtype.SelectedValue; Hyoa_flowfield.hy_ifreadonly = this.ddlifreadonly.SelectedValue; Hyoa_flowfield.hy_defaultvaluetype = System.Int32.Parse(this.ddldefaultvaluetype.SelectedValue); Hyoa_flowfield.hy_defaultvalue = this.txtdefaultvalue.Text; Hyoa_flowfield.hy_optiontype = System.Int32.Parse(this.ddloptiontype.SelectedValue); if (ddloptiontype.SelectedValue == "1" && ddlwhichtable.SelectedIndex != 0) { if(this.ddlwhichtable.SelectedIndex==0) Hyoa_flowfield.hy_options = this.txtoptions.Text; else Hyoa_flowfield.hy_options = this.txtoptions.Text + " from hyp_flowmain where hy_tableid='" + ddlwhichtable.SelectedValue + "' order by " + this.txtsortby.Text + " " + this.ddlsorttype.SelectedValue; } else { Hyoa_flowfield.hy_options = this.txtoptions.Text; } Hyoa_flowfield.hy_onclick = this.txtonclick.Text; Hyoa_flowfield.hy_ondblclick = this.txtondblclick.Text; Hyoa_flowfield.hy_onchange = this.txtonchange.Text; Hyoa_flowfield.hy_onkeydown = this.txtonkeydown.Text; Hyoa_flowfield.hy_onkeyup = this.txtonkeyup.Text; Hyoa_flowfield.hy_sqlfield = this.ddlsqlfield.SelectedValue; Hyoa_flowfield.hy_class = this.txtclass.Text; Hyoa_flowfield.hy_width = this.txtwidth.Text; Hyoa_flowfield.hy_height = this.txtheight.Text; Hyoa_flowfield.hy_tdnums = System.Int32.Parse(this.ddltdnums.SelectedValue); Hyoa_flowfield.hy_config = ""; Hyoa_flowfield.hy_sort = float.Parse(this.txtsort.Text); Hyoa_flowfield.hy_wordlimit = System.Int32.Parse(this.txtwordlimit.Text); Hyoa_flowfield.hy_required = this.ddlrequired.SelectedValue; Hyoa_flowfield.hy_align = this.ddlalign.SelectedValue; Hyoa_flowfield.hy_ifhiddle = this.ddlifhiddle.SelectedValue; Hyoa_flowfield.Insert(); } else { Hyoa_flowfield.ID = this.txtdocid.Value; Hyoa_flowfield.hy_tableid = this.txttableid.Text; Hyoa_flowfield.hy_mudelid = this.txtmudelid.Text; Hyoa_flowfield.hy_flowid = this.txtflowid.Text; Hyoa_flowfield.hy_fieldid = this.txtfieldid.Text; Hyoa_flowfield.hy_fieldname = this.txtfieldname.Text; Hyoa_flowfield.hy_fieldtype = this.ddlfieldtype.SelectedValue; Hyoa_flowfield.hy_ifreadonly = this.ddlifreadonly.SelectedValue; Hyoa_flowfield.hy_defaultvaluetype = System.Int32.Parse(this.ddldefaultvaluetype.SelectedValue); Hyoa_flowfield.hy_defaultvalue = this.txtdefaultvalue.Text; Hyoa_flowfield.hy_optiontype = System.Int32.Parse(this.ddloptiontype.SelectedValue); if (ddloptiontype.SelectedValue == "1" && ddlwhichtable.SelectedIndex != 0) Hyoa_flowfield.hy_options = this.txtoptions.Text + " from hyp_flowmain where hy_tableid='" + ddlwhichtable.SelectedValue + "' order by " + this.txtsortby.Text + " " + this.ddlsorttype.SelectedValue; else Hyoa_flowfield.hy_options = this.txtoptions.Text; Hyoa_flowfield.hy_onclick = this.txtonclick.Text; Hyoa_flowfield.hy_ondblclick = this.txtondblclick.Text; Hyoa_flowfield.hy_onchange = this.txtonchange.Text; Hyoa_flowfield.hy_onkeydown = this.txtonkeydown.Text; Hyoa_flowfield.hy_onkeyup = this.txtonkeyup.Text; Hyoa_flowfield.hy_sqlfield = this.ddlsqlfield.SelectedValue; Hyoa_flowfield.hy_class = this.txtclass.Text; Hyoa_flowfield.hy_width = this.txtwidth.Text; Hyoa_flowfield.hy_height = this.txtheight.Text; Hyoa_flowfield.hy_tdnums = System.Int32.Parse(this.ddltdnums.SelectedValue); Hyoa_flowfield.hy_config = ""; Hyoa_flowfield.hy_sort = float.Parse(this.txtsort.Text); Hyoa_flowfield.hy_wordlimit = System.Int32.Parse(this.txtwordlimit.Text); Hyoa_flowfield.hy_required = this.ddlrequired.SelectedValue; Hyoa_flowfield.hy_align = this.ddlalign.SelectedValue; Hyoa_flowfield.hy_ifhiddle = this.ddlifhiddle.SelectedValue; Hyoa_flowfield.Update(); string lsupdate = "update hyt_flowfield set hy_flowid = '" + this.txtflowid.Text + "' where ID='" + this.txtdocid.Value + "'"; HyoaClass.DAO dbupdate = new HyoaClass.DAO(); dbupdate.Execute(lsupdate); dbupdate.Close(); } //处理完成后的提示及跳转 if (this.txtifpop.Value == "") { Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>"); } else { Response.Write("<script>alert('" + ls_tip + "');self.close();</script>"); } }