using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using Pub_Class;
|
|
namespace OAM
|
{
|
public partial class frmGG2 : Form
|
{
|
public frmGG2()
|
{
|
InitializeComponent();
|
}
|
|
|
public const int HFileNameCol = 0;//huan
|
public const int HFilePathCol = 1;
|
public const int HUpManCol = 2;
|
|
public const int MainType = 6;
|
public const string ModName = "4507"; //单据类型
|
public const string ModCaption = "行政公告"; //单据名称
|
public const string ModRightName = "frmGG2";
|
public const string ModRightNameEdit = ModRightName + "_Edit";
|
public const string ModRightNameCheck = ModRightName + "_Check";
|
public const string ModRightNameClose = ModRightName + "_Close";
|
public const string ModRightNameDelete = ModRightName + "_Delete";
|
public bool BillChange; //单据修改状态
|
//
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus; //单据状态（新增，修改，浏览，更新单价，变更）
|
public Int64 KeyID; //单据主内码
|
public bool grdStatus; //网格状态（不可编辑，可编辑）
|
//-------------------------------------------------------------------------
|
|
|
#region 固定代码
|
|
//窗体加载
|
private void frmGG2_Load(object sender, EventArgs e)
|
{
|
initGrid();//huan
|
this.Text = ModCaption; //命名窗体标题
|
this.lblCaption.Text = ModCaption;//命名单据标题
|
DBUtility.ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
}
|
|
//新建按钮
|
private void cmdSend_Click(object sender, EventArgs e)
|
{
|
if (txtZ.Text == "")
|
{
|
MessageBox.Show("请录入‘字’");
|
}
|
if (txtH.Text == "")
|
{
|
MessageBox.Show("请录入‘号’");
|
}
|
if (txtTM.Text == "")
|
{
|
MessageBox.Show("请录入主题");
|
}
|
if (Sub_SaveBill())
|
{
|
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);
|
this.Close();
|
}
|
|
//添加按钮
|
private void cmdAdd_Click(object sender, EventArgs e)
|
{
|
|
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;
|
}
|
}
|
}
|
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)
|
{
|
if (grdMain.CurrentRow == null)
|
{
|
return;
|
}
|
grdMain.Rows.RemoveAt(grdMain.CurrentRow.Index);
|
}
|
|
|
//窗体卸载
|
private void frmGG2_FormClosing(object sender, FormClosingEventArgs e)
|
{
|
BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
}
|
|
|
#endregion
|
|
|
#region 读写类
|
//显示单据
|
public void Sub_ShowBill()
|
{
|
|
}
|
|
//单据完整性判断 未完成
|
private bool Sub_AllowSave()
|
{
|
//必输项目是否为空
|
if (DBUtility.ClsPub.isStrNull(txtZ.Text) == "")
|
{
|
MessageBox.Show("字没有填写！", "提示");
|
return false;
|
}
|
//
|
if (DBUtility.ClsPub.isStrNull(txtH.Text) == "")
|
{
|
MessageBox.Show("号没有填写！", "提示");
|
return false;
|
}
|
//
|
if (DBUtility.ClsPub.isStrNull(txtTM.Text) == "")
|
{
|
MessageBox.Show("主题没有填写！", "提示");
|
return false;
|
}
|
return true;
|
|
}
|
//保存单据
|
private bool Sub_SaveBill()
|
{
|
string sDate;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
long MainID;
|
MainID = DBUtility.ClsPub.CreateBillID(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
sDate = DateTime.Now.ToString();
|
string TM = txtTM.Text.Replace("'", "‘");
|
string Desc = txtDesc.Text.Replace("'", "‘");
|
// SaveFile MainID 保存文件
|
oCn.RunProc("Insert into oa_gg2(id,operator,z,h"+
|
",description,opdate,tm,MainID,Emp"+
|
",h2,Maker,MakeDate) " +
|
" values (" +
|
MainID + ",'" + DBUtility.ClsPub.CurUserName + "','" + txtZ.Text + "','" + txtH.Text + "'" +
|
",'" + Desc + "',getdate(),'" + TM + "'," + MainID + ",'" + txtEmp.Text + "'" +
|
",'" + txth2.Text + "','" + DBUtility.ClsPub.CurUserName + "',getdate() )");
|
if (txtEmp.Text != "")
|
{
|
string[] s = txtEmp.Text.Split(',');
|
int len = s.Length;
|
for (int i = 0; i < len; i++)
|
{
|
int j = i + 1;
|
string k = s[i].ToString();
|
oCn.RunProc("insert into oa_gg2sub (MainID,SubID,ROperator,isRead,isKnow,Description) " +
|
"values (" +
|
MainID + "," + j + ",'" + k + "',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;
|
}
|
#endregion
|
|
private void cmdEmp_Click(object sender, EventArgs e)
|
{
|
DBUtility.Gy_UserSelect oUser = new DBUtility.Gy_UserSelect();
|
oUser.bSingle = false;
|
oUser.ShowDialog();
|
if (oUser.IsOk == 1)
|
{
|
txtEmp.Text = oUser.sReturn;
|
}
|
else
|
{
|
txtEmp.Text = "";
|
}
|
}
|
|
|
}
|
}
|
