//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("../login.aspx");
string ls_tip = "保存成功！";
//新文档时
HyoaClass.Hyoa_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
Hyoa_tableconfig.ID = this.txtdocid.Text;
Hyoa_tableconfig.hy_mudelid = this.ddlmudelid.SelectedValue.ToString();
Hyoa_tableconfig.hy_name = this.txtname.Value;
Hyoa_tableconfig.hy_onload = this.txthy_onload.Text;
Hyoa_tableconfig.hy_sort = float.Parse(this.txtsort.Value);
Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
Hyoa_tableconfig.hy_ifdisplayall = this.ddlifdisplayall.SelectedValue;
Hyoa_tableconfig.hy_ifcomment = this.ddlifcomment.SelectedValue;
Hyoa_tableconfig.hy_ispuballByflowYB = this.ddlispuballByflowYB.SelectedValue;
Hyoa_tableconfig.hy_tablerole = this.ddltablerole.SelectedValue;
Hyoa_tableconfig.hy_colnum = float.Parse(this.ddldisplaycol.SelectedValue);
Hyoa_tableconfig.hy_field1 = "";
Hyoa_tableconfig.hy_field2 = "";
Hyoa_tableconfig.hy_field3 = "";
Hyoa_tableconfig.hy_field4 = "";
Hyoa_tableconfig.hy_field5 = "";
if (this.txtop.Value == "add")
{
//先判断是否已经存在
DataTable dt = Hyoa_tableconfig.GetTable(this.txtdocid.Text);
if (dt.Rows.Count > 0)
{
Response.Write("<script>alert('该表单编号已存在，请重新填写！');history.back();</script>");
return;
}
if (this.txtdocid.Text.Length < 6)
{
Response.Write("<script>alert('表单编号长度必须大于5位！');history.back();</script>");
return;
}
if (this.txtdocid.Text.Substring(0, 5) != "Table")
{
Response.Write("<script>alert('表单编号必须以Table开头！');history.back();</script>");
return;
}
Hyoa_tableconfig.Insert();
//创建SQL表
if (CreateSQLTable()==false)
{
ls_tip = "生成表结构失败，请联系管理员！";
}
}
else
{
Hyoa_tableconfig.Update();
//修改时，保存完成后同时更新对应的字段中FLOWID值（如果非流程则置为空，如果是流程则置为值）
HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield();
if (this.ddlifflowdoc.SelectedValue == "是")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.ddlmudelid.SelectedValue);
if (dt_flow.Rows.Count > 0)
{
Hyoa_flowfield.Updateflowid_For_tacheconfig(dt_flow.Rows[0]["hy_flowid"].ToString(), this.txtdocid.Text);
}
}
else
{
Hyoa_flowfield.Updateflowid_For_tacheconfig("", this.txtdocid.Text);
}
//修改后，同时更新对应的字段中的模块ID，为了解决当表单中对应的模块修改后，字段中没有更新的BUG
Hyoa_flowfield.Updatemudelid_For_tableconfig(this.ddlmudelid.SelectedValue, this.txtdocid.Text);
}
//处理完成后的提示及跳转
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_tableconfig Hyoa_tableconfig = new HyoaClass.Hyoa_tableconfig();
string lstableid="";
HyoaClass.Hyoa_detail Hyoa_detail = new HyoaClass.Hyoa_detail();//主表单显示的列数
if (this.txtop.Value == "add")
{
////先判断这个模块编号是否已经存在
//DataTable dt = Hyoa_tableconfig.GetTablesbymudelid(this.ddlmudelid.SelectedValue);
//if (dt.Rows.Count > 0)
//{
// Response.Write("<script>alert('该模块的表单配置已存在，请重新填写！');history.back();</script>");
// return;
//}
//else
//{
lstableid = Hyoa_global.GetRandom();
Hyoa_tableconfig.ID = lstableid;
Hyoa_tableconfig.hy_mudelid = this.ddlmudelid.SelectedValue.ToString();
Hyoa_tableconfig.hy_name = this.txtname.Value;
Hyoa_tableconfig.hy_onload = this.txthy_onload.Value;
Hyoa_tableconfig.hy_sort = float.Parse(this.txtsort.Value);
Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
Hyoa_tableconfig.hy_ifdisplayall = this.ddlifdisplayall.SelectedValue;
Hyoa_tableconfig.hy_ispuballByflowYB = this.ddlispuballByflowYB.SelectedValue;
Hyoa_tableconfig.hy_tablerole = this.ddltablerole.SelectedValue;
Hyoa_tableconfig.Insert();
//新文档时增加主表显示列数
Hyoa_detail.hy_fatherid = lstableid;
Hyoa_detail.hy_colnum = int.Parse(this.ddldisplaycol.SelectedValue);
Hyoa_detail.hy_field1 = "";
Hyoa_detail.hy_field2 = "";
Hyoa_detail.hy_field3 = "";
Hyoa_detail.hy_field4 = "";
Hyoa_detail.hy_field5 = "";
Hyoa_detail.Insert();
//}
}
else
{
Hyoa_tableconfig.ID = this.txtdocid.Value;
Hyoa_tableconfig.hy_mudelid = this.ddlmudelid.SelectedValue;
Hyoa_tableconfig.hy_name = this.txtname.Value;
Hyoa_tableconfig.hy_onload = this.txthy_onload.Value;
Hyoa_tableconfig.hy_sort = float.Parse(this.txtsort.Value);
Hyoa_tableconfig.hy_ifflowdoc = this.ddlifflowdoc.SelectedValue;
Hyoa_tableconfig.hy_ifdisplayall = this.ddlifdisplayall.SelectedValue;
Hyoa_tableconfig.hy_ispuballByflowYB = this.ddlispuballByflowYB.SelectedValue;
Hyoa_tableconfig.hy_tablerole = this.ddltablerole.SelectedValue;
Hyoa_tableconfig.Update();
//更新文档时更新主表显示列数
Hyoa_detail.hy_fatherid = this.txtdocid.Value;
Hyoa_detail.hy_colnum = int.Parse(this.ddldisplaycol.SelectedValue);
Hyoa_detail.hy_field1 = "";
Hyoa_detail.hy_field2 = "";
Hyoa_detail.hy_field3 = "";
Hyoa_detail.hy_field4 = "";
Hyoa_detail.hy_field5 = "";
DataTable dt2 = Hyoa_detail.Getdetail(this.txtdocid.Value);
if (dt2.Rows.Count > 0)
{
Hyoa_detail.Update();
}
else
{
Hyoa_detail.Insert();
}
//修改时，保存完成后同时更新对应的字段中FLOWID值（如果非流程则置为空，如果是流程则置为值）
HyoaClass.DAO db = new HyoaClass.DAO();
string sql_field = "";
if (this.ddlifflowdoc.SelectedValue == "是")
{
HyoaClass.Hyoa_flowinfor Hyoa_flowinfor = new HyoaClass.Hyoa_flowinfor();
DataTable dt_flow = Hyoa_flowinfor.Getflowinforbymudelid(this.ddlmudelid.SelectedValue);
if (dt_flow.Rows.Count > 0)
{
sql_field = "update hyt_flowfield set hy_flowid='" + dt_flow.Rows[0]["hy_flowid"].ToString() + "' where hy_tableid='" + this.txtdocid.Value + "'";
}
}
else
{
sql_field = "update hyt_flowfield set hy_flowid='' where hy_tableid='" + this.txtdocid.Value + "'";
}
db.Execute(sql_field);
db.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>");
}
}