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 frmGGView1 : Form
|
{
|
public frmGGView1()
|
{
|
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 = "4508"; //µ¥¾ÝÀàÐÍ
|
public const string ModCaption = "»áÒé֪ͨ"; //µ¥¾ÝÃû³Æ
|
public const string ModRightName = "frmGGView1";
|
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 frmGGView1_Load(object sender, EventArgs e)
|
{
|
initGridFJ();
|
dtpDate.Value = DateTime.Today;
|
dtpHEDate.Value = DateTime.Today;
|
dtpsdate.Value = DateTime.Today;
|
this.Text = ModCaption; //ÃüÃû´°Ìå±êÌâ
|
this.lblCaption.Text = ModCaption;//ÃüÃûµ¥¾Ý±êÌâ
|
DBUtility.ClsPub.GetGridView(grdFJ, this.Name, 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 Command1_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;
|
}
|
oCn.RunProc("delete from oa_gg1sub where Mainid=" + ID);
|
oCn.RunProc("delete from oa_gg1 where id=" + ID);
|
MessageBox.Show("ɾ³ý³É¹¦£¡");
|
|
DBUtility.ClsPub.SaveGridView(grdFJ, this.Name, DBUtility.ClsPub.AppPath);
|
this.Close();
|
}
|
else
|
{
|
}
|
}
|
else
|
{
|
|
MessageBox.Show("¶Ô²»Æð!Ö»Óз¢ËÍÈ˲ÅÄÜɾ³ý£¡");
|
}
|
|
|
}
|
|
//Ìí¼Ó°´Å¥
|
private void cmdAdd_Click_1(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_1(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 frmGGView1_FormClosing(object sender, FormClosingEventArgs e)
|
{
|
BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
}
|
|
|
#endregion
|
|
|
#region ¶ÁдÀà
|
//ÏÔʾµ¥¾Ý
|
public void Sub_ShowBill()
|
{
|
|
|
}
|
|
#endregion
|
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
DBUtility.ClsPub.SaveGridView(grdFJ, this.Name, DBUtility.ClsPub.AppPath);
|
this.Close();
|
}
|
|
|
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 timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
Display();
|
}
|
|
public void Display()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Ds;
|
DataSet Ds2;
|
Ds = oCn.RunProcReturn("Select * from oa_gg1 where id=" + ID, "oa_gg1", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("ÏÔʾʧ°Ü£¡ÔÒò£º" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
txtManager.Text = Ds.Tables[0].Rows[0]["manager"].ToString();
|
dtpDate.Text = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["workdate"].ToString()).ToShortDateString();
|
dtpTime.Text = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["workdate"].ToString()).ToShortTimeString();
|
dtpHEDate.Text = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["hedate"].ToString()).ToShortDateString();
|
dtpHETime.Text = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["hedate"].ToString()).ToShortTimeString();
|
dtpsdate.Text = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["sDate"].ToString()).ToShortDateString();
|
dtpsTime.Text = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["sDate"].ToString()).ToShortTimeString();
|
|
txtContext.Text = Ds.Tables[0].Rows[0]["context"].ToString();
|
txtAddr.Text = Ds.Tables[0].Rows[0]["addr"].ToString();
|
txtHNoteMan.Text = Ds.Tables[0].Rows[0]["hnoteman"].ToString();
|
txtHSummary.Text = Ds.Tables[0].Rows[0]["HSummary"].ToString();
|
txtRemark.Text = Ds.Tables[0].Rows[0]["remark"].ToString();
|
txtOperator.Text = Ds.Tables[0].Rows[0]["operator"].ToString();
|
txtDesc.Text = Ds.Tables[0].Rows[0]["Description"].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());
|
|
|
oCn.RunProc("update oa_gg1sub set isread=1 where mainid=" + MainID + " and roperator='" + DBUtility.ClsPub.CurUserName + "'");
|
Ds2 = oCn.RunProcReturn("select * from oa_ReadNum where sbill='oa_gg1' 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_gg1','" + DBUtility.ClsPub.CurUserName + "') ");
|
}
|
lblNum.Text = GetReadNum(MainID, "oa_gg1").ToString();
|
txtEmp.Text = GetReadEmp(MainID, "oa_gg1");
|
//¸½¼þ huan
|
DisplayFJ();
|
//DBUtility.ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
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 cmdSave_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
oCn.RunProc("update oa_gg1 set operator='" + txtOperator.Text+"'"+
|
",context='" + txtContext.Text + "'" +
|
",HSummary='" + txtHSummary.Text + "'" +
|
",addr='" + txtAddr.Text + "'" +
|
",Description='" + txtDesc.Text + "'" +
|
",remark='" + txtRemark.Text + "'" +
|
",makedate=getdate()" +
|
",workdate='" + dtpDate.Text + " " + dtpTime.Text + "'" +
|
" where id=" + ID);
|
MessageBox.Show("±£´æ³É¹¦");
|
DBUtility.ClsPub.SaveGridView(grdFJ, this.Name, DBUtility.ClsPub.AppPath);
|
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));
|
|
}
|
}
|
}
|
