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 QMsgList : Form
|
{
|
public string fromoperator;
|
public string tooperator;
|
public QMsgList()
|
{
|
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 QMsgList_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 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,fromoperator 用户,opdate 时间,context 内容 from oa_msg where fromoperator='" + tooperator + "' and tooperator='" + fromoperator + "' or tooperator='" + tooperator + "' and fromoperator='" + fromoperator + "' order by 时间 desc ";
|
//Select id hid,fromoperator 用户,opdate 时间,context 内容 from oa_msg where fromoperator='内销部经理' or fromoperator= '景焕章' and tooperator='景焕章' or tooperator='内销部经理'
|
Ds = oCn.RunProcReturn(sSQL, "oa_msg", 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);
|
}
|
|
}
|
}
|
