using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using Pub_Class; namespace OAM { public partial class frmGGView2 : Form { public frmGGView2() { InitializeComponent(); } public const int HFileNameCol = 0;//huan public const int HFilePathCol = 1; public const int HUpManCol = 2; public const int HItemIDCol = 3; public long ID; public long MainID; public const string ModName = "4507"; //单据类型 public const string ModCaption = "行政公告"; //单据名称 public const string ModRightName = "frmGGView2"; public const string ModRightNameEdit = ModRightName + "_Edit"; public const string ModRightNameCheck = ModRightName + "_Check"; public const string ModRightNameClose = ModRightName + "_Close"; public const string ModRightNameDelete = ModRightName + "_Delete"; public bool BillChange; //单据修改状态 // public DBUtility.ClsPub.Enum_BillStatus BillStatus; //单据状态（新增，修改，浏览，更新单价，变更） public Int64 KeyID; //单据主内码 public bool grdStatus; //网格状态（不可编辑，可编辑） //------------------------------------------------------------------------- #region 固定代码 //窗体加载 private void frmGGView2_Load(object sender, EventArgs e) { initGridFJ(); this.Text = ModCaption; //命名窗体标题 this.lblCaption.Text = ModCaption;//命名单据标题 } //主界面删除按钮 private void Command1_Click(object sender, EventArgs e) { 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_gg2sub where Mainid=" + ID); oCn.RunProc("delete from oa_gg2 where id=" + ID); MessageBox.Show("删除成功！"); this.Close(); } else { } } //添加按钮 private void cmdAdd_Click(object sender, EventArgs e) { 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, 1, 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 cmdDel_Click(object sender, EventArgs e) { 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 frmGGView2_FormClosing(object sender, FormClosingEventArgs e) { BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew; } #endregion #region 读写类 //显示单据 public void Sub_ShowBill() { } #endregion public void Display() { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds; DataSet Ds2; Ds = oCn.RunProcReturn("Select * from oa_gg2 where id=" + ID, "oa_gg2", ref DBUtility.ClsPub.sExeReturnInfo); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { MessageBox.Show("显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo); return; } txtZ.Text = Ds.Tables[0].Rows[0]["z"].ToString(); txth2.Text = Ds.Tables[0].Rows[0]["h2"].ToString(); txtH.Text = Ds.Tables[0].Rows[0]["h"].ToString(); txtDesc.Text = Ds.Tables[0].Rows[0]["Description"].ToString(); txtTM.Text = Ds.Tables[0].Rows[0]["tm"].ToString(); txtEmp.Text = Ds.Tables[0].Rows[0]["emp"].ToString(); if (Ds.Tables[0].Rows[0]["maker"].ToString() == DBUtility.ClsPub.CurUserName) { cmdSave.Visible = true; } else { cmdSave.Visible = false; } MainID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["MainID"].ToString()); if (MainID != 0) { oCn.RunProc("update oa_gg2sub set isread=1 where mainid=" + MainID + " and roperator='" + DBUtility.ClsPub.CurUserName + "'"); Ds2 = oCn.RunProcReturn("select * from oa_ReadNum where sbill='oa_gg2' and MainID=" + MainID + " and roperator='" + DBUtility.ClsPub.CurUserName + "'", "oa_ReadNum"); if (Ds!=null&& Ds2.Tables[0].Rows.Count == 0) { oCn.RunProc("insert into oa_ReadNum (MainID,sBill,rOPerator) values (" + MainID + ",'oa_gg2','" + DBUtility.ClsPub.CurUserName + "') "); } } //lblNum.Text = GetReadNum(MainID, "oa_gg2").ToString(); txtEmp.Text = GetReadEmp(MainID, "oa_gg2"); //附件 huan DisplayFJ(); //DBUtility.ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); DBUtility.ClsPub.GetGridView(grdFJ, this.Name + "grdFJ", DBUtility.ClsPub.AppPath); // } private void initGridFJ()//huan { 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 string GetReadEmp(long MID, string sBill) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds; string GetReadEmp=""; Ds = oCn.RunProcReturn("select roperator from oa_readnum where MainID=" + MID + " and sBill='" + sBill + "'", "oa_readnum"); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { GetReadEmp = ""; } else { for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) { GetReadEmp = GetReadEmp + DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i][0]) + ","; } } if (GetReadEmp != "") { GetReadEmp = GetReadEmp.Remove(GetReadEmp.Length - 1, 1); } return GetReadEmp; } private long GetReadNum(long MID, string sBill) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds; long GetReadNum=0; Ds = oCn.RunProcReturn("select count(*)as Num from oa_readnum where MainID=" + MID + " and sBill='" + sBill + "'", "oa_readnum"); if (Ds == null || Ds.Tables[0].Rows.Count == 0) { GetReadNum = 0; } else { GetReadNum = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]); } return GetReadNum; } private void cmdSave_Click(object sender, EventArgs e) { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); oCn.RunProc("update oa_gg2 set z='" + txtZ.Text + "'" + ",h2='" + txth2.Text + "'" + ",h='" + txtH.Text + "'" + ",Description='" + txtDesc.Text + "'" + ",tm='" + txtTM.Text + "'" + ",makedate=getdate()" + " where id=" + ID); MessageBox.Show("保存成功"); this.Close(); } private void timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; Display(); } private void cmdCancel_Click(object sender, EventArgs e) { this.Close(); } private void grdFJ_DoubleClick(object sender, EventArgs e) { 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)); } } }