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 frmGGList3 : Form
|
{
|
public frmGGList3()
|
{
|
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()
|
{
|
|
|
}
|
|
private void sx_Click(object sender, EventArgs e)
|
{
|
Refresh1();
|
}
|
|
private void frmGGList3_Load(object sender, EventArgs e)
|
{
|
InitUI();
|
Refresh1();
|
}
|
|
private void xz_Click(object sender, EventArgs e)
|
{
|
frm_MeetingBill ofrm_MeetingBill = new frm_MeetingBill();
|
ofrm_MeetingBill.HInterID = 0;
|
ofrm_MeetingBill.ShowDialog();
|
Refresh1();
|
}
|
|
private void dj_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void sc_Click(object sender, EventArgs e)
|
{
|
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();
|
}
|
|
}
|
|
private void yl_Click(object sender, EventArgs e)
|
{
|
frm_MeetingItem ofrm_MeetingItem = new frm_MeetingItem();
|
ofrm_MeetingItem.ShowDialog();
|
}
|
|
private void dy_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void grdMain_DoubleClick(object sender, EventArgs e)
|
{
|
frmGGView3 oGG = new frmGGView3();
|
Int64 lngBillKey = 0;
|
if (grdMain.CurrentRow == null)
|
return;
|
lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("id")].Value);
|
if (lngBillKey == 0)
|
return;
|
oGG.ID = lngBillKey;
|
oGG.Show();
|
oGG.Display();
|
}
|
|
private Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
|
}
|
private void LoadData()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Ds;
|
string sSQL;
|
sSQL = " select id,isview,operator 用户,tm as 主题,opdate 发布日期,Description 参会人员 from oa_gg3 order by opdate desc";
|
Ds = oCn.RunProcReturn(sSQL, "oa_gg3", ref DBUtility.ClsPub.sExeReturnInfo);
|
|
if (Ds == null)
|
{
|
MessageBox.Show("显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
grdMain.DataSource = Ds.Tables[0].DefaultView;
|
DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, "", 0);
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
LoadData();
|
}
|
|
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);
|
}
|
|
|
}
|
}
|
