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 frmFK : Form
|
{
|
public frmFK()
|
{
|
InitializeComponent();
|
}
|
|
public const int HFileNameCol = 0;//huan
|
public const int HFilePathCol = 1;
|
public const int HUpManCol = 2;
|
string BillType = "9004";
|
|
public const int MainType = 1;
|
|
private void cmdHReceiveMan_Click(object sender, EventArgs e)
|
{
|
DBUtility.Gy_UserSelect oUser = new DBUtility.Gy_UserSelect();
|
oUser.bSingle = true;
|
oUser.ShowDialog();
|
if (oUser.IsOk == 1)
|
{
|
txtHReceiveMan.Text = oUser.sReturn;
|
}
|
else
|
{
|
txtHReceiveMan.Text = "";
|
}
|
}
|
|
private void cmdHCopyMan_Click(object sender, EventArgs e)
|
{
|
DBUtility.Gy_UserSelect oUser = new DBUtility.Gy_UserSelect();
|
oUser.bSingle = false;
|
oUser.ShowDialog();
|
if (oUser.IsOk == 1)
|
{
|
txtHCopyMan.Text = oUser.sReturn;
|
}
|
else
|
{
|
txtHCopyMan.Text = "";
|
}
|
}
|
|
private void cmdHErrTypeID_Click(object sender, EventArgs e)
|
{
|
DAL.ClsGy_ErrType_View oET = new DAL.ClsGy_ErrType_View();
|
if (oET.RefreshView())
|
{
|
this.txtHErrTypeID.Text = oET.oModel.HName;
|
this.txtHErrTypeID.Tag = oET.oModel.HItemID.ToString();
|
}
|
else
|
{
|
this.txtHErrTypeID.Text = "";
|
}
|
}
|
|
private void cmdAdd_Click(object sender, EventArgs e)//huanxin
|
{
|
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)
|
{
|
if (txtHContext.Text == "")
|
{
|
MessageBox.Show("请录入主题");
|
return;
|
}
|
if (txtHReceiveMan.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 bool Add()
|
{
|
string sDate;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
long MainID;
|
MainID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
|
sDate = DateTime.Now.ToString();
|
string Context = txtHContext.Text.Replace("'", "‘");
|
string Desc = txtDesc.Text.Replace("'", "‘");
|
string PlanNo = txtHPlanNo.Text.Replace("'", "‘");
|
string ItemModel = txtHItemModel.Text.Replace("'", "‘");
|
long HErrTypeID =DBUtility.ClsPub.isLong( txtHErrTypeID.Tag);
|
// SaveFile MainID 保存文件
|
if (rdbGG.Checked == true)
|
{
|
oCn.RunProc("Insert into oa_fkmain(isRead,id,HErrTypeID,operator,context" +
|
",description,opdate,PlanNo,ItemNumber" +
|
",ItemModel,roperator,ispublic,Fdate,roperator2) " +
|
" values (" +
|
" 0," + MainID + "," + HErrTypeID + ",'" + DBUtility.ClsPub.CurUserName + "','" + Context + "'" +
|
",'" + Desc + "','" + sDate + "','" + PlanNo + "','" + txtHItemNumber.Text + "'" +
|
",'" + ItemModel + "','" + txtHReceiveMan.Text + "',1,'" + dtpHDate.Value + "','" + txtHCopyMan.Text + "')");
|
}
|
else
|
{
|
oCn.RunProc("Insert into oa_fkmain(isRead,id,HErrTypeID,operator,context" +
|
",description,opdate,PlanNo,ItemNumber" +
|
",ItemModel,roperator,ispublic,Fdate,roperator2) " +
|
" values (" +
|
" 0," + MainID + "," + HErrTypeID + ",'" + DBUtility.ClsPub.CurUserName + "','" + Context + "'" +
|
",'" + Desc + "','" + sDate + "','" + PlanNo + "','" + txtHItemNumber.Text + "'" +
|
",'" + ItemModel + "','" + txtHReceiveMan.Text + "',0,'" + dtpHDate.Value + "','" + txtHCopyMan.Text + "')");
|
}
|
oCn.RunProc("Insert into oa_fksub(id,mainid,operator,context,opdate) "+
|
" values ("+
|
"-1," + MainID + ",'" + DBUtility.ClsPub.CurUserName + "','" + Context + "','" + sDate+"')");
|
if(txtHCopyMan.Text!="")
|
{
|
string[] s = txtHCopyMan.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_fksub2 (MainID,SubID,ROperator,isRead,isKnow) "+
|
"values ("+
|
MainID+"," + j + ",'"+ k +"',0,0)");
|
}
|
}
|
oCn.RunProc("insert into oa_fksub2 (MainID,SubID,ROperator,isRead,isKnow) " +
|
"values (" +
|
MainID + ",1,'" + txtHReceiveMan.Text + "',0,0)");
|
//上传附件 huanxin
|
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;
|
}
|
|
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 frmFK_Load(object sender, EventArgs e)
|
{
|
initGrid();//huan
|
}
|
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); //huan
|
this.Close();
|
}
|
|
private void cmdDel_Click(object sender, EventArgs e) //huan
|
{
|
if (grdMain.CurrentRow == null)
|
{
|
return;
|
}
|
grdMain.Rows.RemoveAt(grdMain.CurrentRow.Index);
|
}
|
|
private void txtHErrTypeID_TextChanged(object sender, EventArgs e)
|
{
|
if (txtHErrTypeID.Text.Trim() == "")
|
{
|
txtHErrTypeID.Tag = "0";
|
}
|
}
|
|
private void txtHCopyMan_TextChanged(object sender, EventArgs e)
|
{
|
if (txtHCopyMan.Text.Trim() == "")
|
{
|
txtHCopyMan.Tag = "0";
|
}
|
}
|
|
private void txtHReceiveMan_TextChanged(object sender, EventArgs e)
|
{
|
if (txtHReceiveMan.Text.Trim() == "")
|
{
|
txtHReceiveMan.Tag = "0";
|
}
|
}
|
|
|
|
|
}
|
}
|
