using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using System.IO;
|
using System.Diagnostics;
|
using DBUtility;
|
using Pub_Class;
|
|
namespace BLL
|
{
|
public partial class Xt_File : Form
|
{
|
public string sServer = "";
|
public string sDataBase = "";
|
public string sUser = "";
|
public string sPassword = "";
|
public Xt_File()
|
{
|
InitializeComponent();
|
//sServer = ClsIni.ReadIni("Erp", "Server", DBUtility.ClsPub.AppPath + @"\" + "HXErp.ini");
|
//sDataBase = ClsIni.ReadIni("Erp", "DataBase", DBUtility.ClsPub.AppPath + @"\" + "HXErp.ini");
|
//sUser = ClsIni.ReadIni("Erp", "UserName", DBUtility.ClsPub.AppPath + @"\" + "HXErp.ini");
|
//sPassword = ClsIni.ReadIni("Erp", "PassWord", DBUtility.ClsPub.AppPath + @"\" + "HXErp.ini");
|
|
//oFile = new ClsFile(sServer, sDataBase, sUser, sPassword);
|
}
|
public DBUtility.frmBillQueryCondition_New frmCondition;
|
const string ViewName = "h_v_Xt_FileList";
|
const string ModCaption = "单据附件列表";
|
ClsXt_FileCtrl oBill = new ClsXt_FileCtrl();
|
//
|
public long HBillID;
|
public string HBillNo;
|
public string HBillType;
|
//
|
public ClsXt_FileCtrl oFrm;
|
//
|
private void initGrid()
|
{
|
DBUtility.Xt_BaseBillFun.initGridList(grdMain, this.Name);
|
}
|
|
private void Display()
|
{
|
SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN();
|
DataSet DSet;
|
string sSql = "";
|
string sWhere = "and HBillNo='" + this.HBillNo + "' and HBillType='" +this.HBillType+ "'";
|
//过滤条件
|
sSql = "select * from h_v_Xt_FileList where 1=1 " + sWhere + " order by HMainID ";
|
//
|
DSet = SubCn.RunProcReturn(sSql, "h_v_Xt_FileList", ref DBUtility.ClsPub.sExeReturnInfo);
|
//生成首行标题
|
if (DSet == null)
|
{
|
MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
//
|
for (int i = 0; i < grdMain.ColumnCount; i++)
|
{
|
grdMain.Columns[i].Frozen = false;
|
}
|
//
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
|
//冻结
|
int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text);
|
string s = frmCondition.cmbHComplete.Text;
|
DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol);
|
//画线
|
GraphLine();
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
Display();
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void sx_Click(object sender, EventArgs e)
|
{
|
timer1.Enabled = true;
|
}
|
|
private void ck_Click(object sender, EventArgs e)
|
{
|
Sub_ShowBill();
|
}
|
|
private void Sub_ShowBill()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
Int64 lngBillKey = 0;
|
if (grdMain.CurrentRow == null)
|
return;
|
lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
|
if (lngBillKey == 0)
|
return;
|
ClsXt_FileCtrl oBill = new ClsXt_FileCtrl();
|
if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo, oCn))
|
{
|
if (oBill.CompressBackFile(DBUtility.ClsPub.AppPath + @"\a\" + oBill.HFileName, oBill.HInterID, oCn))
|
{
|
ShowFile(oBill.HFileName);
|
}
|
}
|
else
|
{
|
MessageBox.Show("附件未找到！", "提示");
|
}
|
oBill = null;
|
}
|
|
private void ShowFile(string FileName)
|
{
|
string sHPath = "";
|
sHPath = DBUtility.ClsPub.AppPath + @"\a\" + FileName;
|
Process p = new Process();
|
p.StartInfo.FileName = sHPath;
|
p.Start();
|
p.WaitForExit();
|
File.Delete(sHPath);
|
}
|
private Int32 Fun_GetCol(string sCol)
|
{
|
for (int c = 0; c < grdMain.ColumnCount; c++)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Columns[c].HeaderText).ToUpper().Trim() == sCol.Trim().ToUpper())
|
{
|
return c;
|
}
|
}
|
return 0;
|
}
|
|
private void Xt_File_Load(object sender, EventArgs e)
|
{
|
//
|
frmCondition = new frmBillQueryCondition_New();
|
this.Text = ModCaption;
|
lblCaption.Text = ModCaption;
|
initGrid();
|
}
|
|
private void cx_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void sc_Click(object sender, EventArgs e)
|
{
|
Sub_DeleteBill();
|
}
|
//删除
|
private void Sub_DeleteBill()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
Int64 lngBillKey = 0;
|
if (grdMain.CurrentRow == null)
|
return;
|
lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentCell.RowIndex].Cells[Fun_GetCol("HMainID")].Value);
|
if (lngBillKey == 0)
|
return;
|
ClsXt_FileCtrl oBill = new ClsXt_FileCtrl();
|
if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo, oCn))
|
{
|
if (MessageBox.Show("确定要删除当前附件？", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
|
{
|
//if (oBill.HChecker != "")
|
//{
|
// MessageBox.Show("单据已经审核,不能删除！", "提示");
|
// return;
|
//}
|
if (!oBill.DeleteBill(oBill.HInterID, ref DBUtility.ClsPub.sExeReturnInfo, oCn))
|
{
|
MessageBox.Show(DBUtility.ClsPub.sExeReturnInfo, "提示");
|
return;
|
}
|
else
|
{
|
Display();
|
}
|
}
|
}
|
else
|
{
|
MessageBox.Show("附件未找到", "提示");
|
}
|
}
|
|
private void timer2_Tick(object sender, EventArgs e)
|
{
|
|
|
}
|
|
private void yl_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
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);
|
}
|
//划线
|
private void GraphLine()
|
{
|
|
}
|
|
//设置网格
|
private void SetDataGrid(int BRow, int BCol, int ERow, int ECol, string sText)
|
{
|
for (int i = BRow; i <= ERow; i++)
|
{
|
for (int j = BCol; j <= ECol; j++)
|
{
|
grdMain.Rows[i].Cells[j].Value = DBNull.Value;
|
}
|
}
|
}
|
|
private void GraphicsGrid()
|
{
|
|
}
|
|
private void grdMain_DoubleClick(object sender, EventArgs e)
|
{
|
Sub_ShowBill();
|
}
|
|
private void grdMain_Paint(object sender, PaintEventArgs e)
|
{
|
GraphicsGrid();
|
}
|
|
//上传附件
|
private void Loading_Click(object sender, EventArgs e)
|
{
|
OpenFileDialog oDlg = new OpenFileDialog();
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
oBill = new ClsXt_FileCtrl();
|
oDlg.Filter = "所有文件|*.*";
|
if (oDlg.ShowDialog() == DialogResult.OK)
|
{
|
if (oDlg.FileName != "")
|
{
|
FileInfo fi = new FileInfo(oDlg.FileName);
|
oBill.HFileSize = fi.Length;
|
oBill.HFileType = fi.Extension;
|
oBill.HPath = fi.FullName;
|
oBill.HFileName = fi.Name;
|
oBill.HRemark = "";
|
oBill.HBillID = this.HBillID;
|
oBill.HBillNo = this.HBillNo;
|
oBill.HBillType = this.HBillType;
|
if (oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo, oCn))
|
{
|
//压缩附件并保存
|
if (oBill.CompressFile(oDlg.FileName, "Xt_Accessories", "HFile", oBill.HInterID, oCn))
|
{
|
Display();
|
}
|
}
|
else
|
{
|
MessageBox.Show("上传失败!原因:" + DBUtility.ClsPub.sExeReturnInfo, "提示");
|
return;
|
}
|
}
|
}
|
}
|
|
//下载附件
|
private void xz_Click(object sender, EventArgs e)
|
{
|
Sub_DownLoad();
|
}
|
|
|
private void Sub_DownLoad()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
Int64 lngBillKey = 0;
|
string FileName = "";
|
string HouZhui = "";
|
int i = 0;
|
SaveFileDialog oDlg = new SaveFileDialog();
|
if (grdMain.CurrentRow == null)
|
return;
|
lngBillKey = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[Fun_GetCol("hmainid")].Value);
|
if (lngBillKey == 0)
|
return;
|
ClsXt_FileCtrl oBill = new ClsXt_FileCtrl();
|
if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo, oCn))
|
{
|
FileName = oBill.HFileName;
|
i = FileName.LastIndexOf(".");
|
HouZhui = "." + FileName.Substring(i + 1, FileName.Length - i - 1);
|
HouZhui = HouZhui + "|" + HouZhui;
|
oDlg.FileName = FileName;
|
oDlg.Filter = HouZhui + "|所有文件|*.*";
|
if (oDlg.ShowDialog() == DialogResult.OK)
|
{
|
if (oDlg.FileName != "")
|
{
|
if (oBill.CompressBackFile(DBUtility.ClsPub.AppPath + @"\a\" + FileName, oBill.HInterID, oCn))
|
{
|
File.Move(DBUtility.ClsPub.AppPath + @"\a\" + FileName, oDlg.FileName);
|
//
|
MessageBox.Show("附件下载成功！", "提示");
|
return;
|
}
|
}
|
}
|
}
|
else
|
{
|
MessageBox.Show("附件未找到！", "提示");
|
}
|
oBill = null;
|
|
|
}
|
|
|
|
}
|
}
|
