using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using BaseSet;
|
using System.Windows.Forms;
|
|
namespace OAM
|
{
|
public partial class frm_MeetingBilllist : Form
|
{
|
public frm_MeetingBill ofrm_MeetingBill = new frm_MeetingBill();
|
TreeNode CurNode = new TreeNode();
|
//ÏÔʾÁбí
|
private void Display() // »ÃÐÄ
|
{
|
SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
|
DataSet DSet;
|
string sSql = "";
|
string sWhere = "";
|
//sSql = "Select * from h_v_EmployeeConList order by ͨѶ¼´úÂë";
|
string oHInterID = CurNode.Name.Replace("T", "");
|
if (oHInterID == "")
|
{
|
oHInterID = "hmainid";
|
}
|
if (CurNode.Text == "»áÒé¼ÍÒª")
|
{
|
sSql = "Select * from h_v_Oa_MeetingbillList where 1=1 order by ÏîÄ¿´úÂë";
|
DSet = SubCn.RunProcReturn(sSql, "h_v_Oa_MeetingbillList", ref DBUtility.ClsPub.sExeReturnInfo);
|
//
|
if (DSet == null)
|
{
|
MessageBox.Show("ÏÔʾʧ°Ü£¡ÔÒò£º" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
DBUtility.Gy_BaseFun.DisplayGrid(grdMain, this.Name);
|
return;
|
}
|
sSql = "Select * from h_v_Oa_MeetingbillList where hmainid=" + oHInterID + " order by ÏîÄ¿´úÂë";
|
|
//Ö´ÐÐSQL
|
DSet = SubCn.RunProcReturn(sSql, "h_v_Oa_MeetingbillList", ref DBUtility.ClsPub.sExeReturnInfo);
|
//
|
if (DSet == null)
|
{
|
MessageBox.Show("ÏÔʾʧ°Ü£¡ÔÒò£º" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
DBUtility.Gy_BaseFun.DisplayGrid(grdMain, this.Name);
|
//
|
|
|
}
|
private void cmdLoadTree_Click(object sender, EventArgs e)
|
{
|
Display();
|
//Gy_Department_Load(sender, e);
|
//LoadTree(TreeView, imageList1, this.Text);
|
}
|
public frm_MeetingBilllist()
|
{
|
InitializeComponent();
|
}
|
|
private void InitUI()
|
{
|
DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
|
}
|
|
public string ViewName = "";
|
|
|
private void cmdQuery_Click(object sender, EventArgs e)
|
{
|
Refresh1();
|
}
|
|
private void Refresh1()
|
{
|
|
|
|
SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
|
DataSet DSet;
|
string sSql = "";
|
string sWhere = "";
|
sSql = "Select * from h_v_Oa_MeetingbillList where ¹æ¸ñÐͺŠlike '%" + txtHModel.Text + "%' ";
|
|
//Ö´ÐÐSQL
|
DSet = SubCn.RunProcReturn(sSql, "h_v_Oa_MeetingbillList", ref DBUtility.ClsPub.sExeReturnInfo);
|
//
|
if (DSet == null)
|
{
|
MessageBox.Show("ÏÔʾʧ°Ü£¡ÔÒò£º" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
DBUtility.Gy_BaseFun.DisplayGrid(grdMain, this.Name);
|
|
|
}
|
|
private void sx_Click(object sender, EventArgs e)
|
{
|
Refresh1();
|
|
Display();
|
}
|
|
private void frm_MeetingBilllist_Load(object sender, EventArgs e)
|
{
|
dtpHDate.Value = DateTime.Today.AddDays(-20);
|
dtpHEDate.Value = DateTime.Today;
|
InitUI();
|
Refresh1();
|
}
|
|
private void xz_Click(object sender, EventArgs e)
|
{
|
frm_MeetingBill ofrm_MeetingBill = new frm_MeetingBill();
|
ofrm_MeetingBill.HInterID = 0;
|
ofrm_MeetingBill.zt = true;
|
ofrm_MeetingBill.ShowDialog();
|
Refresh1();
|
Display();
|
}
|
|
private void dj_Click(object sender, EventArgs e)
|
{
|
if (grdMain.CurrentRow == null)
|
{
|
MessageBox.Show("ûÓÐÑ¡ÔñÏîÄ¿£¡");
|
return;
|
}
|
int col = Fun_GetCol("FitemID");
|
|
ofrm_MeetingBill.id = grdMain.Rows[grdMain.CurrentRow.Index].Cells[col].Value.ToString();
|
|
Int64 sInterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells["hmainid"].Value);
|
|
ofrm_MeetingBill.HInterID = sInterID;
|
ofrm_MeetingBill.zt = false;
|
ofrm_MeetingBill.ShowDialog();
|
Refresh1();
|
Display();
|
}
|
|
private void sc_Click(object sender, EventArgs e)
|
{
|
if (!DBUtility.ClsPub.Security_Log("OA_Manager", 1, true, DBUtility.ClsPub.CurUserName))
|
{
|
return;
|
}
|
if (grdMain.CurrentRow == null)
|
{
|
MessageBox.Show("ûÓÐÑ¡ÔñÏîÄ¿£¡");
|
return;
|
}
|
SQLHelper.ClsCN oCn=new SQLHelper.ClsCN();
|
Int64 sInterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells["hmainid"].Value);
|
if (MessageBox.Show("È·¶¨ÒªÉ¾³ýµ±Ç°µ¥¾Ý£¿", "Ìáʾ", MessageBoxButtons.OKCancel) == DialogResult.OK)
|
{
|
oCn.RunProc(" Delete from OA_MeetingBill where HInterID=" + sInterID.ToString());
|
Refresh1();
|
Display();
|
}
|
|
}
|
|
private void yl_Click(object sender, EventArgs e)
|
{
|
frm_MeetingItemList ofrm_MeetingItemList = new frm_MeetingItemList();
|
ofrm_MeetingItemList.Show();
|
|
//frm_MeetingItem ofrm_MeetingItem = new frm_MeetingItem();
|
//ofrm_MeetingItem.ShowDialog();
|
}
|
|
private void dy_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
try
|
{
|
//MessageBox.Show("ûÓÐÕÒµ½·´À¡ÏîÄ¿£¡");
|
//´ÓÒì³£·´À¡µ¼Èë½ñÈÕÊý¾Ý
|
Int64 HMeetID;
|
DataSet ds = oCn.RunProcReturn("select * from oa_meetingitem where hnumber='001' ", "oa_meetingitem");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("ûÓÐ[001]·´À¡ÏîÄ¿£¡");
|
return;
|
}
|
|
HMeetID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HItemID"]);
|
oCn.BeginTran();
|
oCn.RunProc("delete from oa_meetingbill where HMeetID=" + HMeetID.ToString() + " and isnull(hchecker,'')='' and HType='1' and HDate=convert(varchar(10),getdate(),120) ");//ɾ³ý¸ÃÏîÄ¿µÄδÑéÖ¤µ±ÈÕ¼ÍÒª
|
oCn.RunProc("exec h_p_OA_FKInfoToMeeting " + HMeetID.ToString() + ",'" + DBUtility.ClsPub.CurUserName + "'");
|
oCn.Commit();
|
MessageBox.Show("µ¼Èë³É¹¦£¡");
|
|
}
|
catch (Exception e1)
|
{
|
oCn.RollBack();
|
MessageBox.Show("µ¼Èëʧ°Ü£¡" + e1.Message);
|
}
|
|
}
|
private Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
|
}
|
private void grdMain_DoubleClick(object sender, EventArgs e)
|
{
|
if (grdMain.CurrentRow == null)
|
{
|
MessageBox.Show("ûÓÐÑ¡ÔñÏîÄ¿£¡");
|
return;
|
}
|
else
|
{
|
int col = Fun_GetCol("FitemID");
|
|
ofrm_MeetingBill.id = grdMain.Rows[grdMain.CurrentRow.Index].Cells[col].Value.ToString();
|
Int64 sInterID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells["hmainid"].Value);
|
ofrm_MeetingBill.HInterID = sInterID;
|
ofrm_MeetingBill.zt = false;
|
ofrm_MeetingBill.ShowDialog();
|
Refresh1();
|
Display();
|
}
|
|
}
|
|
private void sh_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
if (grdMain.CurrentRow == null)
|
{
|
return;
|
}
|
else
|
{
|
int HCheckercol = Fun_GetCol("HChecker");
|
string HChecker1 = grdMain.Rows[grdMain.CurrentRow.Index].Cells[HCheckercol].Value.ToString();
|
if (HChecker1 == "")
|
{
|
int col = Fun_GetCol("HInterID");
|
|
string id = grdMain.Rows[grdMain.CurrentRow.Index].Cells[col].Value.ToString();
|
oCn.RunProc("Update Oa_Meetingbill set " +
|
"HChecker= '" + Pub_Class.ClsPub.CurUserName + "'" +
|
",HCheckDate='" + DateTime.Now.ToString() + "'Where HInterID = " + id + "", ref DBUtility.ClsPub.sExeReturnInfo);
|
MessageBox.Show("ÒÑÑéÖ¤£¡");
|
Display();
|
}
|
else
|
{
|
MessageBox.Show("´Ëµ¥¾ÝÒÑÑéÖ¤¹ý£¡");
|
}
|
}
|
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void dc_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void qsh_Click(object sender, EventArgs e)
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
if (grdMain.CurrentRow == null)
|
{
|
return;
|
}
|
else
|
{
|
|
int HCheckercol = Fun_GetCol("HChecker");
|
string HChecker1 = grdMain.Rows[grdMain.CurrentRow.Index].Cells[HCheckercol].Value.ToString();
|
if (HChecker1 == "")
|
{
|
MessageBox.Show("´Ëµ¥¾ÝδÑéÖ¤¹ý£¡");
|
}
|
else
|
{
|
int col = Fun_GetCol("HInterID");
|
|
string id = grdMain.Rows[grdMain.CurrentRow.Index].Cells[col].Value.ToString();
|
oCn.RunProc("Update Oa_Meetingbill set " +
|
"HChecker= ''" +
|
",HCheckDate=null Where HInterID = " + id + "", ref DBUtility.ClsPub.sExeReturnInfo);
|
MessageBox.Show("Òѻָ´£¡");
|
Display();
|
}
|
}
|
}
|
|
private void set_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
|
timer1.Enabled = false;
|
Display();
|
}
|
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
}
|
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
|
}
|
|
}
|
}
|
