//复制
protected void btncopyinfo_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
String[] v_uids = this.txtuids.Value.Split(',');
for (var i = 0; i < v_uids.Length; i++)
{
if (v_uids[i] != "")
{
//得到记录
DataTable dt = Hyoa_flowmain.Getflowmain(v_uids[i]);
if (dt.Rows.Count > 0)
{
//开始复制
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
Hyoa_flowmain.DOCID = Hyoa_global.GetRandom();
Hyoa_flowmain.hy_mudelid = dt.Rows[0]["hy_mudelid"].ToString();
Hyoa_flowmain.hy_tableid = dt.Rows[0]["hy_tableid"].ToString();
Hyoa_flowmain.hy_flowid = dt.Rows[0]["hy_flowid"].ToString();
Hyoa_flowmain.hy_flowname = dt.Rows[0]["hy_flowname"].ToString();
Hyoa_flowmain.hy_curtacheid = "";
Hyoa_flowmain.hy_curtachename = "";
Hyoa_flowmain.hy_curclrid = "";
Hyoa_flowmain.hy_curclrname = "";
Hyoa_flowmain.hy_djrid = dt.Rows[0]["hy_djrid"].ToString();
Hyoa_flowmain.hy_djrname = dt.Rows[0]["hy_djrname"].ToString();
Hyoa_flowmain.hy_djrbmid = dt.Rows[0]["hy_djrbmid"].ToString();
Hyoa_flowmain.hy_djrbmname = dt.Rows[0]["hy_djrbmname"].ToString();
Hyoa_flowmain.hy_djsj = dt.Rows[0]["hy_djsj"].ToString();
Hyoa_flowmain.hy_bt = dt.Rows[0]["hy_bt"].ToString();
Hyoa_flowmain.hy_content1 = dt.Rows[0]["hy_content1"].ToString();
Hyoa_flowmain.hy_content2 = dt.Rows[0]["hy_content2"].ToString();
Hyoa_flowmain.hy_content3 = dt.Rows[0]["hy_content3"].ToString();
Hyoa_flowmain.hy_content4 = dt.Rows[0]["hy_content4"].ToString();
Hyoa_flowmain.hy_content5 = dt.Rows[0]["hy_content5"].ToString();
Hyoa_flowmain.hy_field1 = dt.Rows[0]["hy_field1"].ToString();
Hyoa_flowmain.hy_field2 = dt.Rows[0]["hy_field2"].ToString();
Hyoa_flowmain.hy_field3 = dt.Rows[0]["hy_field3"].ToString();
Hyoa_flowmain.hy_field4 = dt.Rows[0]["hy_field4"].ToString();
Hyoa_flowmain.hy_field5 = dt.Rows[0]["hy_field5"].ToString();
Hyoa_flowmain.hy_field6 = dt.Rows[0]["hy_field6"].ToString();
Hyoa_flowmain.hy_field7 = dt.Rows[0]["hy_field7"].ToString();
Hyoa_flowmain.hy_field8 = dt.Rows[0]["hy_field8"].ToString();
Hyoa_flowmain.hy_field9 = dt.Rows[0]["hy_field9"].ToString();
Hyoa_flowmain.hy_field10 = dt.Rows[0]["hy_field10"].ToString();
Hyoa_flowmain.hy_field11 = dt.Rows[0]["hy_field11"].ToString();
Hyoa_flowmain.hy_field12 = dt.Rows[0]["hy_field12"].ToString();
Hyoa_flowmain.hy_field13 = dt.Rows[0]["hy_field13"].ToString();
Hyoa_flowmain.hy_field14 = dt.Rows[0]["hy_field14"].ToString();
Hyoa_flowmain.hy_field15 = dt.Rows[0]["hy_field15"].ToString();
Hyoa_flowmain.hy_field16 = dt.Rows[0]["hy_field16"].ToString();
Hyoa_flowmain.hy_field17 = dt.Rows[0]["hy_field17"].ToString();
Hyoa_flowmain.hy_field18 = dt.Rows[0]["hy_field18"].ToString();
Hyoa_flowmain.hy_field19 = dt.Rows[0]["hy_field19"].ToString();
Hyoa_flowmain.hy_field20 = dt.Rows[0]["hy_field20"].ToString();
Hyoa_flowmain.hy_field21 = dt.Rows[0]["hy_field21"].ToString();
Hyoa_flowmain.hy_field22 = dt.Rows[0]["hy_field22"].ToString();
Hyoa_flowmain.hy_field23 = dt.Rows[0]["hy_field23"].ToString();
Hyoa_flowmain.hy_field24 = dt.Rows[0]["hy_field24"].ToString();
Hyoa_flowmain.hy_field25 = dt.Rows[0]["hy_field25"].ToString();
Hyoa_flowmain.hy_field26 = dt.Rows[0]["hy_field26"].ToString();
Hyoa_flowmain.hy_field27 = dt.Rows[0]["hy_field27"].ToString();
Hyoa_flowmain.hy_field28 = dt.Rows[0]["hy_field28"].ToString();
Hyoa_flowmain.hy_field29 = dt.Rows[0]["hy_field29"].ToString();
Hyoa_flowmain.hy_field30 = dt.Rows[0]["hy_field30"].ToString();
Hyoa_flowmain.hy_field31 = dt.Rows[0]["hy_field31"].ToString();
Hyoa_flowmain.hy_field32 = dt.Rows[0]["hy_field32"].ToString();
Hyoa_flowmain.hy_field33 = dt.Rows[0]["hy_field33"].ToString();
Hyoa_flowmain.hy_field34 = dt.Rows[0]["hy_field34"].ToString();
Hyoa_flowmain.hy_field35 = dt.Rows[0]["hy_field35"].ToString();
Hyoa_flowmain.hy_field36 = float.Parse(dt.Rows[0]["hy_field36"].ToString());
Hyoa_flowmain.hy_field37 = float.Parse(dt.Rows[0]["hy_field37"].ToString());
Hyoa_flowmain.hy_field38 = float.Parse(dt.Rows[0]["hy_field38"].ToString());
Hyoa_flowmain.hy_field39 = float.Parse(dt.Rows[0]["hy_field39"].ToString());
Hyoa_flowmain.hy_field40 = float.Parse(dt.Rows[0]["hy_field40"].ToString());
Hyoa_flowmain.hy_field41 = dt.Rows[0]["hy_field41"].ToString();
Hyoa_flowmain.hy_field42 = dt.Rows[0]["hy_field42"].ToString();
Hyoa_flowmain.hy_field43 = dt.Rows[0]["hy_field43"].ToString();
Hyoa_flowmain.hy_field44 = dt.Rows[0]["hy_field44"].ToString();
Hyoa_flowmain.hy_field45 = dt.Rows[0]["hy_field45"].ToString();
Hyoa_flowmain.hy_field46 = dt.Rows[0]["hy_field46"].ToString();
Hyoa_flowmain.hy_field47 = dt.Rows[0]["hy_field47"].ToString();
Hyoa_flowmain.hy_field48 = dt.Rows[0]["hy_field48"].ToString();
Hyoa_flowmain.hy_field49 = dt.Rows[0]["hy_field49"].ToString();
Hyoa_flowmain.hy_field50 = dt.Rows[0]["hy_field50"].ToString();
Hyoa_flowmain.hy_field51 = dt.Rows[0]["hy_field51"].ToString();
Hyoa_flowmain.hy_field52 = dt.Rows[0]["hy_field52"].ToString();
Hyoa_flowmain.hy_field53 = dt.Rows[0]["hy_field53"].ToString();
Hyoa_flowmain.hy_field54 = dt.Rows[0]["hy_field54"].ToString();
Hyoa_flowmain.hy_field55 = dt.Rows[0]["hy_field55"].ToString();
Hyoa_flowmain.hy_field56 = dt.Rows[0]["hy_field56"].ToString();
Hyoa_flowmain.hy_field57 = dt.Rows[0]["hy_field57"].ToString();
Hyoa_flowmain.hy_field58 = dt.Rows[0]["hy_field58"].ToString();
Hyoa_flowmain.hy_field59 = dt.Rows[0]["hy_field59"].ToString();
Hyoa_flowmain.hy_field60 = dt.Rows[0]["hy_field60"].ToString();
Hyoa_flowmain.hy_field61 = dt.Rows[0]["hy_field61"].ToString();
Hyoa_flowmain.hy_field62 = dt.Rows[0]["hy_field62"].ToString();
Hyoa_flowmain.hy_field63 = dt.Rows[0]["hy_field63"].ToString();
Hyoa_flowmain.hy_field64 = dt.Rows[0]["hy_field64"].ToString();
Hyoa_flowmain.hy_field65 = dt.Rows[0]["hy_field65"].ToString();
Hyoa_flowmain.hy_field66 = dt.Rows[0]["hy_field66"].ToString();
Hyoa_flowmain.hy_field67 = dt.Rows[0]["hy_field67"].ToString();
Hyoa_flowmain.hy_field68 = dt.Rows[0]["hy_field68"].ToString();
Hyoa_flowmain.hy_field69 = dt.Rows[0]["hy_field69"].ToString();
Hyoa_flowmain.hy_field70 = dt.Rows[0]["hy_field70"].ToString();
Hyoa_flowmain.hy_field71 = float.Parse(dt.Rows[0]["hy_field71"].ToString());
Hyoa_flowmain.hy_field72 = float.Parse(dt.Rows[0]["hy_field72"].ToString());
Hyoa_flowmain.hy_field73 = float.Parse(dt.Rows[0]["hy_field73"].ToString());
Hyoa_flowmain.hy_field74 = float.Parse(dt.Rows[0]["hy_field74"].ToString());
Hyoa_flowmain.hy_field75 = float.Parse(dt.Rows[0]["hy_field75"].ToString());
Hyoa_flowmain.hy_field76 = float.Parse(dt.Rows[0]["hy_field76"].ToString());
Hyoa_flowmain.hy_field77 = float.Parse(dt.Rows[0]["hy_field77"].ToString());
Hyoa_flowmain.hy_field78 = float.Parse(dt.Rows[0]["hy_field78"].ToString());
Hyoa_flowmain.hy_field79 = float.Parse(dt.Rows[0]["hy_field79"].ToString());
Hyoa_flowmain.hy_field80 = float.Parse(dt.Rows[0]["hy_field80"].ToString());
Hyoa_flowmain.hy_field81 = float.Parse(dt.Rows[0]["hy_field81"].ToString());
Hyoa_flowmain.hy_field82 = float.Parse(dt.Rows[0]["hy_field82"].ToString());
Hyoa_flowmain.hy_field83 = float.Parse(dt.Rows[0]["hy_field83"].ToString());
Hyoa_flowmain.hy_field84 = float.Parse(dt.Rows[0]["hy_field84"].ToString());
Hyoa_flowmain.hy_field85 = float.Parse(dt.Rows[0]["hy_field85"].ToString());
Hyoa_flowmain.hy_field86 = float.Parse(dt.Rows[0]["hy_field86"].ToString());
Hyoa_flowmain.hy_field87 = float.Parse(dt.Rows[0]["hy_field87"].ToString());
Hyoa_flowmain.hy_field88 = float.Parse(dt.Rows[0]["hy_field88"].ToString());
Hyoa_flowmain.hy_field89 = float.Parse(dt.Rows[0]["hy_field89"].ToString());
Hyoa_flowmain.hy_field90 = float.Parse(dt.Rows[0]["hy_field90"].ToString());
Hyoa_flowmain.hy_field91 = float.Parse(dt.Rows[0]["hy_field91"].ToString());
Hyoa_flowmain.hy_field92 = float.Parse(dt.Rows[0]["hy_field92"].ToString());
Hyoa_flowmain.hy_field93 = float.Parse(dt.Rows[0]["hy_field93"].ToString());
Hyoa_flowmain.hy_field94 = float.Parse(dt.Rows[0]["hy_field94"].ToString());
Hyoa_flowmain.hy_field95 = float.Parse(dt.Rows[0]["hy_field95"].ToString());
Hyoa_flowmain.hy_field96 = float.Parse(dt.Rows[0]["hy_field96"].ToString());
Hyoa_flowmain.hy_field97 = float.Parse(dt.Rows[0]["hy_field97"].ToString());
Hyoa_flowmain.hy_field98 = float.Parse(dt.Rows[0]["hy_field98"].ToString());
Hyoa_flowmain.hy_field99 = float.Parse(dt.Rows[0]["hy_field99"].ToString());
Hyoa_flowmain.hy_field100 = float.Parse(dt.Rows[0]["hy_field100"].ToString());
Hyoa_flowmain.hy_iftx = dt.Rows[0]["hy_iftx"].ToString();
Hyoa_flowmain.hy_zhtxsj = dt.Rows[0]["hy_zhtxsj"].ToString();
Hyoa_flowmain.hy_readuserlist = dt.Rows[0]["hy_readuserlist"].ToString();
Hyoa_flowmain.Insert();
}
}
}
this.txtuids.Value = "";
DataPlay(System.Int32.Parse(this.curpage.Text));
}
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//保存
protected void Button_Save_Click(object sender, EventArgs e)
{
if (this.Session["hyuid"].ToString() == "")
this.Response.Redirect("/login.aspx");
string ls_tip = "保存成功！";
//新文档时
//新建时先进行一次保存
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
if (this.txtop.Value == "add")
{
#region 字段信息
Hyoa_flowmain.DOCID = this.txtdocid.Value;
Hyoa_flowmain.hy_mudelid = this.hy_mudelid.Text;
Hyoa_flowmain.hy_tableid = this.hy_tableid.Text;
Hyoa_flowmain.hy_flowid = this.hy_flowid.Text;
Hyoa_flowmain.hy_flowname = this.hy_flowname.Text;
Hyoa_flowmain.hy_curtacheid = this.hy_curtacheid.Text;
Hyoa_flowmain.hy_curtachename = this.hy_curtachename.Text;
Hyoa_flowmain.hy_curclrid = this.hy_curclrid.Text;
Hyoa_flowmain.hy_curclrname = this.hy_curclrname.Text;
Hyoa_flowmain.hy_djrid = this.hy_djrid.Text;
Hyoa_flowmain.hy_djrname = this.hy_djrname.Text;
Hyoa_flowmain.hy_djrbmid = this.hy_djrbmid.Text;
Hyoa_flowmain.hy_djrbmname = this.hy_djrbmname.Text;
Hyoa_flowmain.hy_djsj = this.hy_djsj.Text;
Hyoa_flowmain.hy_bt = this.hy_bt.Text;
Hyoa_flowmain.hy_content1 = this.hy_content1.Text;
Hyoa_flowmain.hy_content2 = this.hy_content2.Text;
Hyoa_flowmain.hy_content3 = this.hy_content3.Text;
Hyoa_flowmain.hy_content4 = this.hy_content4.Text;
Hyoa_flowmain.hy_content5 = this.hy_content5.Text;
Hyoa_flowmain.hy_content6 = this.hy_content6.Text;
Hyoa_flowmain.hy_content7 = this.hy_content7.Text;
Hyoa_flowmain.hy_content8 = this.hy_content8.Text;
Hyoa_flowmain.hy_content9 = this.hy_content9.Text;
Hyoa_flowmain.hy_content10 = this.hy_content10.Text;
Hyoa_flowmain.hy_content11 = this.hy_content11.Text;
Hyoa_flowmain.hy_content12 = this.hy_content12.Text;
Hyoa_flowmain.hy_content13 = this.hy_content13.Text;
Hyoa_flowmain.hy_content14 = this.hy_content14.Text;
Hyoa_flowmain.hy_content15 = this.hy_content15.Text;
Hyoa_flowmain.hy_field1 = this.hy_field1.Text;
Hyoa_flowmain.hy_field2 = this.hy_field2.Text;
Hyoa_flowmain.hy_field3 = this.hy_field3.Text;
Hyoa_flowmain.hy_field4 = this.hy_field4.Text;
Hyoa_flowmain.hy_field5 = this.hy_field5.Text;
Hyoa_flowmain.hy_field6 = this.hy_field6.Text;
Hyoa_flowmain.hy_field7 = this.hy_field7.Text;
Hyoa_flowmain.hy_field8 = this.hy_field8.Text;
Hyoa_flowmain.hy_field9 = this.hy_field9.Text;
Hyoa_flowmain.hy_field10 = this.hy_field10.Text;
Hyoa_flowmain.hy_field11 = this.hy_field11.Text;
Hyoa_flowmain.hy_field12 = this.hy_field12.Text;
Hyoa_flowmain.hy_field13 = this.hy_field13.Text;
Hyoa_flowmain.hy_field14 = this.hy_field14.Text;
Hyoa_flowmain.hy_field15 = this.hy_field15.Text;
Hyoa_flowmain.hy_field16 = this.hy_field16.Text;
Hyoa_flowmain.hy_field17 = this.hy_field17.Text;
Hyoa_flowmain.hy_field18 = this.hy_field18.Text;
Hyoa_flowmain.hy_field19 = this.hy_field19.Text;
Hyoa_flowmain.hy_field20 = this.hy_field20.Text;
Hyoa_flowmain.hy_field21 = this.hy_field21.Text;
Hyoa_flowmain.hy_field22 = this.hy_field22.Text;
Hyoa_flowmain.hy_field23 = this.hy_field23.Text;
Hyoa_flowmain.hy_field24 = this.hy_field24.Text;
Hyoa_flowmain.hy_field25 = this.hy_field25.Text;
Hyoa_flowmain.hy_field26 = this.hy_field26.Text;
Hyoa_flowmain.hy_field27 = this.hy_field27.Text;
Hyoa_flowmain.hy_field28 = this.hy_field28.Text;
Hyoa_flowmain.hy_field29 = this.hy_field29.Text;
Hyoa_flowmain.hy_field30 = this.hy_field30.Text;
Hyoa_flowmain.hy_field31 = this.hy_field31.Text;
Hyoa_flowmain.hy_field32 = this.hy_field32.Text;
Hyoa_flowmain.hy_field33 = this.hy_field33.Text;
Hyoa_flowmain.hy_field34 = this.hy_field34.Text;
Hyoa_flowmain.hy_field35 = this.hy_field35.Text;
if (this.hy_field36.Text == "")
Hyoa_flowmain.hy_field36 = 0;
else
Hyoa_flowmain.hy_field36 = float.Parse(this.hy_field36.Text);
if (this.hy_field37.Text == "")
Hyoa_flowmain.hy_field37 = 0;
else
Hyoa_flowmain.hy_field37 = float.Parse(this.hy_field37.Text);
if (this.hy_field38.Text == "")
Hyoa_flowmain.hy_field38 = 0;
else
Hyoa_flowmain.hy_field38 = float.Parse(this.hy_field38.Text);
if (this.hy_field39.Text == "")
Hyoa_flowmain.hy_field39 = 0;
else
Hyoa_flowmain.hy_field39 = float.Parse(this.hy_field39.Text);
if (this.hy_field40.Text == "")
Hyoa_flowmain.hy_field40 = 0;
else
Hyoa_flowmain.hy_field40 = float.Parse(this.hy_field40.Text);
Hyoa_flowmain.hy_field41 = this.hy_field41.Text;
Hyoa_flowmain.hy_field42 = this.hy_field42.Text;
Hyoa_flowmain.hy_field43 = this.hy_field43.Text;
Hyoa_flowmain.hy_field44 = this.hy_field44.Text;
Hyoa_flowmain.hy_field45 = this.hy_field45.Text;
Hyoa_flowmain.hy_field46 = this.hy_field46.Text;
Hyoa_flowmain.hy_field47 = this.hy_field47.Text;
Hyoa_flowmain.hy_field48 = this.hy_field48.Text;
Hyoa_flowmain.hy_field49 = this.hy_field49.Text;
Hyoa_flowmain.hy_field50 = this.hy_field50.Text;
Hyoa_flowmain.hy_field51 = this.hy_field51.Text;
Hyoa_flowmain.hy_field52 = this.hy_field52.Text;
Hyoa_flowmain.hy_field53 = this.hy_field53.Text;
Hyoa_flowmain.hy_field54 = this.hy_field54.Text;
Hyoa_flowmain.hy_field55 = this.hy_field55.Text;
Hyoa_flowmain.hy_field56 = this.hy_field56.Text;
Hyoa_flowmain.hy_field57 = this.hy_field57.Text;
Hyoa_flowmain.hy_field58 = this.hy_field58.Text;
Hyoa_flowmain.hy_field59 = this.hy_field59.Text;
Hyoa_flowmain.hy_field60 = this.hy_field60.Text;
Hyoa_flowmain.hy_field61 = this.hy_field61.Text;
Hyoa_flowmain.hy_field62 = this.hy_field62.Text;
Hyoa_flowmain.hy_field63 = this.hy_field63.Text;
Hyoa_flowmain.hy_field64 = this.hy_field64.Text;
Hyoa_flowmain.hy_field65 = this.hy_field65.Text;
Hyoa_flowmain.hy_field66 = this.hy_field66.Text;
Hyoa_flowmain.hy_field67 = this.hy_field67.Text;
Hyoa_flowmain.hy_field68 = this.hy_field68.Text;
Hyoa_flowmain.hy_field69 = this.hy_field69.Text;
Hyoa_flowmain.hy_field70 = this.hy_field70.Text;
if (this.hy_field71.Text == "")
Hyoa_flowmain.hy_field71 = 0;
else
Hyoa_flowmain.hy_field71 = float.Parse(this.hy_field71.Text);
if (this.hy_field72.Text == "")
Hyoa_flowmain.hy_field72 = 0;
else
Hyoa_flowmain.hy_field72 = float.Parse(this.hy_field72.Text);
if (this.hy_field73.Text == "")
Hyoa_flowmain.hy_field73 = 0;
else
Hyoa_flowmain.hy_field73 = float.Parse(this.hy_field73.Text);
if (this.hy_field74.Text == "")
Hyoa_flowmain.hy_field74 = 0;
else
Hyoa_flowmain.hy_field74 = float.Parse(this.hy_field74.Text);
if (this.hy_field75.Text == "")
Hyoa_flowmain.hy_field75 = 0;
else
Hyoa_flowmain.hy_field75 = float.Parse(this.hy_field75.Text);
if (this.hy_field76.Text == "")
Hyoa_flowmain.hy_field76 = 0;
else
Hyoa_flowmain.hy_field76 = float.Parse(this.hy_field76.Text);
if (this.hy_field77.Text == "")
Hyoa_flowmain.hy_field77 = 0;
else
Hyoa_flowmain.hy_field77 = float.Parse(this.hy_field77.Text);
if (this.hy_field78.Text == "")
Hyoa_flowmain.hy_field78 = 0;
else
Hyoa_flowmain.hy_field78 = float.Parse(this.hy_field78.Text);
if (this.hy_field79.Text == "")
Hyoa_flowmain.hy_field79 = 0;
else
Hyoa_flowmain.hy_field79 = float.Parse(this.hy_field79.Text);
if (this.hy_field80.Text == "")
Hyoa_flowmain.hy_field80 = 0;
else
Hyoa_flowmain.hy_field80 = float.Parse(this.hy_field80.Text);
if (this.hy_field81.Text == "")
Hyoa_flowmain.hy_field81 = 0;
else
Hyoa_flowmain.hy_field81 = float.Parse(this.hy_field81.Text);
if (this.hy_field82.Text == "")
Hyoa_flowmain.hy_field82 = 0;
else
Hyoa_flowmain.hy_field82 = float.Parse(this.hy_field82.Text);
if (this.hy_field83.Text == "")
Hyoa_flowmain.hy_field83 = 0;
else
Hyoa_flowmain.hy_field83 = float.Parse(this.hy_field83.Text);
if (this.hy_field84.Text == "")
Hyoa_flowmain.hy_field84 = 0;
else
Hyoa_flowmain.hy_field84 = float.Parse(this.hy_field84.Text);
if (this.hy_field85.Text == "")
Hyoa_flowmain.hy_field85 = 0;
else
Hyoa_flowmain.hy_field85 = float.Parse(this.hy_field85.Text);
if (this.hy_field86.Text == "")
Hyoa_flowmain.hy_field86 = 0;
else
Hyoa_flowmain.hy_field86 = float.Parse(this.hy_field86.Text);
if (this.hy_field87.Text == "")
Hyoa_flowmain.hy_field87 = 0;
else
Hyoa_flowmain.hy_field87 = float.Parse(this.hy_field87.Text);
if (this.hy_field88.Text == "")
Hyoa_flowmain.hy_field88 = 0;
else
Hyoa_flowmain.hy_field88 = float.Parse(this.hy_field88.Text);
if (this.hy_field89.Text == "")
Hyoa_flowmain.hy_field89 = 0;
else
Hyoa_flowmain.hy_field89 = float.Parse(this.hy_field89.Text);
if (this.hy_field90.Text == "")
Hyoa_flowmain.hy_field90 = 0;
else
Hyoa_flowmain.hy_field90 = float.Parse(this.hy_field90.Text);
if (this.hy_field91.Text == "")
Hyoa_flowmain.hy_field91 = 0;
else
Hyoa_flowmain.hy_field91 = float.Parse(this.hy_field91.Text);
if (this.hy_field92.Text == "")
Hyoa_flowmain.hy_field92 = 0;
else
Hyoa_flowmain.hy_field92 = float.Parse(this.hy_field92.Text);
if (this.hy_field93.Text == "")
Hyoa_flowmain.hy_field93 = 0;
else
Hyoa_flowmain.hy_field93 = float.Parse(this.hy_field93.Text);
if (this.hy_field94.Text == "")
Hyoa_flowmain.hy_field94 = 0;
else
Hyoa_flowmain.hy_field94 = float.Parse(this.hy_field94.Text);
if (this.hy_field95.Text == "")
Hyoa_flowmain.hy_field95 = 0;
else
Hyoa_flowmain.hy_field95 = float.Parse(this.hy_field95.Text);
if (this.hy_field96.Text == "")
Hyoa_flowmain.hy_field96 = 0;
else
Hyoa_flowmain.hy_field96 = float.Parse(this.hy_field96.Text);
if (this.hy_field97.Text == "")
Hyoa_flowmain.hy_field97 = 0;
else
Hyoa_flowmain.hy_field97 = float.Parse(this.hy_field97.Text);
if (this.hy_field98.Text == "")
Hyoa_flowmain.hy_field98 = 0;
else
Hyoa_flowmain.hy_field98 = float.Parse(this.hy_field98.Text);
if (this.hy_field99.Text == "")
Hyoa_flowmain.hy_field99 = 0;
else
Hyoa_flowmain.hy_field99 = float.Parse(this.hy_field99.Text);
if (this.hy_field100.Text == "")
Hyoa_flowmain.hy_field100 = 0;
else
Hyoa_flowmain.hy_field100 = float.Parse(this.hy_field100.Text);
Hyoa_flowmain.hy_iftx = this.hy_iftx.Text;
Hyoa_flowmain.hy_zhtxsj = this.hy_zhtxsj.Text;
Hyoa_flowmain.hy_readuserlist = this.hy_readuserlist.Text;
#endregion
Hyoa_flowmain.Insert();
//插入历史处理表
HyoaClass.Hyoa_global Hyoa_global_add = new HyoaClass.Hyoa_global();
Hyoa_global_add.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.hy_curtacheid.Text, this.hy_curtachename.Text, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "", "", "", this.hy_djsj.Text, "");
}
#region 更新内容
Hyoa_flowmain.DOCID = this.txtdocid.Value;
Hyoa_flowmain.hy_curtacheid = this.hy_curtacheid.Text;
Hyoa_flowmain.hy_curtachename = this.hy_curtachename.Text;
Hyoa_flowmain.hy_curclrid = this.hy_curclrid.Text;
Hyoa_flowmain.hy_curclrname = this.hy_curclrname.Text;
Hyoa_flowmain.hy_bt = this.hy_bt.Text;
Hyoa_flowmain.hy_content1 = this.hy_content1.Text;
Hyoa_flowmain.hy_content2 = this.hy_content2.Text;
Hyoa_flowmain.hy_content3 = this.hy_content3.Text;
Hyoa_flowmain.hy_content4 = this.hy_content4.Text;
Hyoa_flowmain.hy_content5 = this.hy_content5.Text;
Hyoa_flowmain.hy_content6 = this.hy_content6.Text;
Hyoa_flowmain.hy_content7 = this.hy_content7.Text;
Hyoa_flowmain.hy_content8 = this.hy_content8.Text;
Hyoa_flowmain.hy_content9 = this.hy_content9.Text;
Hyoa_flowmain.hy_content10 = this.hy_content10.Text;
Hyoa_flowmain.hy_content11 = this.hy_content11.Text;
Hyoa_flowmain.hy_content12 = this.hy_content12.Text;
Hyoa_flowmain.hy_content13 = this.hy_content13.Text;
Hyoa_flowmain.hy_content14 = this.hy_content14.Text;
Hyoa_flowmain.hy_content15 = this.hy_content15.Text;
Hyoa_flowmain.hy_field1 = this.hy_field1.Text;
Hyoa_flowmain.hy_field2 = this.hy_field2.Text;
Hyoa_flowmain.hy_field3 = this.hy_field3.Text;
Hyoa_flowmain.hy_field4 = this.hy_field4.Text;
Hyoa_flowmain.hy_field5 = this.hy_field5.Text;
Hyoa_flowmain.hy_field6 = this.hy_field6.Text;
Hyoa_flowmain.hy_field7 = this.hy_field7.Text;
Hyoa_flowmain.hy_field8 = this.hy_field8.Text;
Hyoa_flowmain.hy_field9 = this.hy_field9.Text;
Hyoa_flowmain.hy_field10 = this.hy_field10.Text;
Hyoa_flowmain.hy_field11 = this.hy_field11.Text;
Hyoa_flowmain.hy_field12 = this.hy_field12.Text;
Hyoa_flowmain.hy_field13 = this.hy_field13.Text;
Hyoa_flowmain.hy_field14 = this.hy_field14.Text;
Hyoa_flowmain.hy_field15 = this.hy_field15.Text;
Hyoa_flowmain.hy_field16 = this.hy_field16.Text;
Hyoa_flowmain.hy_field17 = this.hy_field17.Text;
Hyoa_flowmain.hy_field18 = this.hy_field18.Text;
Hyoa_flowmain.hy_field19 = this.hy_field19.Text;
Hyoa_flowmain.hy_field20 = this.hy_field20.Text;
Hyoa_flowmain.hy_field21 = this.hy_field21.Text;
Hyoa_flowmain.hy_field22 = this.hy_field22.Text;
Hyoa_flowmain.hy_field23 = this.hy_field23.Text;
Hyoa_flowmain.hy_field24 = this.hy_field24.Text;
Hyoa_flowmain.hy_field25 = this.hy_field25.Text;
Hyoa_flowmain.hy_field26 = this.hy_field26.Text;
Hyoa_flowmain.hy_field27 = this.hy_field27.Text;
Hyoa_flowmain.hy_field28 = this.hy_field28.Text;
Hyoa_flowmain.hy_field29 = this.hy_field29.Text;
Hyoa_flowmain.hy_field30 = this.hy_field30.Text;
Hyoa_flowmain.hy_field31 = this.hy_field31.Text;
Hyoa_flowmain.hy_field32 = this.hy_field32.Text;
Hyoa_flowmain.hy_field33 = this.hy_field33.Text;
Hyoa_flowmain.hy_field34 = this.hy_field34.Text;
Hyoa_flowmain.hy_field35 = this.hy_field35.Text;
if (this.hy_field36.Text == "")
Hyoa_flowmain.hy_field36 = 0;
else
Hyoa_flowmain.hy_field36 = float.Parse(this.hy_field36.Text);
if (this.hy_field37.Text == "")
Hyoa_flowmain.hy_field37 = 0;
else
Hyoa_flowmain.hy_field37 = float.Parse(this.hy_field37.Text);
if (this.hy_field38.Text == "")
Hyoa_flowmain.hy_field38 = 0;
else
Hyoa_flowmain.hy_field38 = float.Parse(this.hy_field38.Text);
if (this.hy_field39.Text == "")
Hyoa_flowmain.hy_field39 = 0;
else
Hyoa_flowmain.hy_field39 = float.Parse(this.hy_field39.Text);
if (this.hy_field40.Text == "")
Hyoa_flowmain.hy_field40 = 0;
else
Hyoa_flowmain.hy_field40 = float.Parse(this.hy_field40.Text);
Hyoa_flowmain.hy_field41 = this.hy_field41.Text;
Hyoa_flowmain.hy_field42 = this.hy_field42.Text;
Hyoa_flowmain.hy_field43 = this.hy_field43.Text;
Hyoa_flowmain.hy_field44 = this.hy_field44.Text;
Hyoa_flowmain.hy_field45 = this.hy_field45.Text;
Hyoa_flowmain.hy_field46 = this.hy_field46.Text;
Hyoa_flowmain.hy_field47 = this.hy_field47.Text;
Hyoa_flowmain.hy_field48 = this.hy_field48.Text;
Hyoa_flowmain.hy_field49 = this.hy_field49.Text;
Hyoa_flowmain.hy_field50 = this.hy_field50.Text;
Hyoa_flowmain.hy_field51 = this.hy_field51.Text;
Hyoa_flowmain.hy_field52 = this.hy_field52.Text;
Hyoa_flowmain.hy_field53 = this.hy_field53.Text;
Hyoa_flowmain.hy_field54 = this.hy_field54.Text;
Hyoa_flowmain.hy_field55 = this.hy_field55.Text;
Hyoa_flowmain.hy_field56 = this.hy_field56.Text;
Hyoa_flowmain.hy_field57 = this.hy_field57.Text;
Hyoa_flowmain.hy_field58 = this.hy_field58.Text;
Hyoa_flowmain.hy_field59 = this.hy_field59.Text;
Hyoa_flowmain.hy_field60 = this.hy_field60.Text;
Hyoa_flowmain.hy_field61 = this.hy_field61.Text;
Hyoa_flowmain.hy_field62 = this.hy_field62.Text;
Hyoa_flowmain.hy_field63 = this.hy_field63.Text;
Hyoa_flowmain.hy_field64 = this.hy_field64.Text;
Hyoa_flowmain.hy_field65 = this.hy_field65.Text;
Hyoa_flowmain.hy_field66 = this.hy_field66.Text;
Hyoa_flowmain.hy_field67 = this.hy_field67.Text;
Hyoa_flowmain.hy_field68 = this.hy_field68.Text;
Hyoa_flowmain.hy_field69 = this.hy_field69.Text;
Hyoa_flowmain.hy_field70 = this.hy_field70.Text;
if (this.hy_field71.Text == "")
Hyoa_flowmain.hy_field71 = 0;
else
Hyoa_flowmain.hy_field71 = float.Parse(this.hy_field71.Text);
if (this.hy_field72.Text == "")
Hyoa_flowmain.hy_field72 = 0;
else
Hyoa_flowmain.hy_field72 = float.Parse(this.hy_field72.Text);
if (this.hy_field73.Text == "")
Hyoa_flowmain.hy_field73 = 0;
else
Hyoa_flowmain.hy_field73 = float.Parse(this.hy_field73.Text);
if (this.hy_field74.Text == "")
Hyoa_flowmain.hy_field74 = 0;
else
Hyoa_flowmain.hy_field74 = float.Parse(this.hy_field74.Text);
if (this.hy_field75.Text == "")
Hyoa_flowmain.hy_field75 = 0;
else
Hyoa_flowmain.hy_field75 = float.Parse(this.hy_field75.Text);
if (this.hy_field76.Text == "")
Hyoa_flowmain.hy_field76 = 0;
else
Hyoa_flowmain.hy_field76 = float.Parse(this.hy_field76.Text);
if (this.hy_field77.Text == "")
Hyoa_flowmain.hy_field77 = 0;
else
Hyoa_flowmain.hy_field77 = float.Parse(this.hy_field77.Text);
if (this.hy_field78.Text == "")
Hyoa_flowmain.hy_field78 = 0;
else
Hyoa_flowmain.hy_field78 = float.Parse(this.hy_field78.Text);
if (this.hy_field79.Text == "")
Hyoa_flowmain.hy_field79 = 0;
else
Hyoa_flowmain.hy_field79 = float.Parse(this.hy_field79.Text);
if (this.hy_field80.Text == "")
Hyoa_flowmain.hy_field80 = 0;
else
Hyoa_flowmain.hy_field80 = float.Parse(this.hy_field80.Text);
if (this.hy_field81.Text == "")
Hyoa_flowmain.hy_field81 = 0;
else
Hyoa_flowmain.hy_field81 = float.Parse(this.hy_field81.Text);
if (this.hy_field82.Text == "")
Hyoa_flowmain.hy_field82 = 0;
else
Hyoa_flowmain.hy_field82 = float.Parse(this.hy_field82.Text);
if (this.hy_field83.Text == "")
Hyoa_flowmain.hy_field83 = 0;
else
Hyoa_flowmain.hy_field83 = float.Parse(this.hy_field83.Text);
if (this.hy_field84.Text == "")
Hyoa_flowmain.hy_field84 = 0;
else
Hyoa_flowmain.hy_field84 = float.Parse(this.hy_field84.Text);
if (this.hy_field85.Text == "")
Hyoa_flowmain.hy_field85 = 0;
else
Hyoa_flowmain.hy_field85 = float.Parse(this.hy_field85.Text);
if (this.hy_field86.Text == "")
Hyoa_flowmain.hy_field86 = 0;
else
Hyoa_flowmain.hy_field86 = float.Parse(this.hy_field86.Text);
if (this.hy_field87.Text == "")
Hyoa_flowmain.hy_field87 = 0;
else
Hyoa_flowmain.hy_field87 = float.Parse(this.hy_field87.Text);
if (this.hy_field88.Text == "")
Hyoa_flowmain.hy_field88 = 0;
else
Hyoa_flowmain.hy_field88 = float.Parse(this.hy_field88.Text);
if (this.hy_field89.Text == "")
Hyoa_flowmain.hy_field89 = 0;
else
Hyoa_flowmain.hy_field89 = float.Parse(this.hy_field89.Text);
if (this.hy_field90.Text == "")
Hyoa_flowmain.hy_field90 = 0;
else
Hyoa_flowmain.hy_field90 = float.Parse(this.hy_field90.Text);
if (this.hy_field91.Text == "")
Hyoa_flowmain.hy_field91 = 0;
else
Hyoa_flowmain.hy_field91 = float.Parse(this.hy_field91.Text);
if (this.hy_field92.Text == "")
Hyoa_flowmain.hy_field92 = 0;
else
Hyoa_flowmain.hy_field92 = float.Parse(this.hy_field92.Text);
if (this.hy_field93.Text == "")
Hyoa_flowmain.hy_field93 = 0;
else
Hyoa_flowmain.hy_field93 = float.Parse(this.hy_field93.Text);
if (this.hy_field94.Text == "")
Hyoa_flowmain.hy_field94 = 0;
else
Hyoa_flowmain.hy_field94 = float.Parse(this.hy_field94.Text);
if (this.hy_field95.Text == "")
Hyoa_flowmain.hy_field95 = 0;
else
Hyoa_flowmain.hy_field95 = float.Parse(this.hy_field95.Text);
if (this.hy_field96.Text == "")
Hyoa_flowmain.hy_field96 = 0;
else
Hyoa_flowmain.hy_field96 = float.Parse(this.hy_field96.Text);
if (this.hy_field97.Text == "")
Hyoa_flowmain.hy_field97 = 0;
else
Hyoa_flowmain.hy_field97 = float.Parse(this.hy_field97.Text);
if (this.hy_field98.Text == "")
Hyoa_flowmain.hy_field98 = 0;
else
Hyoa_flowmain.hy_field98 = float.Parse(this.hy_field98.Text);
if (this.hy_field99.Text == "")
Hyoa_flowmain.hy_field99 = 0;
else
Hyoa_flowmain.hy_field99 = float.Parse(this.hy_field99.Text);
if (this.hy_field100.Text == "")
Hyoa_flowmain.hy_field100 = 0;
else
Hyoa_flowmain.hy_field100 = float.Parse(this.hy_field100.Text);
Hyoa_flowmain.hy_iftx = this.hy_iftx.Text;
Hyoa_flowmain.hy_zhtxsj = this.hy_zhtxsj.Text;
Hyoa_flowmain.hy_readuserlist = this.hy_readuserlist.Text;
#endregion
//保存
if (this.txtwhichoperation.Value == "1")
{
hylcbctscl(Hyoa_flowmain);//特殊处理
//效能系统日志20150603
if (this.txtop.Value == "add")
{
hyXnxtSaveLogs("撰写", "表单：" + this.lblcurtachenameshow.Text + "新增一条记录", "新增");
}
else if (this.txtop.Value == "modify")
{
hyXnxtSaveLogs("修改", "表单：" + this.lblcurtachenameshow.Text + "修改一条记录", "修改");
}
if (this.hy_tableid.Text == "f1265875-5494-465f-ac33-6fa43d208c8f" && this.txtop.Value == "add")
{
string strAuthor = "";
string strAuthorDept = "";
if (this.hy_field6.Text != "")
{
strAuthor += this.hy_field6.Text + ",";
}
if (this.hy_field5.Text != "")
{
strAuthorDept += this.hy_field5.Text + ",";
}
hyXnxtMessageLogs("录用", "录用一篇文章", strAuthor, strAuthorDept);
}
}
//提交
if (this.txtwhichoperation.Value == "2")
{
//更新主文档
Hyoa_flowmain.hy_curtacheid = this.txtnexttacheid.Value;
Hyoa_flowmain.hy_curtachename = this.txtnexttachename.Value;
Hyoa_flowmain.hy_curclrid = this.txtnextclrid.Value;
Hyoa_flowmain.hy_curclrname = this.txtnextclrname.Value;
//---- 添加当前环节的处理时间 ---- start
HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocidtacheid(this.txtdocid.Value, this.hy_curtacheid.Text);
if (dt_clinfo.Rows.Count > 0)
{
string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID
Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc;
if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "")
{
Hyoa_flowhistoryinfo_cl.hy_clsj = System.DateTime.Now.ToString();
}
else
{
Hyoa_flowhistoryinfo_cl.hy_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString();
}
Hyoa_flowhistoryinfo_cl.Update();
}
//---- 添加当前环节的处理时间 ---- end
//--- 创建后续处理的处理记录+建立处理人待办事宜 ---- start
Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", this.txtnextcyrid.Value, this.txtnextcyrname.Value, System.DateTime.Now.ToString(), "");
//待办事宜、短信、即时消息
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' });
string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' });
for (var i = 0; i < lv_dbrid.Length; i++)
{
if (lv_dbrid[i].ToString() != "")
{
//得到当前用户手机号
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString());
//得到后续处理人手机号
string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString());
//给后续处理人发送一个新的待办事宜（提醒）
Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value);
//给后续处理人发送即时消息（提醒）
if (this.txtisSendjstx_clr.Value == "1")
{
Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0);
}
//给后续处理人发送短信（提醒）
if (this.txtisSendsms_clr.Value == "1")
{
Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0);
}
}
}
//--- 创建后续处理的处理记录+建立处理人待办事宜 ---- end
//--- 创建后续传阅记录+建立待办事宜 ---- start
string[] lv_cyrid = this.txtnextcyrid.Value.Split(new Char[] { ',' });
string[] lv_cyrname = this.txtnextcyrname.Value.Split(new Char[] { ',' });
for (var i = 0; i < lv_cyrid.Length; i++)
{
if (lv_cyrid[i].ToString() != "")
{
//建立传阅数据
Hyoa_global.Saveflowhistoryinfo_cy_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), "", System.DateTime.Now.ToString());
//待办事宜、短信、即时消息
//得到当前用户手机号
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString());
//得到后续传阅人手机号
string cb_cyrsjh = Hyoa_user.GetMobilebyuserid(lv_cyrid[i].ToString());
//给后续处理人发送一个新的待办事宜（提醒）
Hyoa_global.Senddbsy_global(this.txtdocid.Value, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待阅", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请阅读", 0, this.hy_flowid.Text, this.txtnexttacheid.Value);
//给后续处理人发送即时消息（提醒）
if (this.txtisSendjstx_cyr.Value == "1")
{
Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0);
}
//给后续处理人发送短信（提醒）
if (this.txtisSendsms_cyr.Value == "1")
{
Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_cyrid[i].ToString(), lv_cyrname[i].ToString(), cb_cyrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0);
}
}
}
//效能办公系统传阅数据
hyXnxtFlowLogs("文章发送给" + this.txtnextcyrname.Value + "阅读", "传阅");
//--- 创建后续传阅记录+建立待办事宜 ---- end
//--- 当前处理人的待办事宜转已办 ---- start
Hyoa_dbsy.Dbsytoybbydocidtacheiduserid(this.txtdocid.Value, this.hy_curtacheid.Text, this.Session["hyuid"].ToString());
//--- 当前处理人的待办事宜转已办 ---- end
ls_tip = "文档已成功发送到[" + this.txtnexttachename.Value + "]环节";
hylctjtscl(Hyoa_flowmain);//特殊处理
}
//收回
if (this.txtwhichoperation.Value == "3")
{
//得到上个环节处理人
HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl();
DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value);
if (dt_clinfo.Rows.Count > 1)
{
//删除当前处理人员的待办事宜
HyoaClass.Hyoa_dbsy Hyoa_dbsy_sh = new HyoaClass.Hyoa_dbsy();
Hyoa_dbsy_sh.DeleteByDocid_flowid_tacheid_userid(this.txtdocid.Value, dt_clinfo.Rows[0]["hy_flowid"].ToString(), dt_clinfo.Rows[0]["hy_tacheid"].ToString(), dt_clinfo.Rows[0]["hy_clrid"].ToString());
string ls_lastclrid = dt_clinfo.Rows[1]["hy_clrid"].ToString(); //上个环节处理人ID
string ls_lastclrname = dt_clinfo.Rows[1]["hy_clrname"].ToString(); //上个环节处理人中文名
string ls_lastcldoc = dt_clinfo.Rows[1]["ID"].ToString(); //上个环节处理的记录ID
string ls_lasttacheid = dt_clinfo.Rows[1]["hy_tacheid"].ToString(); //上个环节处理环节ID
string ls_lasttachename = dt_clinfo.Rows[1]["hy_tachename"].ToString(); //上个环节处理环节名称
string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID
dt_clinfo.Clear();
//删除当前处理的记录
Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc;
Hyoa_flowhistoryinfo_cl.Delete();
//清空上个环节处理时间，更新创建时间
Hyoa_flowhistoryinfo_cl.ID = ls_lastcldoc;
Hyoa_flowhistoryinfo_cl.hy_clsj = "";
Hyoa_flowhistoryinfo_cl.hy_createtime = System.DateTime.Now.ToString();
Hyoa_flowhistoryinfo_cl.Update_sh();
//更新主文档中的当前环节ID、当前环节名称、当前处理人ID和中文名
Hyoa_flowmain.hy_curtacheid = ls_lasttacheid;
Hyoa_flowmain.hy_curtachename = ls_lasttachename;
Hyoa_flowmain.hy_curclrid = ls_lastclrid;
Hyoa_flowmain.hy_curclrname = ls_lastclrname;
ls_tip = "文档已成功收回到[" + ls_lasttachename + "]环节";
//绩效考核日志
hyXnxtFlowLogs("从" + this.hy_curtachename.Text + "环节收回到" + ls_lasttachename + "", "收回");
hylcshtscl(Hyoa_flowmain);//特殊处理
}
}
//退回
if (this.txtwhichoperation.Value == "4")
{
//更新主文档
Hyoa_flowmain.hy_curtacheid = this.txtnexttacheid.Value;
Hyoa_flowmain.hy_curtachename = this.txtnexttachename.Value;
Hyoa_flowmain.hy_curclrid = this.txtnextclrid.Value;
Hyoa_flowmain.hy_curclrname = this.txtnextclrname.Value;
//处理历史处理记录
HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl();
DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value);
if (dt_clinfo.Rows.Count > 0)
{
string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID
string ls_clsj = ""; //当前处理的记录处理时间
if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "")
ls_clsj = System.DateTime.Now.ToString();
else
ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString();
dt_clinfo.Clear();
Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc;
Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj;
Hyoa_flowhistoryinfo_cl.Update();
}
//新建一条处理记录
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
Hyoa_global.Saveflowhistoryinfo_cl_global(this.txtdocid.Value, this.hy_flowid.Text, this.hy_flowname.Text, this.txtnexttacheid.Value, this.txtnexttachename.Value, this.txtnextclrid.Value, this.txtnextclrname.Value, "", "", "", System.DateTime.Now.ToString(), "是");
//处理待办事宜
//转已办-当前处理人的待办事宜
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
//得到发送人手机号
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(this.Session["hyuid"].ToString());
//（考虑多人的情况）
string[] lv_dbrid = this.txtnextclrid.Value.Split(new Char[] { ',' });
string[] lv_dbrname = this.txtnextclrname.Value.Split(new Char[] { ',' });
for (var i = 0; i < lv_dbrid.Length; i++)
{
if (lv_dbrid[i].ToString() != "")
{
//得到接收人手机号
string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(lv_dbrid[i].ToString());
HyoaClass.Hyoa_global Hyoa_global2 = new HyoaClass.Hyoa_global();
//给退回到的处理人发送一个新的待办事宜（提醒）
Hyoa_global2.Senddbsy_global(this.txtdocid.Value, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), "/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&pop=1", "待办", this.hy_mudelid.Text, "待办箱", "一般", this.hy_bt.Text, "请办理", 0, this.hy_flowid.Text, this.txtnexttacheid.Value);
//给退回到的处理人发送即时消息（提醒）
if (this.txtisSendjstx.Value == "1")
{
Hyoa_global.Sendjstx_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), this.hy_mudelid.Text, this.hy_bt.Text, 0);
}
//给退回到的处理人发送短信（提醒）
if (this.txtisSendsms.Value == "1")
{
Hyoa_global.Sendsms_global(this.txtdocid.Value, this.Session["hyuid"].ToString(), this.Session["hyuname"].ToString(), cb_fsrsjh, lv_dbrid[i].ToString(), lv_dbrname[i].ToString(), cb_jsrsjh, this.hy_mudelid.Text, this.hy_bt.Text, 1, "", "", 0);
}
}
}
//绩效考核写日志 add by wjs at 20150603
hyXnxtFlowLogs("从" + this.hy_curtachename.Text + "环节退回到" + this.txtnexttachename.Value + "", "退回");
ls_tip = "已成功退回到[" + this.txtnexttachename.Value + "]环节";
hylcthtscl(Hyoa_flowmain);//特殊处理
}
//多人处理
if (this.txtwhichoperation.Value == "5")
{
//更新主文档
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string ls_newclrid = Hyoa_global.MoveOneString_dh(this.hy_curclrid.Text, this.Session["hyuid"].ToString());
string ls_newclrname = Hyoa_global.MoveOneString_dh(this.hy_curclrname.Text, this.Session["hyuname"].ToString());
Hyoa_flowmain.hy_curclrid = ls_newclrid;
Hyoa_flowmain.hy_curclrname = ls_newclrname;
//处理处理记录
HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl();
DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value);
if (dt_clinfo.Rows.Count > 0)
{
string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID
string ls_clsj = ""; //当前处理的记录处理时间
if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "")
ls_clsj = System.DateTime.Now.ToString();
else
ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString();
dt_clinfo.Clear();
Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc;
Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj;
Hyoa_flowhistoryinfo_cl.Update();
//办公效率智能分析添加 add by wjs at 20150603
hyXnxtFlowLogs("从" + this.hy_curtachename.Text + "环节提交到" + this.txtnexttachename.Value + "环节", "提交");
}
//处理待办事宜
//转已办-当前处理人的待办事宜
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
ls_tip = "提交成功，当前环节还需要[" + ls_newclrname + "]进行办理";
hylcdrcltscl(Hyoa_flowmain);//特殊处理
}
//催办
if (this.txtwhichoperation.Value == "6")
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
string cb_docid = this.txtdocid.Value;
string cb_dbrid = this.hy_curclrid.Text;
string cb_dbrname = this.hy_curclrname.Text;
string cb_fsrid = this.Session["hyuid"].ToString();
string cb_fsrname = this.Session["hyuname"].ToString();
string cb_url = "main.aspx?op=modify&docid=" + this.txtdocid.Value + "&pop=1";
string cb_property = "催办";
string cb_mudelid = this.hy_mudelid.Text;
string cb_foldername = "待办箱";
string cb_hj = "一般";
string cb_bt = this.txtcbideas.Value + "-" + this.hy_bt.Text;
string cb_subbt = "请阅读";
float cb_ifyb = 0;
string cb_flowid = this.hy_flowid.Text;
string cb_tacheid = this.hy_curtacheid.Text;
string cb_from = this.hy_mudelid.Text;
//得到发送人手机号
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
string cb_fsrsjh = Hyoa_user.GetMobilebyuserid(cb_fsrid);
//得到接收人手机号
string cb_jsrsjh = Hyoa_user.GetMobilebyuserid(cb_dbrid);
//给当前处理人发送一个新的待办事宜（提醒）
Hyoa_global.Senddbsy_global(cb_docid, cb_dbrid, cb_dbrname, cb_fsrid, cb_fsrname, cb_url, cb_property, cb_mudelid, cb_foldername, cb_hj, cb_bt, cb_subbt, cb_ifyb, cb_flowid, cb_tacheid);
//给当前处理人发送即时消息（提醒）
if (this.txtisSendjstx.Value == "1")
{
Hyoa_global.Sendjstx_global(cb_docid, cb_fsrid, cb_fsrname, cb_dbrid, cb_dbrname, cb_from, cb_bt, 0);
}
//给当前处理人发送短信（提醒）
if (this.txtisSendsms.Value == "1")
{
Hyoa_global.Sendsms_global(cb_docid, cb_fsrid, cb_fsrname, cb_fsrsjh, cb_dbrid, cb_dbrname, cb_jsrsjh, cb_from, cb_bt, 1, "", "", 0);
}
//绩效考核写日志 add by wjs at 20150603
hyXnxtFlowLogs("催办" + this.hy_curtachename.Text + "环节", "催办");
ls_tip = "催办成功！";
hylccbtscl(Hyoa_flowmain);//特殊处理
}
//流程结束时的提交
if (this.txtwhichoperation.Value == "7")
{
//更新主文档
Hyoa_flowmain.hy_curtacheid = "**";
Hyoa_flowmain.hy_curtachename = "结束";
Hyoa_flowmain.hy_curclrid = "";
Hyoa_flowmain.hy_curclrname = "";
//更新处理表
HyoaClass.Hyoa_flowhistoryinfo_cl Hyoa_flowhistoryinfo_cl = new HyoaClass.Hyoa_flowhistoryinfo_cl();
DataTable dt_clinfo = Hyoa_flowhistoryinfo_cl.Getflowhistoryinfo_clsbydocid(this.txtdocid.Value);
if (dt_clinfo.Rows.Count > 0)
{
string ls_curcldoc = dt_clinfo.Rows[0]["ID"].ToString(); //当前处理的记录ID
string ls_clsj = ""; //当前处理的记录处理时间
if (dt_clinfo.Rows[0]["hy_clsj"].ToString() == "")
ls_clsj = System.DateTime.Now.ToString();
else
ls_clsj = dt_clinfo.Rows[0]["hy_clsj"].ToString() + "," + System.DateTime.Now.ToString();
dt_clinfo.Clear();
Hyoa_flowhistoryinfo_cl.ID = ls_curcldoc;
Hyoa_flowhistoryinfo_cl.hy_clsj = ls_clsj;
Hyoa_flowhistoryinfo_cl.Update();
}
////流程结束时删除所有该文档对应的待办事宜
//HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
//Hyoa_dbsy.Deletebydocid(this.txtdocid.Value);
//处理待办事宜
//转已办-当前处理人的待办事宜
HyoaClass.Hyoa_dbsy Hyoa_dbsy = new HyoaClass.Hyoa_dbsy();
Hyoa_dbsy.Dbsytoybbydociduserid(this.txtdocid.Value, this.Session["hyuid"].ToString());
ls_tip = "流程结束！";
hylcjstscl(Hyoa_flowmain);//特殊处理
hyXnxtFlowLogs("流程结束，文件已归档", "归档");
if (this.hy_tableid.Text == "1a564b74-3d94-4cef-bb94-f0c0342ae8dd")
{
string strAuthor = "";
string strAuthorDept = "";
if (this.hy_field2.Text != "")
{
strAuthor += this.hy_field2.Text + ",";
}
if (this.hy_field3.Text != "")
{
strAuthorDept += this.hy_field3.Text + ",";
}
if (this.hy_field4.Text != "")
{
strAuthor += this.hy_field4.Text + ",";
}
if (this.hy_field5.Text != "")
{
strAuthorDept += this.hy_field5.Text + ",";
}
if (this.hy_field6.Text != "")
{
strAuthor += this.hy_field6.Text + ",";
}
if (this.hy_field7.Text != "")
{
strAuthorDept += this.hy_field7.Text + ",";
}
hyXnxtMessageLogs("通过", "通过一篇文章", strAuthor, strAuthorDept);
}
}
Hyoa_flowmain.Update();
////处理完成后的提示及跳转(增加刷新附件功能)
if (this.txtifsxfj.Text == "1")
{
//Response.Write("<script>window.location='/main.aspx?op=modify&mid="+this.hy_mudelid.Text+"&tableid="+this.hy_tableid.Text+"&docid="+this.txtdocid.Value+"&url="+this.txturl.Value+"'</script>");
Response.Write("<script>window.location='/main.aspx?op=modify&mid=" + this.hy_mudelid.Text + "&tableid=" + this.hy_tableid.Text + "&docid=" + this.txtdocid.Value + "&url=" + this.txturl.Value + "'</script>");
}
else
{
if (this.txtifpop.Value == "")
{
Response.Write("<script>alert('" + ls_tip + "');window.location='" + this.txturl.Value + "'</script>");
}
else
{
Response.Write("<script>alert('" + ls_tip + "');window.opener.location.reload();window.opener=null;window.open('','_self');window.close();</script>");
}
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
String sql;
sql = "";
if (this.lblDisplay.Text == "")
{
this.lblReturnInformation.Text = "请先保存Excel文件!";
}
else
{
sql = "";
sql = " select 姓名,日期,签到时间,签退时间,是否旷工,例外情况,部门 from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=''" + this.lblDisplay.Text + "'';User ID=admin;Password=;Extended properties=Excel 5.0')...Sheet1$ ";
HyoaClass.DAO db = new HyoaClass.DAO();
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
DataTable dt = db.GetDataTable(sql);
HyoaClass.Hyoa_user Hyoa_user = new HyoaClass.Hyoa_user();
DataTable dtuser;
for (int j = 0; j < dt.Rows.Count; j++)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//文档ID
Hyoa_flowmain.DOCID = Hyoa_global.GetRandom();
Hyoa_flowmain.hy_mudelid = "kqgl";
Hyoa_flowmain.hy_tableid = "74e7e280-4fc5-4ccb-be3d-0f995ac2c934";
Hyoa_flowmain.hy_flowid = "";
Hyoa_flowmain.hy_flowname = "";
Hyoa_flowmain.hy_curtacheid = "";
Hyoa_flowmain.hy_curtachename = "";
Hyoa_flowmain.hy_curclrid = "";
Hyoa_flowmain.hy_curclrname = "";
dtuser = Hyoa_user.GetusersbynameforCX(dt.Rows[j]["姓名"].ToString());
if (dtuser.Rows.Count > 0)
{
Hyoa_flowmain.hy_djrid = dtuser.Rows[0]["hy_userid"].ToString();
Hyoa_flowmain.hy_djrbmid = dtuser.Rows[0]["hy_deptid"].ToString();
}
else
{
Hyoa_flowmain.hy_djrid = "";
Hyoa_flowmain.hy_djrbmid = "";
}
Hyoa_flowmain.hy_djrname = dt.Rows[j]["姓名"].ToString();
Hyoa_flowmain.hy_djrbmname = dt.Rows[j]["部门"].ToString();
Hyoa_flowmain.hy_djsj = System.DateTime.Now.ToString();
Hyoa_flowmain.hy_bt = "";
Hyoa_flowmain.hy_content1 = "";
Hyoa_flowmain.hy_content2 = "";
Hyoa_flowmain.hy_content3 = "";
Hyoa_flowmain.hy_content4 = "";
Hyoa_flowmain.hy_content5 = "";
Hyoa_flowmain.hy_content6 = "";
Hyoa_flowmain.hy_content7 = "";
Hyoa_flowmain.hy_content8 = "";
Hyoa_flowmain.hy_content9 = "";
Hyoa_flowmain.hy_content10 = "";
Hyoa_flowmain.hy_content11 = "";
Hyoa_flowmain.hy_content12 = "";
Hyoa_flowmain.hy_content13 = "";
Hyoa_flowmain.hy_content14 = "";
Hyoa_flowmain.hy_content15 = "";
Hyoa_flowmain.hy_field1 = dt.Rows[j]["签到时间"].ToString();
Hyoa_flowmain.hy_field2 = dt.Rows[j]["签退时间"].ToString();
if (dt.Rows[j]["是否旷工"].ToString() == "True")
{
Hyoa_flowmain.hy_field3 = "是";
}
else
{
Hyoa_flowmain.hy_field3 = "";
}
Hyoa_flowmain.hy_field4 = dt.Rows[j]["例外情况"].ToString();
Hyoa_flowmain.hy_field5 = "";
Hyoa_flowmain.hy_field6 = "";
Hyoa_flowmain.hy_field7 = "";
Hyoa_flowmain.hy_field8 = "";
Hyoa_flowmain.hy_field9 = "";
Hyoa_flowmain.hy_field10 = "";
Hyoa_flowmain.hy_field11 = "";
Hyoa_flowmain.hy_field12 = "";
Hyoa_flowmain.hy_field13 = "";
Hyoa_flowmain.hy_field14 = "";
Hyoa_flowmain.hy_field15 = "";
Hyoa_flowmain.hy_field16 = "";
Hyoa_flowmain.hy_field17 = "";
Hyoa_flowmain.hy_field18 = "";
Hyoa_flowmain.hy_field19 = "";
Hyoa_flowmain.hy_field20 = "";
Hyoa_flowmain.hy_field21 = "";
Hyoa_flowmain.hy_field22 = "";
Hyoa_flowmain.hy_field23 = "";
Hyoa_flowmain.hy_field24 = "";
Hyoa_flowmain.hy_field25 = "";
Hyoa_flowmain.hy_field26 = "";
Hyoa_flowmain.hy_field27 = "";
Hyoa_flowmain.hy_field28 = "";
Hyoa_flowmain.hy_field29 = "";
Hyoa_flowmain.hy_field30 = "";
Hyoa_flowmain.hy_field31 = dt.Rows[j]["日期"].ToString(); ;
Hyoa_flowmain.hy_field32 = "";
Hyoa_flowmain.hy_field33 = "";
Hyoa_flowmain.hy_field34 = "";
Hyoa_flowmain.hy_field35 = "";
Hyoa_flowmain.hy_field36 = 0;
Hyoa_flowmain.hy_field37 = 0;
Hyoa_flowmain.hy_field38 = 0;
Hyoa_flowmain.hy_field39 = 0;
Hyoa_flowmain.hy_field40 = 0;
Hyoa_flowmain.hy_field41 = "";
Hyoa_flowmain.hy_field42 = "";
Hyoa_flowmain.hy_field43 = "";
Hyoa_flowmain.hy_field44 = "";
Hyoa_flowmain.hy_field45 = "";
Hyoa_flowmain.hy_field46 = "";
Hyoa_flowmain.hy_field47 = "";
Hyoa_flowmain.hy_field48 = "";
Hyoa_flowmain.hy_field49 = "";
Hyoa_flowmain.hy_field50 = "";
Hyoa_flowmain.hy_field51 = "";
Hyoa_flowmain.hy_field52 = "";
Hyoa_flowmain.hy_field53 = "";
Hyoa_flowmain.hy_field54 = "";
Hyoa_flowmain.hy_field55 = "";
Hyoa_flowmain.hy_field56 = "";
Hyoa_flowmain.hy_field57 = "";
Hyoa_flowmain.hy_field58 = "";
Hyoa_flowmain.hy_field59 = "";
Hyoa_flowmain.hy_field60 = "";
Hyoa_flowmain.hy_field61 = "";
Hyoa_flowmain.hy_field62 = "";
Hyoa_flowmain.hy_field63 = "";
Hyoa_flowmain.hy_field64 = "";
Hyoa_flowmain.hy_field65 = "";
Hyoa_flowmain.hy_field66 = "";
Hyoa_flowmain.hy_field67 = "";
Hyoa_flowmain.hy_field68 = "";
Hyoa_flowmain.hy_field69 = "";
Hyoa_flowmain.hy_field70 = "";
Hyoa_flowmain.hy_field71 = 0;
Hyoa_flowmain.hy_field72 = 0;
Hyoa_flowmain.hy_field73 = 0;
Hyoa_flowmain.hy_field74 = 0;
Hyoa_flowmain.hy_field75 = 0;
Hyoa_flowmain.hy_field76 = 0;
Hyoa_flowmain.hy_field77 = 0;
Hyoa_flowmain.hy_field78 = 0;
Hyoa_flowmain.hy_field79 = 0;
Hyoa_flowmain.hy_field80 = 0;
Hyoa_flowmain.hy_field81 = 0;
Hyoa_flowmain.hy_field82 = 0;
Hyoa_flowmain.hy_field83 = 0;
Hyoa_flowmain.hy_field84 = 0;
Hyoa_flowmain.hy_field85 = 0;
Hyoa_flowmain.hy_field86 = 0;
Hyoa_flowmain.hy_field87 = 0;
Hyoa_flowmain.hy_field88 = 0;
Hyoa_flowmain.hy_field89 = 0;
Hyoa_flowmain.hy_field90 = 0;
Hyoa_flowmain.hy_field91 = 0;
Hyoa_flowmain.hy_field92 = 0;
Hyoa_flowmain.hy_field93 = 0;
Hyoa_flowmain.hy_field94 = 0;
Hyoa_flowmain.hy_field95 = 0;
Hyoa_flowmain.hy_field96 = 0;
Hyoa_flowmain.hy_field97 = 0;
Hyoa_flowmain.hy_field98 = 0;
Hyoa_flowmain.hy_field99 = 0;
Hyoa_flowmain.hy_field100 = 0;
Hyoa_flowmain.hy_iftx = "";
Hyoa_flowmain.hy_zhtxsj = "";
Hyoa_flowmain.hy_readuserlist = "";
Hyoa_flowmain.Insert();
}
db.Close();
this.lblReturnInformation.Text = "导入成功";
if (File.Exists(this.lblDisplay.Text))
{
System.IO.File.Delete(this.lblDisplay.Text);
}
}
}
protected void btnImport_Click(object sender, EventArgs e)
{
String sql;
sql = "";
if (this.lblDisplay.Text == "")
{
this.lblReturnInformation.Text = "请先保存Excel文件!";
}
else
{
sql = "";
sql = " select 题型,正确答案,题目,分值,选择项1,选择项2,选择项3,选择项4,选择项5,选择项6 from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=''" + this.lblDisplay.Text + "'';User ID=admin;Password=;Extended properties=Excel 5.0')...Sheet1$ ";
HyoaClass.DAO db = new HyoaClass.DAO();
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
DataTable dt = db.GetDataTable(sql);
for (int j = 0; j < dt.Rows.Count; j++)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//文档ID
Hyoa_flowmain.DOCID = Hyoa_global.GetRandom();
Hyoa_flowmain.hy_mudelid = "zsgl";
Hyoa_flowmain.hy_tableid = "9b3dd7c5-a4ab-46c5-a1c8-5d7879bdf050";
Hyoa_flowmain.hy_flowid = "";
Hyoa_flowmain.hy_flowname = "";
Hyoa_flowmain.hy_curtacheid = "";
Hyoa_flowmain.hy_curtachename = "";
Hyoa_flowmain.hy_curclrid = "";
Hyoa_flowmain.hy_curclrname = "";
Hyoa_flowmain.hy_djrid = "admin";
Hyoa_flowmain.hy_djrname = "管理员";
Hyoa_flowmain.hy_djrbmid = "003";
Hyoa_flowmain.hy_djrbmname = "管理员组";
Hyoa_flowmain.hy_djsj = System.DateTime.Now.ToString();
Hyoa_flowmain.hy_bt = "";
Hyoa_flowmain.hy_content1 = "";
Hyoa_flowmain.hy_content2 = "";
Hyoa_flowmain.hy_content3 = "";
Hyoa_flowmain.hy_content4 = "";
Hyoa_flowmain.hy_content5 = "";
Hyoa_flowmain.hy_content6 = "";
Hyoa_flowmain.hy_content7 = "";
Hyoa_flowmain.hy_content8 = "";
Hyoa_flowmain.hy_content9 = "";
Hyoa_flowmain.hy_content10 = "";
Hyoa_flowmain.hy_content11 = "";
Hyoa_flowmain.hy_content12 = "";
Hyoa_flowmain.hy_content13 = "";
Hyoa_flowmain.hy_content14 = "";
Hyoa_flowmain.hy_content15 = "";
Hyoa_flowmain.hy_field1 = dt.Rows[j]["题型"].ToString();
Hyoa_flowmain.hy_field2 = dt.Rows[j]["正确答案"].ToString();
Hyoa_flowmain.hy_field3 = dt.Rows[j]["题目"].ToString();
Hyoa_flowmain.hy_field4 = dt.Rows[j]["分值"].ToString();
Hyoa_flowmain.hy_field5 = "";
Hyoa_flowmain.hy_field6 = "";
Hyoa_flowmain.hy_field7 = "";
Hyoa_flowmain.hy_field8 = "";
Hyoa_flowmain.hy_field9 = "";
Hyoa_flowmain.hy_field10 = dt.Rows[j]["选择项1"].ToString();
Hyoa_flowmain.hy_field11 = dt.Rows[j]["选择项2"].ToString();
Hyoa_flowmain.hy_field12 = dt.Rows[j]["选择项3"].ToString();
Hyoa_flowmain.hy_field13 = dt.Rows[j]["选择项4"].ToString();
Hyoa_flowmain.hy_field14 = dt.Rows[j]["选择项5"].ToString();
Hyoa_flowmain.hy_field15 = dt.Rows[j]["选择项6"].ToString();
Hyoa_flowmain.hy_field16 = "";
Hyoa_flowmain.hy_field17 = "";
Hyoa_flowmain.hy_field18 = "";
Hyoa_flowmain.hy_field19 = "";
Hyoa_flowmain.hy_field20 = "";
Hyoa_flowmain.hy_field21 = "";
Hyoa_flowmain.hy_field22 = "";
Hyoa_flowmain.hy_field23 = "";
Hyoa_flowmain.hy_field24 = "";
Hyoa_flowmain.hy_field25 = "";
Hyoa_flowmain.hy_field26 = "";
Hyoa_flowmain.hy_field27 = "";
Hyoa_flowmain.hy_field28 = "";
Hyoa_flowmain.hy_field29 = "";
Hyoa_flowmain.hy_field30 = "";
Hyoa_flowmain.hy_field31 = "";
Hyoa_flowmain.hy_field32 = "";
Hyoa_flowmain.hy_field33 = "";
Hyoa_flowmain.hy_field34 = "";
Hyoa_flowmain.hy_field35 = "";
Hyoa_flowmain.hy_field36 = 0;
Hyoa_flowmain.hy_field37 = 0;
Hyoa_flowmain.hy_field38 = 0;
Hyoa_flowmain.hy_field39 = 0;
Hyoa_flowmain.hy_field40 = 0;
Hyoa_flowmain.hy_field41 = "";
Hyoa_flowmain.hy_field42 = "";
Hyoa_flowmain.hy_field43 = "";
Hyoa_flowmain.hy_field44 = "";
Hyoa_flowmain.hy_field45 = "";
Hyoa_flowmain.hy_field46 = "";
Hyoa_flowmain.hy_field47 = "";
Hyoa_flowmain.hy_field48 = "";
Hyoa_flowmain.hy_field49 = "";
Hyoa_flowmain.hy_field50 = "";
Hyoa_flowmain.hy_field51 = "";
Hyoa_flowmain.hy_field52 = "";
Hyoa_flowmain.hy_field53 = "";
Hyoa_flowmain.hy_field54 = "";
Hyoa_flowmain.hy_field55 = "";
Hyoa_flowmain.hy_field56 = "";
Hyoa_flowmain.hy_field57 = "";
Hyoa_flowmain.hy_field58 = "";
Hyoa_flowmain.hy_field59 = "";
Hyoa_flowmain.hy_field60 = "";
Hyoa_flowmain.hy_field61 = "";
Hyoa_flowmain.hy_field62 = "";
Hyoa_flowmain.hy_field63 = "";
Hyoa_flowmain.hy_field64 = "";
Hyoa_flowmain.hy_field65 = "";
Hyoa_flowmain.hy_field66 = "";
Hyoa_flowmain.hy_field67 = "";
Hyoa_flowmain.hy_field68 = "";
Hyoa_flowmain.hy_field69 = "";
Hyoa_flowmain.hy_field70 = "";
Hyoa_flowmain.hy_field71 = 0;
Hyoa_flowmain.hy_field72 = 0;
Hyoa_flowmain.hy_field73 = 0;
Hyoa_flowmain.hy_field74 = 0;
Hyoa_flowmain.hy_field75 = 0;
Hyoa_flowmain.hy_field76 = 0;
Hyoa_flowmain.hy_field77 = 0;
Hyoa_flowmain.hy_field78 = 0;
Hyoa_flowmain.hy_field79 = 0;
Hyoa_flowmain.hy_field80 = 0;
Hyoa_flowmain.hy_field81 = 0;
Hyoa_flowmain.hy_field82 = 0;
Hyoa_flowmain.hy_field83 = 0;
Hyoa_flowmain.hy_field84 = 0;
Hyoa_flowmain.hy_field85 = 0;
Hyoa_flowmain.hy_field86 = 0;
Hyoa_flowmain.hy_field87 = 0;
Hyoa_flowmain.hy_field88 = 0;
Hyoa_flowmain.hy_field89 = 0;
Hyoa_flowmain.hy_field90 = 0;
Hyoa_flowmain.hy_field91 = 0;
Hyoa_flowmain.hy_field92 = 0;
Hyoa_flowmain.hy_field93 = 0;
Hyoa_flowmain.hy_field94 = 0;
Hyoa_flowmain.hy_field95 = 0;
Hyoa_flowmain.hy_field96 = 0;
Hyoa_flowmain.hy_field97 = 0;
Hyoa_flowmain.hy_field98 = 0;
Hyoa_flowmain.hy_field99 = 0;
Hyoa_flowmain.hy_field100 = 0;
Hyoa_flowmain.hy_iftx = "";
Hyoa_flowmain.hy_zhtxsj = "";
Hyoa_flowmain.hy_readuserlist = "";
Hyoa_flowmain.Insert();
}
db.Close();
this.lblReturnInformation.Text = "导入成功";
if (File.Exists(this.lblDisplay.Text))
{
System.IO.File.Delete(this.lblDisplay.Text);
}
}
}
//复制
protected void btncopyinfo_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//String[] v_uids = this.txtuids.Value.Split(',');
string ls_doc = Hyoa_global.GetRandom();
//得到记录 复制一条记录==20140224 by fy==
DataTable dt = Hyoa_flowmain.Getflowmain(this.txtuids.Value);
if (dt.Rows.Count > 0)
{
//开始复制
Hyoa_flowmain.DOCID = ls_doc;
Hyoa_flowmain.hy_mudelid = dt.Rows[0]["hy_mudelid"].ToString();
Hyoa_flowmain.hy_tableid = dt.Rows[0]["hy_tableid"].ToString();
Hyoa_flowmain.hy_flowid = dt.Rows[0]["hy_flowid"].ToString();
Hyoa_flowmain.hy_flowname = dt.Rows[0]["hy_flowname"].ToString();
Hyoa_flowmain.hy_curtacheid = "";
Hyoa_flowmain.hy_curtachename = "";
Hyoa_flowmain.hy_curclrid = "";
Hyoa_flowmain.hy_curclrname = "";
//Hyoa_flowmain.hy_djrid = dt.Rows[0]["hy_djrid"].ToString();
//Hyoa_flowmain.hy_djrname = dt.Rows[0]["hy_djrname"].ToString();
//Hyoa_flowmain.hy_djrbmid = dt.Rows[0]["hy_djrbmid"].ToString();
//Hyoa_flowmain.hy_djrbmname = dt.Rows[0]["hy_djrbmname"].ToString();
//Hyoa_flowmain.hy_djsj = dt.Rows[0]["hy_djsj"].ToString();
Hyoa_flowmain.hy_djrid = Session["hyuid"].ToString();
Hyoa_flowmain.hy_djrname = Session["hyuname"].ToString();
Hyoa_flowmain.hy_djrbmid = Session["hydeptid"].ToString();
Hyoa_flowmain.hy_djrbmname = Session["hydeptname"].ToString();
Hyoa_flowmain.hy_djsj = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Hyoa_flowmain.hy_bt = dt.Rows[0]["hy_bt"].ToString();
Hyoa_flowmain.hy_content1 = dt.Rows[0]["hy_content1"].ToString();
Hyoa_flowmain.hy_content2 = dt.Rows[0]["hy_content2"].ToString();
Hyoa_flowmain.hy_content3 = dt.Rows[0]["hy_content3"].ToString();
Hyoa_flowmain.hy_content4 = dt.Rows[0]["hy_content4"].ToString();
Hyoa_flowmain.hy_content5 = dt.Rows[0]["hy_content5"].ToString();
Hyoa_flowmain.hy_field1 = dt.Rows[0]["hy_field1"].ToString();
Hyoa_flowmain.hy_field2 = dt.Rows[0]["hy_field2"].ToString();
Hyoa_flowmain.hy_field3 = dt.Rows[0]["hy_field3"].ToString();
Hyoa_flowmain.hy_field4 = dt.Rows[0]["hy_field4"].ToString();
Hyoa_flowmain.hy_field5 = dt.Rows[0]["hy_field5"].ToString();
Hyoa_flowmain.hy_field6 = dt.Rows[0]["hy_field6"].ToString();
Hyoa_flowmain.hy_field7 = dt.Rows[0]["hy_field7"].ToString();
Hyoa_flowmain.hy_field8 = dt.Rows[0]["hy_field8"].ToString();
Hyoa_flowmain.hy_field9 = dt.Rows[0]["hy_field9"].ToString();
Hyoa_flowmain.hy_field10 = dt.Rows[0]["hy_field10"].ToString();
Hyoa_flowmain.hy_field11 = dt.Rows[0]["hy_field11"].ToString();
Hyoa_flowmain.hy_field12 = dt.Rows[0]["hy_field12"].ToString();
Hyoa_flowmain.hy_field13 = dt.Rows[0]["hy_field13"].ToString();
Hyoa_flowmain.hy_field14 = dt.Rows[0]["hy_field14"].ToString();
Hyoa_flowmain.hy_field15 = dt.Rows[0]["hy_field15"].ToString();
Hyoa_flowmain.hy_field16 = dt.Rows[0]["hy_field16"].ToString();
Hyoa_flowmain.hy_field17 = dt.Rows[0]["hy_field17"].ToString();
Hyoa_flowmain.hy_field18 = dt.Rows[0]["hy_field18"].ToString();
Hyoa_flowmain.hy_field19 = dt.Rows[0]["hy_field19"].ToString();
Hyoa_flowmain.hy_field20 = dt.Rows[0]["hy_field20"].ToString();
Hyoa_flowmain.hy_field21 = dt.Rows[0]["hy_field21"].ToString();
Hyoa_flowmain.hy_field22 = dt.Rows[0]["hy_field22"].ToString();
Hyoa_flowmain.hy_field23 = dt.Rows[0]["hy_field23"].ToString();
Hyoa_flowmain.hy_field24 = dt.Rows[0]["hy_field24"].ToString();
Hyoa_flowmain.hy_field25 = dt.Rows[0]["hy_field25"].ToString();
Hyoa_flowmain.hy_field26 = dt.Rows[0]["hy_field26"].ToString();
Hyoa_flowmain.hy_field27 = dt.Rows[0]["hy_field27"].ToString();
Hyoa_flowmain.hy_field28 = dt.Rows[0]["hy_field28"].ToString();
Hyoa_flowmain.hy_field29 = dt.Rows[0]["hy_field29"].ToString();
Hyoa_flowmain.hy_field30 = dt.Rows[0]["hy_field30"].ToString();
Hyoa_flowmain.hy_field31 = System.DateTime.Now.ToString("yyyy-MM-dd");
Hyoa_flowmain.hy_field32 = dt.Rows[0]["hy_field32"].ToString();
Hyoa_flowmain.hy_field33 = dt.Rows[0]["hy_field33"].ToString();
Hyoa_flowmain.hy_field34 = dt.Rows[0]["hy_field34"].ToString();
Hyoa_flowmain.hy_field35 = dt.Rows[0]["hy_field35"].ToString();
Hyoa_flowmain.hy_field36 = float.Parse(dt.Rows[0]["hy_field36"].ToString());
Hyoa_flowmain.hy_field37 = float.Parse(dt.Rows[0]["hy_field37"].ToString());
Hyoa_flowmain.hy_field38 = float.Parse(dt.Rows[0]["hy_field38"].ToString());
Hyoa_flowmain.hy_field39 = float.Parse(dt.Rows[0]["hy_field39"].ToString());
Hyoa_flowmain.hy_field40 = float.Parse(dt.Rows[0]["hy_field40"].ToString());
Hyoa_flowmain.hy_field41 = dt.Rows[0]["hy_field41"].ToString();
Hyoa_flowmain.hy_field42 = dt.Rows[0]["hy_field42"].ToString();
Hyoa_flowmain.hy_field43 = dt.Rows[0]["hy_field43"].ToString();
Hyoa_flowmain.hy_field44 = dt.Rows[0]["hy_field44"].ToString();
Hyoa_flowmain.hy_field45 = dt.Rows[0]["hy_field45"].ToString();
Hyoa_flowmain.hy_field46 = dt.Rows[0]["hy_field46"].ToString();
Hyoa_flowmain.hy_field47 = dt.Rows[0]["hy_field47"].ToString();
Hyoa_flowmain.hy_field48 = dt.Rows[0]["hy_field48"].ToString();
Hyoa_flowmain.hy_field49 = dt.Rows[0]["hy_field49"].ToString();
Hyoa_flowmain.hy_field50 = dt.Rows[0]["hy_field50"].ToString();
Hyoa_flowmain.hy_field51 = dt.Rows[0]["hy_field51"].ToString();
Hyoa_flowmain.hy_field52 = dt.Rows[0]["hy_field52"].ToString();
Hyoa_flowmain.hy_field53 = dt.Rows[0]["hy_field53"].ToString();
Hyoa_flowmain.hy_field54 = dt.Rows[0]["hy_field54"].ToString();
Hyoa_flowmain.hy_field55 = dt.Rows[0]["hy_field55"].ToString();
Hyoa_flowmain.hy_field56 = dt.Rows[0]["hy_field56"].ToString();
Hyoa_flowmain.hy_field57 = dt.Rows[0]["hy_field57"].ToString();
Hyoa_flowmain.hy_field58 = dt.Rows[0]["hy_field58"].ToString();
Hyoa_flowmain.hy_field59 = dt.Rows[0]["hy_field59"].ToString();
Hyoa_flowmain.hy_field60 = dt.Rows[0]["hy_field60"].ToString();
Hyoa_flowmain.hy_field61 = dt.Rows[0]["hy_field61"].ToString();
Hyoa_flowmain.hy_field62 = dt.Rows[0]["hy_field62"].ToString();
Hyoa_flowmain.hy_field63 = dt.Rows[0]["hy_field63"].ToString();
Hyoa_flowmain.hy_field64 = dt.Rows[0]["hy_field64"].ToString();
Hyoa_flowmain.hy_field65 = dt.Rows[0]["hy_field65"].ToString();
Hyoa_flowmain.hy_field66 = dt.Rows[0]["hy_field66"].ToString();
Hyoa_flowmain.hy_field67 = dt.Rows[0]["hy_field67"].ToString();
Hyoa_flowmain.hy_field68 = dt.Rows[0]["hy_field68"].ToString();
Hyoa_flowmain.hy_field69 = dt.Rows[0]["hy_field69"].ToString();
Hyoa_flowmain.hy_field70 = dt.Rows[0]["hy_field70"].ToString();
Hyoa_flowmain.hy_field71 = float.Parse(dt.Rows[0]["hy_field71"].ToString());
Hyoa_flowmain.hy_field72 = float.Parse(dt.Rows[0]["hy_field72"].ToString());
Hyoa_flowmain.hy_field73 = float.Parse(dt.Rows[0]["hy_field73"].ToString());
Hyoa_flowmain.hy_field74 = float.Parse(dt.Rows[0]["hy_field74"].ToString());
Hyoa_flowmain.hy_field75 = float.Parse(dt.Rows[0]["hy_field75"].ToString());
Hyoa_flowmain.hy_field76 = float.Parse(dt.Rows[0]["hy_field76"].ToString());
Hyoa_flowmain.hy_field77 = float.Parse(dt.Rows[0]["hy_field77"].ToString());
Hyoa_flowmain.hy_field78 = float.Parse(dt.Rows[0]["hy_field78"].ToString());
Hyoa_flowmain.hy_field79 = float.Parse(dt.Rows[0]["hy_field79"].ToString());
Hyoa_flowmain.hy_field80 = float.Parse(dt.Rows[0]["hy_field80"].ToString());
Hyoa_flowmain.hy_field81 = float.Parse(dt.Rows[0]["hy_field81"].ToString());
Hyoa_flowmain.hy_field82 = float.Parse(dt.Rows[0]["hy_field82"].ToString());
Hyoa_flowmain.hy_field83 = float.Parse(dt.Rows[0]["hy_field83"].ToString());
Hyoa_flowmain.hy_field84 = float.Parse(dt.Rows[0]["hy_field84"].ToString());
Hyoa_flowmain.hy_field85 = float.Parse(dt.Rows[0]["hy_field85"].ToString());
Hyoa_flowmain.hy_field86 = float.Parse(dt.Rows[0]["hy_field86"].ToString());
Hyoa_flowmain.hy_field87 = float.Parse(dt.Rows[0]["hy_field87"].ToString());
Hyoa_flowmain.hy_field88 = float.Parse(dt.Rows[0]["hy_field88"].ToString());
Hyoa_flowmain.hy_field89 = float.Parse(dt.Rows[0]["hy_field89"].ToString());
Hyoa_flowmain.hy_field90 = float.Parse(dt.Rows[0]["hy_field90"].ToString());
Hyoa_flowmain.hy_field91 = float.Parse(dt.Rows[0]["hy_field91"].ToString());
Hyoa_flowmain.hy_field92 = float.Parse(dt.Rows[0]["hy_field92"].ToString());
Hyoa_flowmain.hy_field93 = float.Parse(dt.Rows[0]["hy_field93"].ToString());
Hyoa_flowmain.hy_field94 = float.Parse(dt.Rows[0]["hy_field94"].ToString());
Hyoa_flowmain.hy_field95 = float.Parse(dt.Rows[0]["hy_field95"].ToString());
Hyoa_flowmain.hy_field96 = float.Parse(dt.Rows[0]["hy_field96"].ToString());
Hyoa_flowmain.hy_field97 = float.Parse(dt.Rows[0]["hy_field97"].ToString());
Hyoa_flowmain.hy_field98 = float.Parse(dt.Rows[0]["hy_field98"].ToString());
Hyoa_flowmain.hy_field99 = float.Parse(dt.Rows[0]["hy_field99"].ToString());
//Hyoa_flowmain.hy_field100 = float.Parse(dt.Rows[0]["hy_field100"].ToString());
//特殊，标志为1表示是复制的数据
Hyoa_flowmain.hy_field100 = 1;
Hyoa_flowmain.hy_iftx = dt.Rows[0]["hy_iftx"].ToString();
Hyoa_flowmain.hy_zhtxsj = dt.Rows[0]["hy_zhtxsj"].ToString();
Hyoa_flowmain.hy_readuserlist = dt.Rows[0]["hy_readuserlist"].ToString();
Hyoa_flowmain.hy_content6 = dt.Rows[0]["hy_content6"].ToString();
Hyoa_flowmain.hy_content7 = dt.Rows[0]["hy_content7"].ToString();
Hyoa_flowmain.hy_content8 = dt.Rows[0]["hy_content8"].ToString();
Hyoa_flowmain.hy_content9 = dt.Rows[0]["hy_content9"].ToString();
Hyoa_flowmain.hy_content10 = dt.Rows[0]["hy_content10"].ToString();
Hyoa_flowmain.hy_content11 = dt.Rows[0]["hy_content11"].ToString();
Hyoa_flowmain.hy_content12 = dt.Rows[0]["hy_content12"].ToString();
Hyoa_flowmain.hy_content13 = dt.Rows[0]["hy_content13"].ToString();
Hyoa_flowmain.hy_content14 = dt.Rows[0]["hy_content14"].ToString();
Hyoa_flowmain.hy_content15 = dt.Rows[0]["hy_content15"].ToString();
Hyoa_flowmain.Insert();
}
//for (var i = 0; i < v_uids.Length; i++)
//{
// if (v_uids[i] != "")
// {
// }
//}
this.txtuids.Value = "";
//DataPlay(System.Int32.Parse(this.curpage.Text));
string ls_url = "main.aspx?op=modify&mid=" + txtmudelid.Value + "&tableid=" + txttableid.Value + "&docid=" + ls_doc;
Response.Write("<script>window.location = '" + ls_url + "';</script>");
}
protected void btnImport_Click(object sender, EventArgs e)
{
String sql;
sql = "";
if (this.lblDisplay.Text == "")
{
this.lblReturnInformation.Text = "请先保存Excel文件!";
}
else
{
sql = "";
sql = " select 序号,录用日期,录用刊物期号,录用级别,录用标题,报送人员,信息类别,得分 from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=''" + this.lblDisplay.Text + "'';User ID=admin;Password=;Extended properties=Excel 5.0')...Sheet1$ ";
HyoaClass.DAO db = new HyoaClass.DAO();
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
DataTable dt = db.GetDataTable(sql);
//this.lblReturnInformation.Text = dt.Rows.Count.ToString();
for (int j = 0; j < dt.Rows.Count; j++)
{
string[] lvbsry;
lvbsry = dt.Rows[j]["报送人员"].ToString().Split(',');
for (int k = 0; k < lvbsry.Length; k++)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//文档ID
Hyoa_flowmain.DOCID = Hyoa_global.GetRandom();
Hyoa_flowmain.hy_mudelid = "xxgl";
Hyoa_flowmain.hy_tableid = "f1265875-5494-465f-ac33-6fa43d208c8f";
Hyoa_flowmain.hy_flowid = "";
Hyoa_flowmain.hy_flowname = "";
Hyoa_flowmain.hy_curtacheid = "";
Hyoa_flowmain.hy_curtachename = "";
Hyoa_flowmain.hy_curclrid = "";
Hyoa_flowmain.hy_curclrname = "";
Hyoa_flowmain.hy_djrid = "admin";
Hyoa_flowmain.hy_djrname = "管理员";
Hyoa_flowmain.hy_djrbmid = "003";
Hyoa_flowmain.hy_djrbmname = "管理员组";
Hyoa_flowmain.hy_djsj = System.DateTime.Now.ToString();
Hyoa_flowmain.hy_bt = dt.Rows[j]["录用标题"].ToString();
Hyoa_flowmain.hy_content1 = "";
Hyoa_flowmain.hy_content2 = "";
Hyoa_flowmain.hy_content3 = "";
Hyoa_flowmain.hy_content4 = "";
Hyoa_flowmain.hy_content5 = "";
Hyoa_flowmain.hy_content6 = "";
Hyoa_flowmain.hy_content7 = "";
Hyoa_flowmain.hy_content8 = "";
Hyoa_flowmain.hy_content9 = "";
Hyoa_flowmain.hy_content10 = "";
Hyoa_flowmain.hy_content11 = "";
Hyoa_flowmain.hy_content12 = "";
Hyoa_flowmain.hy_content13 = "";
Hyoa_flowmain.hy_content14 = "";
Hyoa_flowmain.hy_content15 = "";
//,,,,,,,
Hyoa_flowmain.hy_field1 = "";
Hyoa_flowmain.hy_field2 = dt.Rows[j]["录用刊物期号"].ToString();
Hyoa_flowmain.hy_field3 = dt.Rows[j]["信息类别"].ToString();
Hyoa_flowmain.hy_field4 = dt.Rows[j]["录用级别"].ToString();
Hyoa_flowmain.hy_field5 = "";
Hyoa_flowmain.hy_field6 = lvbsry[k].ToString();
Hyoa_flowmain.hy_field7 = "";
Hyoa_flowmain.hy_field8 = "";
Hyoa_flowmain.hy_field9 = (float.Parse(dt.Rows[j]["得分"].ToString()) / lvbsry.Length).ToString("0.0");
//Hyoa_flowmain.hy_field9 = "";
Hyoa_flowmain.hy_field10 = "";
Hyoa_flowmain.hy_field11 = "";
Hyoa_flowmain.hy_field12 = "";
Hyoa_flowmain.hy_field13 = "";
Hyoa_flowmain.hy_field14 = "";
Hyoa_flowmain.hy_field15 = "";
Hyoa_flowmain.hy_field16 = "";
Hyoa_flowmain.hy_field17 = "";
Hyoa_flowmain.hy_field18 = "";
Hyoa_flowmain.hy_field19 = "";
Hyoa_flowmain.hy_field20 = "";
Hyoa_flowmain.hy_field21 = "";
Hyoa_flowmain.hy_field22 = "";
Hyoa_flowmain.hy_field23 = "";
Hyoa_flowmain.hy_field24 = "";
Hyoa_flowmain.hy_field25 = "";
Hyoa_flowmain.hy_field26 = "";
Hyoa_flowmain.hy_field27 = "";
Hyoa_flowmain.hy_field28 = "";
Hyoa_flowmain.hy_field29 = "";
Hyoa_flowmain.hy_field30 = "";
//this.lbtest.Text = Convert.ToDateTime(System.DateTime.Now.ToString()).ToString("yyyy") +"-"+ Convert.ToDateTime(dt.Rows[j]["录用日期"].ToString()).ToString("MM-dd");
//Hyoa_flowmain.hy_field31 = Convert.ToDateTime(System.DateTime.Now.ToString()).ToString("yyyy") + "-" + Convert.ToDateTime(dt.Rows[j]["录用日期"].ToString()).ToString("MM-dd");
Hyoa_flowmain.hy_field31 = Convert.ToDateTime(dt.Rows[j]["录用日期"].ToString()).ToString("yyyy-MM-dd");
//Hyoa_flowmain.hy_field31 = "";
Hyoa_flowmain.hy_field32 = "";
Hyoa_flowmain.hy_field33 = "";
Hyoa_flowmain.hy_field34 = "";
Hyoa_flowmain.hy_field35 = "";
Hyoa_flowmain.hy_field36 = float.Parse(dt.Rows[j]["序号"].ToString());
Hyoa_flowmain.hy_field37 = 0;
Hyoa_flowmain.hy_field38 = 0;
Hyoa_flowmain.hy_field39 = 0;
Hyoa_flowmain.hy_field40 = 0;
Hyoa_flowmain.hy_field41 = "";
Hyoa_flowmain.hy_field42 = "";
Hyoa_flowmain.hy_field43 = "";
Hyoa_flowmain.hy_field44 = "";
Hyoa_flowmain.hy_field45 = "";
Hyoa_flowmain.hy_field46 = "";
Hyoa_flowmain.hy_field47 = "";
Hyoa_flowmain.hy_field48 = "";
Hyoa_flowmain.hy_field49 = "";
Hyoa_flowmain.hy_field50 = "";
Hyoa_flowmain.hy_field51 = "";
Hyoa_flowmain.hy_field52 = "";
Hyoa_flowmain.hy_field53 = "";
Hyoa_flowmain.hy_field54 = "";
Hyoa_flowmain.hy_field55 = "";
Hyoa_flowmain.hy_field56 = "";
Hyoa_flowmain.hy_field57 = "";
Hyoa_flowmain.hy_field58 = "";
Hyoa_flowmain.hy_field59 = "";
Hyoa_flowmain.hy_field60 = "";
Hyoa_flowmain.hy_field61 = "";
Hyoa_flowmain.hy_field62 = "";
Hyoa_flowmain.hy_field63 = "";
Hyoa_flowmain.hy_field64 = "";
Hyoa_flowmain.hy_field65 = "";
Hyoa_flowmain.hy_field66 = "";
Hyoa_flowmain.hy_field67 = "";
Hyoa_flowmain.hy_field68 = "";
Hyoa_flowmain.hy_field69 = "";
Hyoa_flowmain.hy_field70 = "";
Hyoa_flowmain.hy_field71 = 0;
Hyoa_flowmain.hy_field72 = 0;
Hyoa_flowmain.hy_field73 = 0;
Hyoa_flowmain.hy_field74 = 0;
Hyoa_flowmain.hy_field75 = 0;
Hyoa_flowmain.hy_field76 = 0;
Hyoa_flowmain.hy_field77 = 0;
Hyoa_flowmain.hy_field78 = 0;
Hyoa_flowmain.hy_field79 = 0;
Hyoa_flowmain.hy_field80 = 0;
Hyoa_flowmain.hy_field81 = 0;
Hyoa_flowmain.hy_field82 = 0;
Hyoa_flowmain.hy_field83 = 0;
Hyoa_flowmain.hy_field84 = 0;
Hyoa_flowmain.hy_field85 = 0;
Hyoa_flowmain.hy_field86 = 0;
Hyoa_flowmain.hy_field87 = 0;
Hyoa_flowmain.hy_field88 = 0;
Hyoa_flowmain.hy_field89 = 0;
Hyoa_flowmain.hy_field90 = 0;
Hyoa_flowmain.hy_field91 = 0;
Hyoa_flowmain.hy_field92 = 0;
Hyoa_flowmain.hy_field93 = 0;
Hyoa_flowmain.hy_field94 = 0;
Hyoa_flowmain.hy_field95 = 0;
Hyoa_flowmain.hy_field96 = 0;
Hyoa_flowmain.hy_field97 = 0;
Hyoa_flowmain.hy_field98 = 0;
Hyoa_flowmain.hy_field99 = 0;
Hyoa_flowmain.hy_field100 = 0;
Hyoa_flowmain.hy_iftx = "";
Hyoa_flowmain.hy_zhtxsj = "";
Hyoa_flowmain.hy_readuserlist = "";
Hyoa_flowmain.Insert();
}
}
db.Close();
this.lblReturnInformation.Text = "导入成功";
if (File.Exists(this.lblDisplay.Text))
{
System.IO.File.Delete(this.lblDisplay.Text);
}
}
}
protected void btninputrsxt_Click(object sender, EventArgs e)
{
HyoaClass.Hyoa_score Hyoa_score = new HyoaClass.Hyoa_score();
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
Hyoa_score.hy_djsj_start = this.hy_djsj_start_1.Value;
Hyoa_score.hy_djsj_end = this.hy_djsj_end_1.Value;
Hyoa_score.hy_score = this.txtscortbyys.Text;
DataTable dt3 = Hyoa_score.GetAllByScore();
for (int kk = 0; kk < dt3.Rows.Count; kk++)
{
//更新内容
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//文档ID
Hyoa_flowmain.DOCID = Hyoa_global.GetRandom();
Hyoa_flowmain.hy_mudelid = "rsgl";
Hyoa_flowmain.hy_tableid = "6047076e-6a95-4fb8-aec8-5551d3900590";
Hyoa_flowmain.hy_flowid = "";
Hyoa_flowmain.hy_flowname = "";
Hyoa_flowmain.hy_curtacheid = "";
Hyoa_flowmain.hy_curtachename = "";
Hyoa_flowmain.hy_curclrid = "";
Hyoa_flowmain.hy_curclrname = "";
Hyoa_flowmain.hy_djrid = this.Session["hyuid"].ToString();
Hyoa_flowmain.hy_djrname = this.Session["hyuname"].ToString();
Hyoa_flowmain.hy_djrbmid = this.Session["hydeptid"].ToString();
Hyoa_flowmain.hy_djrbmname = this.Session["hydeptname"].ToString();
Hyoa_flowmain.hy_djsj = System.DateTime.Now.ToString();
Hyoa_flowmain.hy_bt = "";
Hyoa_flowmain.hy_content1 = "";
Hyoa_flowmain.hy_content2 = "";
Hyoa_flowmain.hy_content3 = "";
Hyoa_flowmain.hy_content4 = "";
Hyoa_flowmain.hy_content5 = "";
Hyoa_flowmain.hy_field1 = dt3.Rows[kk]["hy_username"].ToString();
Hyoa_flowmain.hy_field2 = dt3.Rows[kk]["hy_deptname"].ToString();
Hyoa_flowmain.hy_field3 = "";
Hyoa_flowmain.hy_field4 = "";
Hyoa_flowmain.hy_field5 = "";
Hyoa_flowmain.hy_field6 = dt3.Rows[kk]["hy_officetel"].ToString();
Hyoa_flowmain.hy_field7 = dt3.Rows[kk]["hy_hometel"].ToString();
Hyoa_flowmain.hy_field8 = dt3.Rows[kk]["hy_mobile"].ToString();
Hyoa_flowmain.hy_field9 = dt3.Rows[kk]["hy_virtualnumber"].ToString();
Hyoa_flowmain.hy_field10 = dt3.Rows[kk]["hy_userid"].ToString();
Hyoa_flowmain.hy_field11 = "考试得分";
Hyoa_flowmain.hy_field12 = this.txtscort.Text;
Hyoa_flowmain.hy_field13 = "";
Hyoa_flowmain.hy_field14 = "";
Hyoa_flowmain.hy_field15 = "";
Hyoa_flowmain.hy_field16 = "";
Hyoa_flowmain.hy_field17 = "";
Hyoa_flowmain.hy_field18 = "";
Hyoa_flowmain.hy_field19 = "";
Hyoa_flowmain.hy_field20 = "";
Hyoa_flowmain.hy_field21 = "";
Hyoa_flowmain.hy_field22 = "";
Hyoa_flowmain.hy_field23 = "";
Hyoa_flowmain.hy_field24 = "";
Hyoa_flowmain.hy_field25 = "";
Hyoa_flowmain.hy_field26 = "";
Hyoa_flowmain.hy_field27 = "";
Hyoa_flowmain.hy_field28 = "";
Hyoa_flowmain.hy_field29 = "";
Hyoa_flowmain.hy_field30 = "";
Hyoa_flowmain.hy_field31 = "";
Hyoa_flowmain.hy_field32 = "";
Hyoa_flowmain.hy_field33 = "";
Hyoa_flowmain.hy_field34 = "";
Hyoa_flowmain.hy_field35 = "";
Hyoa_flowmain.hy_field36 = 0;
Hyoa_flowmain.hy_field37 = 0;
Hyoa_flowmain.hy_field38 = 0;
Hyoa_flowmain.hy_field39 = 0;
Hyoa_flowmain.hy_field40 = 0;
Hyoa_flowmain.hy_field41 = "";
Hyoa_flowmain.hy_field42 = "";
Hyoa_flowmain.hy_field43 = "";
Hyoa_flowmain.hy_field44 = "";
Hyoa_flowmain.hy_field45 = "";
Hyoa_flowmain.hy_field46 = "";
Hyoa_flowmain.hy_field47 = "";
Hyoa_flowmain.hy_field48 = "";
Hyoa_flowmain.hy_field49 = "";
Hyoa_flowmain.hy_field50 = "";
Hyoa_flowmain.hy_field51 = "";
Hyoa_flowmain.hy_field52 = "";
Hyoa_flowmain.hy_field53 = "";
Hyoa_flowmain.hy_field54 = "";
Hyoa_flowmain.hy_field55 = "";
Hyoa_flowmain.hy_field56 = "";
Hyoa_flowmain.hy_field57 = "";
Hyoa_flowmain.hy_field58 = "";
Hyoa_flowmain.hy_field59 = "";
Hyoa_flowmain.hy_field60 = "";
Hyoa_flowmain.Insert();
}
this.Response.Write("<script>alert('"+dt3.Rows.Count.ToString()+"条考试信息，成功导入到人事系统中！')</script>");
}
protected void btnImport_Click(object sender, EventArgs e)
{
String sql;
sql = "";
if (this.lblDisplay.Text == "")
{
this.lblReturnInformation.Text = "请先保存Excel文件!";
}
else
{
sql = "";
sql = " select 排序号,投票类别,投票项目,投票对象,投票截止时间,可投票人员,问题一,问题二,问题三,问题四,问题五,问题六 from OpenDataSource('Microsoft.Jet.OLEDB.4.0','Data Source=''" + this.lblDisplay.Text + "'';User ID=admin;Password=;Extended properties=Excel 5.0')...Sheet1$ ";
HyoaClass.DAO db = new HyoaClass.DAO();
HyoaClass.Hyoa_flowmain Hyoa_flowmain = new HyoaClass.Hyoa_flowmain();
DataTable dt = db.GetDataTable(sql);
//判断导入数据中投票类别或可投票人员有不同就不导入
int flag = 0;
string ls_tplb = "";
string ls_ktpry = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (ls_tplb == "")
{
ls_tplb = dt.Rows[i]["投票类别"].ToString();
}
else
{
if (ls_tplb != dt.Rows[i]["投票类别"].ToString())
{
flag = 1;
break;
}
}
if (ls_ktpry == "")
{
ls_ktpry = dt.Rows[i]["可投票人员"].ToString();
}
else
{
if (ls_ktpry != dt.Rows[i]["可投票人员"].ToString())
{
flag = 1;
break;
}
}
}
if (flag == 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global();
//文档ID
Hyoa_flowmain.DOCID = Hyoa_global.GetRandom();
Hyoa_flowmain.hy_mudelid = "moduletpgl";
Hyoa_flowmain.hy_tableid = "bb4c4ac0-53b4-4c7f-89a6-4bde425c24fd";
Hyoa_flowmain.hy_flowid = "";
Hyoa_flowmain.hy_flowname = "";
Hyoa_flowmain.hy_curtacheid = "";
Hyoa_flowmain.hy_curtachename = "";
Hyoa_flowmain.hy_curclrid = "";
Hyoa_flowmain.hy_curclrname = "";
Hyoa_flowmain.hy_djrid = "admin";
Hyoa_flowmain.hy_djrname = "管理员";
Hyoa_flowmain.hy_djrbmid = "003";
Hyoa_flowmain.hy_djrbmname = "管理员组";
Hyoa_flowmain.hy_djsj = System.DateTime.Now.ToString();
Hyoa_flowmain.hy_bt = "";
Hyoa_flowmain.hy_content1 = "";
Hyoa_flowmain.hy_content2 = "";
Hyoa_flowmain.hy_content3 = "";
Hyoa_flowmain.hy_content4 = "";
Hyoa_flowmain.hy_content5 = "";
Hyoa_flowmain.hy_content6 = "";
Hyoa_flowmain.hy_content7 = "";
Hyoa_flowmain.hy_content8 = "";
Hyoa_flowmain.hy_content9 = "";
Hyoa_flowmain.hy_content10 = "";
Hyoa_flowmain.hy_content11 = "";
Hyoa_flowmain.hy_content12 = "";
Hyoa_flowmain.hy_content13 = "";
Hyoa_flowmain.hy_content14 = "";
Hyoa_flowmain.hy_content15 = "";
Hyoa_flowmain.hy_field1 = dt.Rows[j]["问题一"].ToString();
Hyoa_flowmain.hy_field2 = dt.Rows[j]["问题二"].ToString();
Hyoa_flowmain.hy_field3 = dt.Rows[j]["问题三"].ToString();
Hyoa_flowmain.hy_field4 = dt.Rows[j]["问题四"].ToString();
Hyoa_flowmain.hy_field5 = dt.Rows[j]["问题五"].ToString();
Hyoa_flowmain.hy_field6 = dt.Rows[j]["问题六"].ToString();
Hyoa_flowmain.hy_field7 = "";
Hyoa_flowmain.hy_field8 = "";
Hyoa_flowmain.hy_field9 = "";
Hyoa_flowmain.hy_field10 = dt.Rows[j]["投票项目"].ToString();
Hyoa_flowmain.hy_field11 = "";
Hyoa_flowmain.hy_field12 = "";
Hyoa_flowmain.hy_field13 = "";
Hyoa_flowmain.hy_field14 = "";
Hyoa_flowmain.hy_field15 = "";
Hyoa_flowmain.hy_field16 = "";
Hyoa_flowmain.hy_field17 = "";
Hyoa_flowmain.hy_field18 = "";
Hyoa_flowmain.hy_field19 = "";
Hyoa_flowmain.hy_field20 = dt.Rows[j]["投票类别"].ToString();
Hyoa_flowmain.hy_field21 = dt.Rows[j]["排序号"].ToString();
Hyoa_flowmain.hy_field22 = "";
Hyoa_flowmain.hy_field23 = dt.Rows[j]["投票对象"].ToString();
Hyoa_flowmain.hy_field24 = "";
Hyoa_flowmain.hy_field25 = "";
Hyoa_flowmain.hy_field26 = "";
Hyoa_flowmain.hy_field27 = "";
Hyoa_flowmain.hy_field28 = "";
Hyoa_flowmain.hy_field29 = "";
Hyoa_flowmain.hy_field30 = "";
Hyoa_flowmain.hy_field31 = dt.Rows[j]["投票截止时间"].ToString();
Hyoa_flowmain.hy_field32 = "";
Hyoa_flowmain.hy_field33 = "";
Hyoa_flowmain.hy_field34 = "";
Hyoa_flowmain.hy_field35 = "";
Hyoa_flowmain.hy_field36 = 0;
Hyoa_flowmain.hy_field37 = 0;
Hyoa_flowmain.hy_field38 = 0;
Hyoa_flowmain.hy_field39 = 0;
Hyoa_flowmain.hy_field40 = 0;
Hyoa_flowmain.hy_field41 = dt.Rows[j]["可投票人员"].ToString();
Hyoa_flowmain.hy_field42 = "";
Hyoa_flowmain.hy_field43 = "";
Hyoa_flowmain.hy_field44 = "";
Hyoa_flowmain.hy_field45 = "";
Hyoa_flowmain.hy_field46 = "";
Hyoa_flowmain.hy_field47 = "";
Hyoa_flowmain.hy_field48 = "";
Hyoa_flowmain.hy_field49 = "";
Hyoa_flowmain.hy_field50 = "";
Hyoa_flowmain.hy_field51 = "";
Hyoa_flowmain.hy_field52 = "";
Hyoa_flowmain.hy_field53 = "";
Hyoa_flowmain.hy_field54 = "";
Hyoa_flowmain.hy_field55 = "";
Hyoa_flowmain.hy_field56 = "";
Hyoa_flowmain.hy_field57 = "";
Hyoa_flowmain.hy_field58 = "";
Hyoa_flowmain.hy_field59 = "";
Hyoa_flowmain.hy_field60 = "";
Hyoa_flowmain.hy_field61 = "";
Hyoa_flowmain.hy_field62 = "";
Hyoa_flowmain.hy_field63 = "";
Hyoa_flowmain.hy_field64 = "";
Hyoa_flowmain.hy_field65 = "";
Hyoa_flowmain.hy_field66 = "";
Hyoa_flowmain.hy_field67 = "";
Hyoa_flowmain.hy_field68 = "";
Hyoa_flowmain.hy_field69 = "";
Hyoa_flowmain.hy_field70 = "";
Hyoa_flowmain.hy_field71 = 0;
Hyoa_flowmain.hy_field72 = 0;
Hyoa_flowmain.hy_field73 = 0;
Hyoa_flowmain.hy_field74 = 0;
Hyoa_flowmain.hy_field75 = 0;
Hyoa_flowmain.hy_field76 = 0;
Hyoa_flowmain.hy_field77 = 0;
Hyoa_flowmain.hy_field78 = 0;
Hyoa_flowmain.hy_field79 = 0;
Hyoa_flowmain.hy_field80 = 0;
Hyoa_flowmain.hy_field81 = 0;
Hyoa_flowmain.hy_field82 = 0;
Hyoa_flowmain.hy_field83 = 0;
Hyoa_flowmain.hy_field84 = 0;
Hyoa_flowmain.hy_field85 = 0;
Hyoa_flowmain.hy_field86 = 0;
Hyoa_flowmain.hy_field87 = 0;
Hyoa_flowmain.hy_field88 = 0;
Hyoa_flowmain.hy_field89 = 0;
Hyoa_flowmain.hy_field90 = 0;
Hyoa_flowmain.hy_field91 = 0;
Hyoa_flowmain.hy_field92 = 0;
Hyoa_flowmain.hy_field93 = 0;
Hyoa_flowmain.hy_field94 = 0;
Hyoa_flowmain.hy_field95 = 0;
Hyoa_flowmain.hy_field96 = 0;
Hyoa_flowmain.hy_field97 = 0;
Hyoa_flowmain.hy_field98 = 0;
Hyoa_flowmain.hy_field99 = 0;
Hyoa_flowmain.hy_field100 = 0;
Hyoa_flowmain.hy_iftx = "";
Hyoa_flowmain.hy_zhtxsj = "";
Hyoa_flowmain.hy_readuserlist = "";
Hyoa_flowmain.Insert();
}
db.Close();
this.lblReturnInformation.Text = "导入成功";
if (File.Exists(this.lblDisplay.Text))
{
System.IO.File.Delete(this.lblDisplay.Text);
}
}
else
{
db.Close();
this.lblReturnInformation.Text = "导入数据中又投票类别或可投票人员不相同的数据存在，因此导入不成功";
}
}
}