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 frmWorkBill : Form
|
{
|
public frmWorkBill()
|
{
|
InitializeComponent();
|
}
|
public const int HFileNameCol = 0;//huan
|
public const int HFilePathCol = 1;
|
public const int HUpManCol = 2;
|
string BillType = "9005";
|
public const int MainType = 2;
|
private void cmdSelectEmps_Click(object sender, EventArgs e)
|
{
|
DBUtility.Gy_UserSelect oUser = new DBUtility.Gy_UserSelect();
|
oUser.bSingle = true;
|
oUser.ShowDialog();
|
if (oUser.IsOk == 1)
|
{
|
txtrOperator.Text = oUser.sReturn;
|
}
|
else
|
{
|
txtrOperator.Text = "";
|
}
|
}
|
|
private void cmdCheckFlow_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void cmdSelectEmps2_Click(object sender, EventArgs e)
|
{
|
DBUtility.Gy_UserSelect oUser = new DBUtility.Gy_UserSelect();
|
oUser.bSingle = false;
|
oUser.ShowDialog();
|
if (oUser.IsOk == 1)
|
{
|
txtRoperator2.Text = oUser.sReturn;
|
}
|
else
|
{
|
txtRoperator2.Text = "";
|
}
|
}
|
|
private void cmdAdd_Click(object sender, EventArgs e)//huan
|
{
|
OpenFileDialog oDlg = new OpenFileDialog();
|
oDlg.Filter = "所有文件|*.*";
|
if (oDlg.ShowDialog() == DialogResult.OK)
|
{
|
if (oDlg.FileName != "")
|
{
|
grdMain.Rows.Add();
|
grdMain.Rows[grdMain.Rows.Count - 1].Cells[HFileNameCol].Value = oDlg.SafeFileName;
|
grdMain.Rows[grdMain.Rows.Count - 1].Cells[HFilePathCol].Value = oDlg.FileName;
|
grdMain.Rows[grdMain.Rows.Count - 1].Cells[HUpManCol].Value = DBUtility.ClsPub.CurUserName;
|
}
|
}
|
}
|
|
private void cmdSend_Click(object sender, EventArgs e)
|
{
|
//DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);//huan
|
if (txtContext.Text == "")
|
{
|
MessageBox.Show("请录入主题");
|
return;
|
}
|
if (txtrOperator.Text == "")
|
{
|
if (MessageBox.Show("接受人尽量不要为空？是否确认要使用空接受人？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
|
{
|
return;
|
}
|
}
|
if (Add())
|
{
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
this.Close();
|
}
|
}
|
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); //huan
|
this.Close();
|
}
|
private bool Add()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
long MainID;
|
MainID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
|
string Context = txtContext.Text.Replace("'", "‘");
|
string Desc = txtDesc.Text.Replace("'", "‘");
|
if (rdbGG.Checked == true)
|
{
|
oCn.RunProc("Insert into oa_workbillmain(id,operator,context,description" +
|
",opdate,roperator,ispublic,roperator2,fdate,HBillType" +
|
",HBillNo,HCommDate,HLevel,HEvaluateStatus,HRemark,hcheckflowmainid,HBillStatus) " +
|
" values (" +
|
MainID + ",'" + DBUtility.ClsPub.CurUserName + "','" + Context + "'" +
|
",'" + Desc + "',getdate(),'" + txtrOperator.Text + "',1,'" + txtRoperator2.Text + "',getdate(),4501" +
|
",'" + txtHBillNo.Text + "','" + DtpHCommDate.Value + "','" + cmbHLevel.Text + "','" + cmbHEvaluateStatus.Text + "','" + txtHRemark.Text + "',0,2)");
|
}
|
else
|
{
|
oCn.RunProc("Insert into oa_workbillmain(id,operator,context,description" +
|
",opdate,roperator,ispublic,roperator2,fdate,HBillType" +
|
",HBillNo,HCommDate,HLevel,HEvaluateStatus,HRemark,hcheckflowmainid,HBillStatus) " +
|
" values (" +
|
MainID + ",'" + DBUtility.ClsPub.CurUserName + "','" + Context + "'" +
|
",'" + Desc + "',getdate(),'" + txtrOperator.Text + "',0,'" + txtRoperator2.Text + "',getdate(),4501" +
|
",'" + txtHBillNo.Text + "','" + DtpHCommDate.Value + "','" + cmbHLevel.Text + "','" + cmbHEvaluateStatus.Text + "','" + txtHRemark.Text + "',0,2)");
|
}
|
oCn.RunProc("Insert into oa_workbillsub(id,mainid,operator,context,opdate)" +
|
" values (" +
|
"-1," + MainID + ",'" + DBUtility.ClsPub.CurUserName + "','" + Context + "',getdate())");
|
if (txtRoperator2.Text != "")
|
{
|
string[] s = txtRoperator2.Text.Split(',');
|
int len = s.Length;
|
for (int i = 0; i < len; i++)
|
{
|
int j = i + 2;
|
string k = s[i].ToString();
|
oCn.RunProc("insert into oa_workbillsub2 (MainID,SubID,ROperator,isRead,isKnow) " +
|
"values (" +
|
MainID + "," + j + ",'" + k + "',0,0)");
|
}
|
}
|
oCn.RunProc("insert into oa_workbillsub2 (MainID,SubID,ROperator,isRead,isKnow) " +
|
"values (" +
|
MainID + ",1,'" + txtrOperator.Text + "',0,0)");
|
//上传附件
|
BLL.ClsXt_FileCtrl oFile = new BLL.ClsXt_FileCtrl();
|
for (int i = 0; i <= grdMain.Rows.Count - 1; i++)
|
{
|
if (oFile.LoadUpFile(MainID, MainType, DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HFilePathCol].Value), 0,
|
DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HFileNameCol].Value), DBUtility.ClsPub.CurUserName) == false)
|
{
|
MessageBox.Show("上传文件时失败!");
|
}
|
}
|
//
|
return true;
|
}
|
|
private void frmWorkBill_Load(object sender, EventArgs e)
|
{
|
this.txtHBillNo.Text = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);//得到新单号
|
initGrid();//huan
|
}
|
|
public void initGrid()//huan
|
{
|
grdMain.ColumnCount = 3; //总列数
|
DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name);
|
grdMain.ReadOnly = true;
|
grdMain.RowCount = 0;
|
//=
|
grdMain.Columns[HFileNameCol].HeaderText = "文件名称";
|
grdMain.Columns[HFilePathCol].HeaderText = "文件路径";
|
grdMain.Columns[HUpManCol].HeaderText = "上传人";
|
DBUtility.ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
}
|
|
private void cmdDel_Click(object sender, EventArgs e) //huan
|
{
|
if (grdMain.CurrentRow == null)
|
{
|
return;
|
}
|
grdMain.Rows.RemoveAt(grdMain.CurrentRow.Index);
|
}
|
}
|
}
|
