开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > WEB源码(ASP,PHP,...) > 查看源码
NewDocument.aspx.cs
资源名称：OA.rar　[点击查看]
上传用户：xuming1973
上传日期：2014-02-27
资源大小：17511k
文件大小：21k
源码类别：

WEB源码(ASP,PHP,...)

开发平台：

C#

NewDocument.aspx.cs：源码内容
  1. using System;
  2. using System.Collections;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Web;
  7. using System.Web.SessionState;
  8. using System.Web.UI;
  9. using System.Web.UI.WebControls;
  10. using System.Web.UI.HtmlControls;
  11. using System.IO;
  12. using UDS.Components;
  13. using System.Data.SqlClient;
  15. namespace UDS.SubModule.UnitiveDocument.DocumentFlow
  16. {
  17. /// <summary>
  18. /// NewDocument 的摘要说明。
  19. /// </summary>
  20. public class NewDocument : System.Web.UI.Page
  21. {
  22. protected System.Web.UI.WebControls.Table ht;
  23. protected System.Web.UI.WebControls.TextBox TextBox1;
  24. protected System.Web.UI.WebControls.Label Label1;
  25. protected System.Web.UI.WebControls.Button cmdDelete;
  26. protected System.Web.UI.WebControls.Button cmdReturn;
  27. protected System.Web.UI.WebControls.Button cmdSend;
  28. protected System.Web.UI.WebControls.Button cmdSave;
  30. private long StepID;
  31. private long FlowID;
  32. private long FieldNum=0;
  33. private long DocID;
  34. private bool bEditMode;
  35. private string UserName;
  36. protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
  37. protected System.Web.UI.WebControls.TextBox TextBox2;
  38. private long ProjectID=-1;
  39. protected System.Web.UI.HtmlControls.HtmlInputHidden PID;
  40. protected System.Web.UI.HtmlControls.HtmlSelect ddlProject;
  41. private ArrayList al = new ArrayList(); 
  44. private void Page_Load(object sender, System.EventArgs e)
  45. {
  46. FlowID = Int32.Parse(Request.QueryString["FlowID"]==null?"0":Request.QueryString["FlowID"].ToString());
  47. DocID = Int32.Parse(Request.QueryString["DocID"]==null?"0":Request.QueryString["DocID"].ToString());
  48. UserName = Request.Cookies["UserName"].Value.ToString(); 
  50. //动态添加控件
  53. //if(!Page.IsPostBack)
  54. Bind();
  56. InitControl(DocID);
  58. }
  59. private void Bind()
  60. {
  61. UDS.Components.DocumentFlow df =new UDS.Components.DocumentFlow();
  64. if(DocID>0)
  65. {
  67. //读取稿件内容
  68. FlowID = df.GetDocumentFlowID(DocID);
  69. StepID = df.GetDocumentStepID(DocID);
  70. ProjectID = 0;
  71. cmdSend.Enabled = true;
  72. cmdDelete.Enabled = true;
  73. bEditMode = true;
  74. if(df.IsProject(UserName,DocID))
  75. {
  77. ProjectID = Int32.Parse(PID.Value);
  78. if(!Page.IsPostBack)
  79. {
  80. DataTable dt;
  82. ddlProject.Visible = true;
  83. ddlProject.Items.Clear();
  85. df.GetProject(UserName,out dt);
  87. ddlProject.DataSource = dt.DefaultView;
  88. ddlProject.DataTextField = "ClassName";
  89. ddlProject.DataValueField = "ClassID";
  90. ddlProject.DataBind();
  92. // for(int i=0;i<ddlProject.Items.Count;i++)
  93. // {
  94. // if(ddlProject.Items[i].Value.ToString()==UDS.Components.DocumentFlow.GetDocumentProjectID(DocID).ToString())
  95. // ddlProject.SelectedIndex = i;
  96. // }
  98. if(ddlProject.Items.Count>0)
  99. {
  100. PID.Value = ddlProject.Items[0].Value.ToString(); 
  101. }
  102. }
  103. }
  104. else
  105. {
  106. // StepID = 1;
  107. // cmdSend.Enabled = false;
  108. // cmdDelete.Enabled = false;
  109. // bEditMode = false;
  110. ddlProject.Visible = false;
  111. ddlProject.EnableViewState = false;
  112. }
  113. }
  114. else
  115. {
  116. StepID = 1;
  117. cmdSend.Enabled = false;
  118. cmdDelete.Enabled = false;
  119. bEditMode = false;
  120. ddlProject.EnableViewState = false;
  121. ddlProject.Visible = false;
  122. }
  124. df = null;
  126. }
  127. private void InitControl(long DocID)
  128. {
  129. UDS.Components.DocumentFlow df = new UDS.Components.DocumentFlow();
  131. SqlDataReader dr; //存放人物的数据
  132. DataTable dt = null;
  136. df.GetStyleDescription(FlowID,0,out dr); 
  137. if(DocID>0)
  138. df.GetDocumentInfo(DocID,out dt);
  140. ht.Style["Left"]="1px";
  141. ht.Style["Top"]="1px";
  143. al.Clear();
  144. AddHeadlin();
  146. while(dr.Read())
  147. {
  148. TextBox txt = new TextBox();
  150. txt.ID ="txt" + dr["Field_Name"].ToString();
  151. al.Add(dr["Field_Name"].ToString());
  153. if(dr["MultiLine"].ToString()!="False")
  154. {
  155. txt.TextMode = TextBoxMode.MultiLine; 
  156. }
  157. txt.Height = Int32.Parse( dr["Height"].ToString());
  158. txt.Width = Int32.Parse( dr["Width"].ToString());
  159. txt.CssClass = "Input3";
  161. if(DocID>0)
  162. {
  163. if(dt.Rows.Count >0)
  164. txt.Text = dt.Rows[0][dr["Field_Name"].ToString()].ToString();
  165. else
  166. txt.Text ="不存在";
  167. }
  168. else
  169. txt.Text ="";
  172. TableRow  tr = new TableRow();
  173. TableCell tl = new TableCell();
  174. TableCell tc = new TableCell();
  175. Literal lt = new Literal();
  177. lt.Text = dr["Example"].ToString();
  179. tc.Controls.Add(txt);
  180. if(FieldNum==0||dr["judged"].ToString()=="True")
  181. {
  182. RequiredFieldValidator  rfv = new RequiredFieldValidator(); 
  183. rfv.ControlToValidate = txt.ID;
  184. rfv.ErrorMessage = "(*)";
  185. rfv.Display = ValidatorDisplay.Dynamic;
  186. rfv.EnableClientScript = true;
  188. tc.Controls.Add(rfv);
  189. }
  190. if(dr["judged"].ToString()=="True")
  191. {
  193. RegularExpressionValidator rev = new RegularExpressionValidator();
  195. rev.ErrorMessage = "填写数字";
  196. rev.ControlToValidate = txt.ID;
  197. rev.ValidationExpression = @"d+";
  199. rev.Display = ValidatorDisplay.Dynamic;
  201. tc.Controls.Add(rev);
  203. }
  206. tc.Controls.Add(lt);
  208. tl.Text = dr["Field_Description"].ToString() + ":";
  210. if(dr["MultiLine"].ToString()!="False")
  211. tl.VerticalAlign = VerticalAlign.Top;
  212. else
  213. tl.VerticalAlign = VerticalAlign.Middle;
  214. tl.HorizontalAlign = HorizontalAlign.Right;
  217. tr.Cells.Add(tl);
  218. tr.Cells.Add(tc);
  219. ht.Rows.Add(tr);
  221. tc = null;
  222. tl = null;
  223. tr = null;
  225. FieldNum +=1;
  227. }
  228. dr.Close();
  229. dr = null;
  231. if(DocID>0)
  232. AddAttach(DocID);
  234. AddAttachControl();
  235. AddProjectControl();
  236. AddControl();
  238. //=============================//
  239. // 添加批注
  240. //=============================//
  241. DataTable dtPostil;
  242. df.GetDocumentPostil(DocID,out dtPostil); 
  244. if(dtPostil!=null)
  245. {
  246. if(dtPostil.Rows.Count>0)
  247. {
  248. Table tb = new Table();
  249. tb.CssClass ="GbText";
  250. tb.Width = Unit.Percentage(98);
  251. AddRow(tb,"审批意见");
  252. AddPostitleHead(tb);
  254. for(int i=0;i<dtPostil.Rows.Count;i++)
  255. {
  256. AddRow(tb,dtPostil.Rows[i]["RealName"].ToString(),dtPostil.Rows[i]["Postil_Date"].ToString(),dtPostil.Rows[i]["Postil_Content"].ToString(),Int32.Parse(dtPostil.Rows[i]["Postil_Type"].ToString() ),dtPostil.Rows[i]["FileName"].ToString(),dtPostil.Rows[i]["FileVisualPath"].ToString(),dtPostil.Rows[i]["UsedTime"].ToString());
  257. }
  258. AddTable(ht,tb);
  259. }
  260. }
  261. dtPostil = null;
  265. }
  266. #region Web Form Designer generated code
  267. override protected void OnInit(EventArgs e)
  268. {
  269. //
  270. // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
  271. //
  272. InitializeComponent();
  273. base.OnInit(e);
  274. }
  276. /// <summary>
  277. /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  278. /// 此方法的内容。
  279. /// </summary>
  280. private void InitializeComponent()
  281. {    
  282. this.cmdSave.Click += new System.EventHandler(this.cmdSave_Click);
  283. this.cmdSend.Click += new System.EventHandler(this.cmdSend_Click);
  284. this.cmdDelete.Click += new System.EventHandler(this.cmdDelete_Click);
  285. this.cmdReturn.Click += new System.EventHandler(this.cmdReturn_Click);
  286. this.PID.ServerChange += new System.EventHandler(this.PID_ServerChange);
  287. this.Load += new System.EventHandler(this.Page_Load);
  289. }
  290. #endregion
  292. private void AddTable(Table tab,Table tb)
  293. {
  294. TableRow tr = new TableRow();
  295. TableCell tl = new TableCell();
  296. tl.ColumnSpan = 2;
  297. tl.Width = Unit.Percentage(100);
  298. tl.HorizontalAlign  = HorizontalAlign.Center;
  299. //tl.Attributes["background"]="../../../Images/treetopbg.jpg";
  300. tl.Controls.Add(tb);
  301. //tl.BackColor = Color.FromArgb(0xff,0xff,0xef);
  303. tr.Height = 28;
  304. tr.Cells.Add(tl);
  306. tab.Rows.Add(tr);
  308. tl = null;
  309. tr = null;
  311. }
  313. private void AddRow(Table tab,string Caption)
  314. {
  315. TableRow tr = new TableRow();
  316. TableCell tl = new TableCell();
  318. tl.Text = Caption;
  319. tl.ColumnSpan = 6 ;
  320. tl.Width = Unit.Percentage(100);
  321. tl.HorizontalAlign  = HorizontalAlign.Center;
  322. tl.Attributes["background"]="../../../Images/treetopbg.jpg";
  323. //tl.BackColor = Color.FromArgb(0xff,0xff,0xef);
  325. tr.Height = 28;
  326. tr.Cells.Add(tl);
  328. tab.Rows.Add(tr);
  330. tl = null;
  331. tr = null;
  332. }
  333. private void AddRow(Table tab,string Postiler,string PostilTime,string PostilContent,int PostilType,string FileName,string FileVisualPath,string UsedTime)
  334. {
  335. TableRow tr = new TableRow();
  336. TableCell tdPotiler = new TableCell();
  337. TableCell tdPostilTime = new TableCell();
  338. TableCell tdPotilType = new TableCell();
  339. TableCell tdPotilContent = new TableCell();
  340. TableCell tdAttachFiles = new TableCell();
  341. TableCell tdTime = new TableCell();
  344. tdPotiler.Text = Postiler;
  345. tdPotiler.HorizontalAlign = HorizontalAlign.Center;
  346. tdPotiler.Width = Unit.Percentage(20);
  349. tdPostilTime.Text = PostilTime;
  350. tdPostilTime.HorizontalAlign = HorizontalAlign.Center;
  351. tdPostilTime.Width = Unit.Percentage(20);
  352. switch(PostilType)
  353. {
  354. case 1:
  355. tdPotilType.Text = "同意";
  356. break;
  357. case 2:
  358. tdPotilType.Text = "拒绝";
  359. break;
  360. case 3:
  361. tdPotilType.Text = "完成";
  362. break;
  363. case 4:
  364. tdPotilType.Text = "回退";
  365. break;
  366. default:
  367. break;
  368. }
  369. tdPotilType.HorizontalAlign = HorizontalAlign.Center;
  370. tdPotilType.Width = Unit.Percentage(10);
  373. tdPotilContent.Text = PostilContent;
  374. tdPotilContent.HorizontalAlign = HorizontalAlign.Left;
  375. tdPotilContent.Width = Unit.Percentage(30);
  377. tr.Height  =22;
  378. tr.BackColor = Color.FromArgb(0xe8,0xf4,0xff);
  381. string FilePath = FileVisualPath + FileName;
  382. tdAttachFiles.Text = "<a href='" +"." + FilePath.Replace("\","/") +"' target='_blank'>" + FileName + "</a>";
  384. tdAttachFiles.HorizontalAlign = HorizontalAlign.Center  ;
  385. tdAttachFiles.Width = Unit.Percentage(10);
  387. tdTime.Text = UsedTime;
  388. tdTime.HorizontalAlign = HorizontalAlign.Center  ;
  389. tdTime.Width = Unit.Percentage(10);
  391. tr.Cells.Add(tdPotiler);
  392. tr.Cells.Add(tdPostilTime);
  393. tr.Cells.Add(tdPotilType);
  394. tr.Cells.Add(tdPotilContent);
  395. tr.Cells.Add(tdAttachFiles);
  396. tr.Cells.Add(tdTime);
  399. tab.Rows.Add(tr);
  402. tdPotiler = null;
  403. tdPostilTime = null;
  404. tdPotilType = null;
  405. tdPotilContent = null;
  406. tdAttachFiles = null;
  407. tdTime = null;
  409. tr = null;
  410. }
  411. private void AddPostitleHead(Table tab)
  412. {
  414. TableRow tr = new TableRow();
  415. TableCell tdPotiler = new TableCell();
  416. TableCell tdPostilTime = new TableCell();
  417. TableCell tdPotilType = new TableCell();
  418. TableCell tdPotilContent = new TableCell();
  419. TableCell tdAttachFiles = new TableCell();
  420. TableCell tdTime = new TableCell();
  423. tdPotiler.Text ="批阅人";
  424. tdPotiler.HorizontalAlign = HorizontalAlign.Center;
  425. tdPotiler.Width = Unit.Percentage(20);
  428. tdPostilTime.Text ="批阅时间";
  429. tdPostilTime.HorizontalAlign = HorizontalAlign.Center;
  430. tdPostilTime.Width = Unit.Percentage(20);
  432. tdPotilType.Text ="批阅类型";
  433. tdPotilType.HorizontalAlign = HorizontalAlign.Center;
  434. tdPotilType.Width = Unit.Percentage(10);
  437. tdPotilContent.Text ="批阅内容";
  438. tdPotilContent.HorizontalAlign = HorizontalAlign.Left ;
  439. tdPotilContent.Width = Unit.Percentage(30);
  441. tdAttachFiles.Text ="附件";
  443. tdAttachFiles.HorizontalAlign = HorizontalAlign.Center  ;
  444. tdAttachFiles.Width = Unit.Percentage(10);
  446. tdTime.Text ="用时(分)";
  447. tdTime.HorizontalAlign = HorizontalAlign.Center  ;
  448. tdTime.Width = Unit.Percentage(10);
  451. tr.Height  =22;
  452. tr.BackColor = Color.FromArgb(0xe8,0xf4,0xff);
  454. tr.Cells.Add(tdPotiler);
  455. tr.Cells.Add(tdPostilTime);
  456. tr.Cells.Add(tdPotilType);
  457. tr.Cells.Add(tdPotilContent);
  458. tr.Cells.Add(tdAttachFiles);
  459. tr.Cells.Add(tdTime);
  462. tab.Rows.Add(tr);
  465. tdPotiler = null;
  466. tdPostilTime = null;
  467. tdPotilType = null;
  468. tdPotilContent = null;
  470. tr = null;
  472. }
  473. private void AddProjectControl()
  474. {
  476. if(ddlProject.Visible == true)
  477. {
  478. TableRow  tr = new TableRow();
  479. TableCell td = new TableCell();
  480. TableCell tl = new TableCell();
  482. td.Text  = "请选择所属项目:";
  483. td.HorizontalAlign = HorizontalAlign.Right;
  484. tr.Cells.Add(td);
  486. ddlProject.Style["Width"] = "450px";
  487. ddlProject.Style["Class"] = "Input3";
  489. tl.Controls.Add(ddlProject);
  490. tr.Cells.Add(tl);
  492. ht.Rows.Add(tr);
  494. td = null;
  495. tr = null;
  496. //ddlProject.EnableViewState =true;
  497.  
  498. }
  501. }
  503. private void AddAttach(long DocID)
  504. {
  506. UDS.Components.DocumentFlow df = new UDS.Components.DocumentFlow();
  507. DataTable dt = new DataTable();
  509. df.GetDocumentAttach(DocID,out dt);
  510. for(int i=0;i<dt.Rows.Count;i++)
  511. {
  512. TableRow  tr = new TableRow();
  513. TableCell td = new TableCell();
  514. TableCell tc = new TableCell();
  516. td.Text ="附件:";
  517. td.HorizontalAlign = HorizontalAlign.Right;
  519. string FilePath = dt.Rows[i]["FileVisualPath"].ToString() + dt.Rows[i]["FileName"].ToString();
  521. tc.Text = "<a href='" +"." + FilePath.Replace("\","/") +"' target='_blank'>" + dt.Rows[i]["FileName"].ToString() + "</a>";
  522. tc.HorizontalAlign = HorizontalAlign.Left;
  524. tr.Cells.Add(td);
  525. tr.Cells.Add(tc);
  527. tr.Height = 22;
  528. tr.HorizontalAlign = HorizontalAlign.Center;
  530. ht.Rows.Add(tr);
  531. }
  533. dt = null;
  534. df = null;
  537. }
  539. private void AddAttachControl()
  540. {
  541. string Template;
  542. UDS.Components.DocumentFlow df = new UDS.Components.DocumentFlow();
  543. Template = df.GetStyleTemplate(FlowID);
  544. if(Template!="")
  545. {
  546. TableRow  tr = new TableRow();
  547. TableCell td = new TableCell();
  548. TableCell tl = new TableCell();
  550. td.Text  = "<a href='" + Template + "' style='text-decoration: underline' titile='模板下载' target='_blank'>模板</a>:";
  551. td.HorizontalAlign = HorizontalAlign.Right;
  552. tr.Cells.Add(td);
  554. System.Web.UI.HtmlControls.HtmlInputFile hif = new System.Web.UI.HtmlControls.HtmlInputFile();
  555. hif.ID = "fileTemplate";
  556. hif.Name = "fileTemplate";
  557. hif.Style["width"] = "450px";
  558. hif.Style["Class"] = "Input3";
  560. tl.Controls.Add(hif);
  561. tr.Cells.Add(tl);
  563. ht.Rows.Add(tr);
  565. td = null;
  566. tr = null;
  568. }
  570. df = null;
  572. }
  574. private void UploadFile(long DocID)
  575. {
  576. string FileName = "";
  577. HtmlForm FrmCompose   = (HtmlForm)this.Page.FindControl("NewDocument");
  579. //生成附件目录
  580. if(!System.IO.Directory.Exists(Server.MapPath(".")+"\AttachFiles"))
  581. {
  582. System.IO.Directory.CreateDirectory(Server.MapPath(".")+"\AttachFiles");
  583. }
  585. try
  586. {
  587. HtmlInputFile hif = ((HtmlInputFile)(FrmCompose.FindControl("fileTemplate")));
  588. if(hif.PostedFile!=null)
  589. {
  590. if(hif.PostedFile.FileName.Trim()!="")
  591. {
  592. FileName = System.IO.Path.GetFileName(hif.PostedFile.FileName);
  594. //生成用户目录
  595. if(!System.IO.Directory.Exists(Server.MapPath(".")+"\AttachFiles\" + UserName))
  596. {
  597. System.IO.Directory.CreateDirectory(Server.MapPath(".")+"\AttachFiles\"+ UserName);
  598. }
  600. Random TempNameInt    = new Random(); 
  601. string NewDocDirName  = TempNameInt.Next(100000000).ToString();
  602. //生成随机目录
  603. if(!System.IO.Directory.Exists(Server.MapPath(".")+"\AttachFiles\" + UserName + "\" + NewDocDirName))
  604. {
  605. System.IO.Directory.CreateDirectory(Server.MapPath(".")+"\AttachFiles\" + UserName  + "\" + NewDocDirName);
  606. }
  608. TempNameInt = null;
  610. //保存文件
  611. hif.PostedFile.SaveAs(Server.MapPath(".")+"\AttachFiles\" + UserName  + "\" + NewDocDirName + "\" + FileName);
  613. UDS.Components.DocAttachFile att = new UDS.Components.DocAttachFile();
  614. UDS.Components.DocumentFlow  df  = new UDS.Components.DocumentFlow();
  616. // 初始化
  617. att.FileAttribute = 0;
  618. att.FileSize = hif.PostedFile.ContentLength;
  619. att.FileName = FileName;
  620. att.FileAuthor = UserName;
  621. att.FileCatlog = "公文";
  622. att.FileVisualPath = "\AttachFiles\" + UserName  + "\" + NewDocDirName + "\";
  623. att.FileAddedDate = DateTime.Now.ToString();;
  625. df.AddAttach(att,DocID);
  627. df = null;
  628. att = null;
  630. }
  631. hif=null;
  632. }
  633. }
  634. catch(Exception ex)
  635. {
  636. UDS.Components.Error.Log(ex.ToString());
  637. }
  638. finally
  639. {
  641. }
  643. }
  645. private void AddHeadlin()
  646. {
  647. UDS.Components.DocumentFlow df = new UDS.Components.DocumentFlow();
  648. TableRow  tr = new TableRow();
  649. TableCell td = new TableCell();
  651. td.Text = df.GetStyleHeadline(FlowID);
  652. td.ColumnSpan = 2;
  653. td.Height = 28;
  654. td.Attributes["BackGround"] = "../../../images/treetopbg.jpg";
  656. tr.Cells.Add(td);
  658. tr.HorizontalAlign = HorizontalAlign.Center;
  659. tr.BackColor = Color.FromArgb(0xff,0xff,0xef);
  660. ht.Rows.Add(tr);
  662. td = null;
  663. tr = null;
  664. df = null;
  666. }
  668. private void AddControl()
  669. {
  670. TableRow  tr = new TableRow();
  671. TableCell td = new TableCell();
  673. cmdSave.Style["Top"] = td.Style["Top"]; 
  675. td.Controls.Add(cmdSave);
  676. td.Controls.Add(cmdSend);
  677. td.Controls.Add(cmdDelete);
  678. td.Controls.Add(cmdReturn);;
  680. td.ColumnSpan = 2;
  682. tr.Cells.Add(td);
  684. tr.HorizontalAlign = HorizontalAlign.Center;
  685. ht.Rows.Add(tr);
  687. // td = null;
  688. // tr = null;
  689. }
  690. private string GetStyleInsertData()
  691. {
  692. string mySql="";
  693. HtmlForm FrmNewDocument   = (HtmlForm)this.Page.FindControl("NewDocument");
  695. mySql += "insert into UDS_Flow_Style_Data (";
  696. for(int i=0;i<FieldNum;i++)
  697. {
  698. mySql += al[i].ToString()+",";
  699. }
  700. mySql = mySql.Substring(0,mySql.Length-1)+") values(";
  701. for(int i=0;i<FieldNum;i++)
  702. {
  703. mySql += "'" + ((TextBox)FrmNewDocument.FindControl("txt" + al[i].ToString())).Text.Replace("'","''") + "',"; 
  704. }
  705. mySql = mySql.Substring(0,mySql.Length-1)+")";
  706. return mySql;
  707. }
  708. private string GetStyleUpdateData(long DocID)
  709. {
  710. string mySql="";
  711. HtmlForm FrmNewDocument   = (HtmlForm)this.Page.FindControl("NewDocument");
  713. if( FieldNum>0)
  714. {
  715. mySql += "update UDS_Flow_Style_Data set ";
  716. for(int i=0;i<FieldNum;i++)
  717. {
  718. mySql += al[i].ToString()+"=" + "'" + ((TextBox)FrmNewDocument.FindControl("txt" + al[i].ToString())).Text.Replace("'","''") + "'";
  719. if(i!=(FieldNum-1))
  720. mySql += ",";
  721. }
  722. mySql += " where Doc_ID = " + DocID.ToString();
  724. return mySql;
  725. }
  726. else
  727. {
  728. return "Select 1";
  729. }
  731. }
  732. private void cmdSend_Click(object sender, System.EventArgs e)
  733. {
  734. //发送到下一环节，使程序处于运行中
  735. UDS.Components.DocumentFlow df = new UDS.Components.DocumentFlow();
  737. if(ProjectID>=0)
  738. {
  739. int iResult = df.PostDocument(UserName,DocID,ProjectID);
  741. if(iResult==0)
  742. {
  743. df = null;
  744. Server.Transfer("DisplayDocument.aspx?DocID=" + DocID.ToString());
  745. }
  746. else
  747. {
  748. Response.Write("<script lanuage='javascript'>alert('" + df.DoMessage(iResult,DocID,false) + "');</script>");
  749. }
  751. }
  752. else
  753. Response.Write("<script language='javascript'>alert('用户没有一个项目，不能按项目发送！');</script>");
  754. df = null;
  755. }
  757. private void cmdDelete_Click(object sender, System.EventArgs e)
  758. {
  759. //删除拟稿文档
  760. UDS.Components.DocumentFlow df = new UDS.Components.DocumentFlow();
  761. df.DeleteDocument(DocID);
  762. df = null;
  763. Server.Transfer("FlowTemplate.aspx");
  764. }
  766. private void cmdReturn_Click(object sender, System.EventArgs e)
  767. {
  768. Server.Transfer("DraftList.aspx");
  769. }
  771. private void cmdSave_Click(object sender, System.EventArgs e)
  772. {
  773. UDS.Components.DocumentFlow df = new UDS.Components.DocumentFlow();
  774. string mySql;
  777. if(bEditMode==false)
  778. {
  780. mySql= GetStyleInsertData();
  782. //拟稿
  783. DocID=df.AddDocument(UserName,FlowID,mySql);
  785. //上传文件
  786. UploadFile(DocID);
  788. df = null;
  790. //转到查看稿件
  791. Server.Transfer("NewDocument.aspx?FlowID=" + FlowID.ToString() + "&DocID=" + DocID.ToString());
  793. }
  794. else
  795. {
  796. mySql = GetStyleUpdateData(DocID);
  798. //Response.Write("<script language='javascript'>alert('" + mySql + "');</script>");
  799. df.UpdateDocument(mySql);
  801. string FileName = df.GetAttachName(DocID);
  802. if(FileName.Length>0)
  803. {
  804. df.DeleteAttach(DocID);
  805. if(System.IO.File.Exists(Server.MapPath(@"." + FileName))==true)
  806. System.IO.File.Delete(Server.MapPath(@"." + FileName));
  807. }
  809. //上传文件
  810. UploadFile(DocID);
  812. df = null;
  813. //修改编辑文件
  814. }
  815. Response.AddHeader("Refresh","1");
  817. }
  819. private void PID_ServerChange(object sender, System.EventArgs e)
  820. {
  822. }
  824. }
  825. }