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 frmLTList : Form
|
{
|
public frmLTList()
|
{
|
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 frmLTList_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)
|
{
|
frmLTView ofrmLTView = new frmLTView();
|
Int64 lngBillKey = 0;
|
if (grdmain.CurrentRow == null)
|
return;
|
lngBillKey = DBUtility.ClsPub.isLong(grdmain.Rows[grdmain.CurrentRow.Index].Cells[Fun_GetCol("hid")].Value);
|
if (lngBillKey == 0)
|
return;
|
ofrmLTView.ID = lngBillKey;
|
ofrmLTView.Show();
|
ofrmLTView.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 hid,operator 楼主,context 主题,description 详细描述,opdate 发表日期 from oa_ltmain ";
|
Ds = oCn.RunProcReturn(sSQL, "oa_ltmain", 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 OpGG1_CheckedChanged(object sender, EventArgs e)
|
{
|
timer1.Enabled = true;
|
}
|
|
private void OpGG2_CheckedChanged(object sender, EventArgs e)
|
{
|
timer1.Enabled = true;
|
}
|
|
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);
|
}
|
|
}
|
}
|
