using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace OAM { public partial class frmWorkBillView : Form { public frmWorkBillView() { InitializeComponent(); } public const int HFileNameCol = 0;//huan public const int HFilePathCol = 1; public const int HUpManCol = 2; public const int HItemIDCol = 3; // public const int MainType = 2; public long ID; private void cmdHasten_Click(object sender, EventArgs e) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); if (MessageBox.Show("确认要催促对方？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel) { return; } lblHasten.Text = DBUtility.ClsPub.isStrNull(DBUtility.ClsPub.isInt(lblHasten.Text) + 1); oCn.RunProc("update oa_workbillmain set Hasten=Hasten+1,isback=0,isread=0 where id=" + ID); oCn.RunProc("update oa_workbillsub2 set isread=0 where mainid=" + ID); } private void cmdSelectEmps2_Click(object sender, EventArgs e) { DBUtility.Gy_UserSelect oUser = new DBUtility.Gy_UserSelect(); oUser.bSingle = false; oUser.ShowDialog(); if (oUser.IsOk == 1) { txtRtransmitMan.Text = oUser.sReturn; } else { txtRtransmitMan.Text = ""; } } private void button2_Click(object sender, EventArgs e) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); if (txtRtransmitMan.Text.Trim() == "") { MessageBox.Show("请选择转发人"); } oCn.RunProc("update oa_workbillmain set RtransmitMan='" + txtRtransmitMan.Text.ToString() + "',transmitMan='" + DBUtility.ClsPub.CurUserName + "' where id=" + ID); DataSet Ds; long i = 0; Ds = oCn.RunProcReturn("select max(subid) as MaxID from oa_workbillsub2 where mainid=" + ID, "oa_workbillsub2"); if (Ds != null && Ds.Tables[0].Rows.Count != 0) { i = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]); } if (txtRtransmitMan.Text != "") { string[] s = txtRtransmitMan.Text.Split(','); int len = s.Length; for (int z = 0; z < len; z++) { i = i + 1; string k = s[z].ToString(); oCn.RunProc("insert into oa_workbillsub2 (MainID,SubID,ROperator,isRead,isKnow) " + "values (" + ID + "," + i + ",'" + k + "',0,0)"); } } MessageBox.Show("已经成功转发！"); } private void button1_Click(object sender, EventArgs e) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); if (txtOperator.Text == DBUtility.ClsPub.CurUserName) { DialogResult dr = MessageBox.Show("确定要删除此单据吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.Yes) { if (!DBUtility.ClsPub.Security_Log("OA_Manager", 1, true, DBUtility.ClsPub.CurUserName)) { return; } //SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); oCn.RunProc("delete from oa_workbillsub where Mainid=" + ID); oCn.RunProc("delete from oa_workbillsub2 where Mainid=" + ID); oCn.RunProc("delete from oa_workbillMain where id=" + ID); MessageBox.Show("删除成功！"); this.Close(); } else { } } else { MessageBox.Show("对不起!只有发送人才能删除！"); } } private void button3_Click(object sender, EventArgs e) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); if (txtROperator.Text == DBUtility.ClsPub.CurUserName) { if (txtContext_New.Text == "") { MessageBox.Show("请填写内容！"); return; } string Context_New = txtContext_New.Text.Replace("'", "‘"); int Rows = grdMain.Rows.Count + 1; oCn.RunProc("Insert into oa_workbillsub(mainid,id,context,operator,opdate,sisEnd) values(" + ID + "," + Rows + ",'" + Context_New + "','" + DBUtility.ClsPub.CurUserName + "',getdate(),1)"); oCn.RunProc("update oa_workbillmain set isend=1 where id=" + ID + " and roperator='" + DBUtility.ClsPub.CurUserName + "'"); oCn.RunProc("insert into oa_workbillsub2(mainid,subid,roperator,isread,isknow) values(" + ID + "," + GetMaxSubID(ID) + ",'" + txtOperator.Text.ToString() + "',0,0)"); Display(); } else { MessageBox.Show("对不起，你不能结案！"); } } private void button4_Click(object sender, EventArgs e) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); if (txtOperator.Text == DBUtility.ClsPub.CurUserName) { frmWorkBillView_Dlg oDlg = new frmWorkBillView_Dlg(); oDlg.ShowDialog(); if (oDlg.isOK == 1) { string Context_New = oDlg.txtHContext.Text.Replace("'", "‘"); int Rows = grdMain.Rows.Count + 1; oCn.RunProc("Insert into oa_workbillsub(mainid,id,context,operator,opdate,sislast) values(" + ID + "," + Rows + ",'" + Context_New + "','" + DBUtility.ClsPub.CurUserName + "',getdate(),1)"); oCn.RunProc("update oa_workbillmain set islast=1 , HEvaluateStatusID=" + oDlg.txtHEvaluateStatusID.SelectedIndex + " where id=" + ID); oCn.RunProc("insert into oa_workbillsub2(mainid,subid,roperator,isread,isknow) values(" + ID + "," + GetMaxSubID(ID) + ",'" + txtROperator.Text + "',0,0)"); Display(); } } else { MessageBox.Show("对不起，你不能验证"); } } private void cmdSend_Click(object sender, EventArgs e) { DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); DBUtility.ClsPub.SaveGridView(grdFJ, this.Name + "grdFJ", DBUtility.ClsPub.AppPath); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); if (txtContext_New.Text == "") { MessageBox.Show("请填写回复内容！"); return; } int Rows = grdMain.Rows.Count + 1; oCn.RunProc("Insert into oa_workbillsub(mainid,id,context,operator,opdate) values(" + ID + "," + Rows + ",'" + txtContext_New.Text.ToString() + "','" + DBUtility.ClsPub.CurUserName + "',getdate())"); oCn.RunProc("update oa_workbillmain set isback=1 where id=" + ID + " and roperator='" + DBUtility.ClsPub.CurUserName + "'"); oCn.RunProc("insert into oa_workbillsub2(mainid,subid,roperator,isread,isknow) values(" + ID + "," + GetMaxSubID(ID) + ",'" + txtOperator.Text.ToString() + "',0,0)"); Display(); } private void cmdCancel_Click(object sender, EventArgs e) { DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); DBUtility.ClsPub.SaveGridView(grdFJ, this.Name + "grdFJ", DBUtility.ClsPub.AppPath); this.Close(); } public void Display() { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds; Ds = oCn.RunProcReturn("Select * from oa_workbillmain where id=" + ID, "oa_workbillmain", ref DBUtility.ClsPub.sExeReturnInfo); if (Ds == null ) { MessageBox.Show("显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo); return; } txtContext.Text = Ds.Tables[0].Rows[0]["context"].ToString(); txtDesc.Text = Ds.Tables[0].Rows[0]["Description"].ToString(); if (Ds.Tables[0].Rows[0]["roperator"].ToString() == DBUtility.ClsPub.CurUserName) { oCn.RunProc("update oa_workbillmain set isread=1 where id=" + ID); } // If Trim(oRs!operator & "") = Trim(CurUserName) Then // Toolbar1.Buttons("cchu").Enabled = True // Toolbar1.Buttons("yzh").Enabled = True // Else // Toolbar1.Buttons("cchu").Enabled = False // Toolbar1.Buttons("yzh").Enabled = False // End If // If Trim(oRs!roperator & "") = Trim(CurUserName) Then // Toolbar1.Buttons("ja").Enabled = True // Else // Toolbar1.Buttons("ja").Enabled = False // End If // lblHasten.Text = Ds.Tables[0].Rows[0]["hasten"].ToString(); txtOperator.Text = Ds.Tables[0].Rows[0]["operator"].ToString(); txtROperator.Text = Ds.Tables[0].Rows[0]["roperator"].ToString(); txtRoperator2.Text = Ds.Tables[0].Rows[0]["roperator2"].ToString(); txtRtransmitMan.Text = Ds.Tables[0].Rows[0]["rtransmitman"].ToString(); txttransmitMan.Text = Ds.Tables[0].Rows[0]["transmitman"].ToString(); txtHRemark.Text = Ds.Tables[0].Rows[0]["HRemark"].ToString(); txtHBillNo.Text = Ds.Tables[0].Rows[0]["hbillno"].ToString(); cmbHLevel.Text = Ds.Tables[0].Rows[0]["HLevel"].ToString(); // //If (Eva.GetInfoByID(Val(oRs!HEvaluateStatusID))) Then // cmbHEvaluateStatus.Text = Trim(Eva.HName & "") //Else // cmbHEvaluateStatus.Text = "" //End If // cmbHEvaluateStatus.SelectedIndex =DBUtility.ClsPub.isInt( Ds.Tables[0].Rows[0]["HEvaluateStatusID"].ToString()); if (Ds.Tables[0].Rows[0]["FDate"].ToString() != "") { dtpFDate.Value = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["FDate"].ToString()); } if (Ds.Tables[0].Rows[0]["HCommDate"].ToString() != "") { DtpHCommDate.Value = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HCommDate"].ToString()); } oCn.RunProc("update oa_workbillsub2 set isread=1 where mainid=" + ID + " and roperator='" + DBUtility.ClsPub.CurUserName + "'"); Ds = oCn.RunProcReturn("Select Operator 发送人,convert(varchar(5),opdate,110)+' '+convert(varchar(5),opdate,108) 发送日期,case when isnull(sisend,0)<>0 then '结案:'+Context else case when isnull(sislast,0)<>0 then '验证:'+Context else '回复:'+Context end end 内容 from oa_workbillsub where mainid=" + ID + " and id>=0 order by opdate desc", "oa_workbillsub", ref DBUtility.ClsPub.sExeReturnInfo); if (Ds == null) { MessageBox.Show("显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo); return; } grdMain.DataSource = Ds.Tables[0].DefaultView; //附件 huan DisplayFJ(); // DBUtility.ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); } private void frmWorkBillView_Load(object sender, EventArgs e)//huan { initGridFJ(); } private void initGridFJ()//huanxin { grdFJ.ColumnCount = 4; //总列数 DBUtility.Xt_BaseBillFun.initGridFst(grdFJ, this.Name + "grdFJ"); grdFJ.ReadOnly = true; grdFJ.RowCount = 0; //= grdFJ.Columns[HFileNameCol].HeaderText = "文件名称"; grdFJ.Columns[HFilePathCol].HeaderText = "文件路径"; grdFJ.Columns[HUpManCol].HeaderText = "上传人"; DBUtility.ClsPub.GetGridView(grdFJ, this.Name + "grdFJ", DBUtility.ClsPub.AppPath); } private void DisplayFJ()//huan { SQLHelper.ClsCNK3 oCn = new SQLHelper.ClsCNK3(); DataSet Ds; Ds = oCn.RunProcReturn("Select fitemid,fupman,ffilename,fpath from OA_Accessories where FFileID=" + ID, "OA_Accessories"); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { return; } for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) { grdFJ.Rows.Add(); grdFJ.Rows[i].Cells[HFileNameCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["FFileName"]); grdFJ.Rows[i].Cells[HFilePathCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["FPath"]); grdFJ.Rows[i].Cells[HUpManCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["FUpMan"]); grdFJ.Rows[i].Cells[HItemIDCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["FItemID"]); } } private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; timer1.Interval = 60000; Display(); } private void fsh_Click(object sender, EventArgs e) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); oCn.RunProc(""); } private long GetMaxSubID(long MainID) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds; long MaxSubID; Ds = oCn.RunProcReturn("select max(subid)as subid from oa_workbillsub2 where mainid=" + MainID, "oa_workbillsub2"); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { MaxSubID = 0; } else { MaxSubID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) + 1; } return MaxSubID; } private void cmdAdd_Click(object sender, EventArgs e)//huan { OpenFileDialog oDlg = new OpenFileDialog(); oDlg.Filter = "所有文件|*.*"; if (oDlg.ShowDialog() == DialogResult.OK) { if (oDlg.FileName != "") { grdFJ.Rows.Add(); grdFJ.Rows[grdFJ.Rows.Count - 1].Cells[HFileNameCol].Value = oDlg.SafeFileName; grdFJ.Rows[grdFJ.Rows.Count - 1].Cells[HFilePathCol].Value = oDlg.FileName; grdFJ.Rows[grdFJ.Rows.Count - 1].Cells[HUpManCol].Value = DBUtility.ClsPub.CurUserName; //直接上传 BLL.ClsXt_FileCtrl oFile = new BLL.ClsXt_FileCtrl(); if (oFile.LoadUpFile(ID, MainType, DBUtility.ClsPub.isStrNull(grdFJ.Rows[grdFJ.Rows.Count - 1].Cells[HFilePathCol].Value), 0, DBUtility.ClsPub.isStrNull(grdFJ.Rows[grdFJ.Rows.Count - 1].Cells[HFileNameCol].Value), DBUtility.ClsPub.CurUserName) == false) { MessageBox.Show("上传文件时失败!"); } // } } } private void grdFJ_DoubleClick(object sender, EventArgs e)//huan { if (grdFJ.CurrentRow == null) { return; } //下载附件到本地，并执行 BLL.ClsXt_FileCtrl oFile = new BLL.ClsXt_FileCtrl(); SQLHelper.ClsCNK3 oCNK3 = new SQLHelper.ClsCNK3(); if (oFile.WriteFile("FFile" , DBUtility.ClsPub.AppPath + @"\a\" + DBUtility.ClsPub.isStrNull(grdFJ.Rows[grdFJ.CurrentRow.Index].Cells[HFileNameCol].Value) , DBUtility.ClsPub.isLong(grdFJ.Rows[grdFJ.CurrentRow.Index].Cells[HItemIDCol].Value), oCNK3) == false) { MessageBox.Show("读取文件时失败!"); } System.Diagnostics.Process.Start(DBUtility.ClsPub.AppPath + @"\a\" + DBUtility.ClsPub.isStrNull(grdFJ.Rows[grdFJ.CurrentRow.Index].Cells[HFileNameCol].Value)); } private void cmdDel_Click(object sender, EventArgs e) //huan { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); if (grdFJ.CurrentRow == null) { return; } if (DBUtility.ClsPub.isStrNull(grdFJ.Rows[grdFJ.CurrentRow.Index].Cells[HUpManCol].Value) != DBUtility.ClsPub.CurUserName) { MessageBox.Show("只能删除自己上传的附件！"); return; } DialogResult dr = MessageBox.Show("确定要删除此单据吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.Yes) { //if (!DBUtility.ClsPub.Security_Log("OA_Manager", 1, true, DBUtility.ClsPub.CurUserName)) //{ // return; //} //删除附件 BLL.ClsXt_FileCtrl oFile = new BLL.ClsXt_FileCtrl(); SQLHelper.ClsCNK3 oCNK3 = new SQLHelper.ClsCNK3(); if (oFile.DeleteFile(DBUtility.ClsPub.isLong(grdFJ.Rows[grdFJ.CurrentRow.Index].Cells[HItemIDCol].Value), ref DBUtility.ClsPub.sExeReturnInfo, oCNK3) == false) { MessageBox.Show("删除文件时失败!"); } // grdFJ.Rows.RemoveAt(grdFJ.CurrentRow.Index); } else { } } private void splitContainer4_SplitterMoved(object sender, SplitterEventArgs e) { } private void grdMain_DoubleClick(object sender, EventArgs e) { frmUserset ofrmUserset = new frmUserset(); string sName = ""; if (grdMain.CurrentRow == null) return; sName = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("发送人")].Value); if (sName == "") return; ofrmUserset.UserName = sName; ofrmUserset.cmdOK.Enabled = false; timer1.Enabled = false; ofrmUserset.ShowDialog(); timer1.Enabled = true; } private Int32 Fun_GetCol(string sCol) { return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain); } private void grdMain_Scroll(object sender, ScrollEventArgs e) { grdMain.RowsDefaultCellStyle.WrapMode = DataGridViewTriState.True; } } }