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 frmLTView : Form
|
{
|
public frmLTView()
|
{
|
InitializeComponent();
|
}
|
public long ID;
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
timer1.Interval = 60000;
|
Display();
|
}
|
|
private void button1_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_ltsub where Mainid=" + ID);
|
oCn.RunProc("delete from oa_ltmain where id=" + ID);
|
MessageBox.Show("删除成功！");
|
this.Close();
|
}
|
else
|
{
|
}
|
}
|
else
|
{
|
|
MessageBox.Show("对不起!只有发帖人才能删除！");
|
}
|
|
|
}
|
public void Display()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
DataSet Ds;
|
DataSet Ds2;
|
Ds = oCn.RunProcReturn("Select * from oa_ltmain where id=" + ID, "oa_ltmain", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (Ds == null)
|
{
|
MessageBox.Show("显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
txtContext.Text = Ds.Tables[0].Rows[0]["context"].ToString();
|
txtDesc.Text = Ds.Tables[0].Rows[0]["Description"].ToString();
|
txtoperator.Text = Ds.Tables[0].Rows[0]["operator"].ToString();
|
txtFDate.Text = Ds.Tables[0].Rows[0]["opdate"].ToString();
|
Ds2 = oCn.RunProcReturn("select case when row_number()OVER(ORDER BY id,lev )%2=1 then '楼层' else '用户' end HType,case when row_number()OVER(ORDER BY id,lev )%2=1 then " +
|
" case when row_number()OVER(ORDER BY id,lev )=1 then '1楼(沙发)'"+
|
" else case when row_number()OVER(ORDER BY id,lev )=3 then '2楼(板凳)'"+
|
" else case when row_number()OVER(ORDER BY id,lev )=5 then '3楼(地板)'"+
|
" else convert(varchar(50), row_number()OVER(ORDER BY id,lev )/2+1)+'楼' end end end"+
|
" else operator end 用户,opdate from("+
|
" Select 1 lev,id,'' operator,convert(varchar(100),opdate,20) opdate from oa_ltsub where mainid="+ID+" and id>=0"+
|
" union all"+
|
" Select 2,id,operator,context from oa_ltsub where mainid="+ID+" and id>=0)as a "+
|
" order by id,lev", "oa_ltsub", ref DBUtility.ClsPub.sExeReturnInfo);
|
if (Ds2 == null)
|
{
|
MessageBox.Show("显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
grdMain.DataSource = Ds2.Tables[0].DefaultView;
|
grdMain.ColumnHeadersVisible = false;
|
grdMain.Columns[0].Visible = false;
|
//grdMain.Columns[0].Width = 100;
|
//grdMain.Columns[1].Width = 1000;
|
DBUtility.ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
}
|
|
private void cmdSend_Click(object sender, EventArgs e)
|
{
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
if (txtContext_New.Text == "")
|
{
|
MessageBox.Show("请填写回复内容！");
|
}
|
string Context = txtContext_New.Text.Replace("'", "‘");
|
int Rows = grdMain.Rows.Count + 1;
|
oCn.RunProc("Insert into oa_ltsub(mainid,id,context,operator,opdate) values(" + ID + "," + Rows + ",'" + Context + "','" + DBUtility.ClsPub.CurUserName + "',getdate())");
|
Display();
|
}
|
|
private void frmLTView_Load(object sender, EventArgs e)
|
{
|
|
//DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
|
}
|
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
this.Close();
|
}
|
|
private void grdMain_DoubleClick(object sender, EventArgs e)
|
{
|
frmUserset ofrmUserset = new frmUserset();
|
string sType = "";
|
string sName = "";
|
if (grdMain.CurrentRow == null)
|
return;
|
sType = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("HType")].Value);
|
if (sType == "楼层")
|
{
|
return;
|
}
|
sName = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("用户")].Value);
|
if (sName == "")
|
return;
|
ofrmUserset.UserName = sName;
|
ofrmUserset.cmdOK.Enabled = false;
|
timer1.Enabled = false;
|
ofrmUserset.ShowDialog();
|
timer1.Enabled = true;
|
}
|
private Int32 Fun_GetCol(string sCol)
|
{
|
return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdMain);
|
}
|
|
private void grdMain_Scroll(object sender, ScrollEventArgs e)
|
{
|
grdMain.RowsDefaultCellStyle.WrapMode = DataGridViewTriState.True;
|
}
|
}
|
}
|
