private void UpLoadYj(int YjID)
{
bool upload = UpLoadDownLoad.UpLoadFile(localFilePath, ref fileName, ref fileNameExt, ref RemoteFileName, ref uploadURI);
//上传原件成功后，将原件信息存储至数据库
if (upload)
{
int xh = OldCJ_yj.getYjMaxNum(DocID) + 1; //序号
string description = fileName.Substring(0, fileName.LastIndexOf(".")); //获取文件名称为描述
int index = UpLoadDownLoad.TopUploadURI.Length;
string saveURI = uploadURI.Substring(index);
//添加原件信息到数据库
if (YjID == 0)
{
YjID = OldCJ_yj.insertYj(DocID, xh, description, fileNameExt, saveURI, RemoteFileName);
if (YjID <= 0)
{
return;
}
}
else
{
//修改原件的存储信息
OldCJ_yj.ChangeYj(YjID, description, fileNameExt, saveURI, RemoteFileName);
}
//刷新dgv
ds = OldCJ_yj.getData(DocID);
dgvRows = ds.Tables[0].Rows.Count + 1;
dgvYj.DataSource = ds.Tables[0];
table = ds.Tables[0];
lbldgvNum.Text = Convert.ToString(dgvYj.Rows.Count - 1);
}
}
/// <summary>
/// 上传一个文书档案原件
/// </summary>
/// <param name="title">文件名(不含扩展名)</param>
/// <param name="localFilePath">完整路径</param>
public void UploadFile_WS(string title, string localFilePath, bool IsDeleteOld)
{
SetValue(title);
int DocID = uploadScan_WS.GetDocID(ContentNum, FileNum, DocNum);
if (DocID != 0)
{
bool upload = UpLoadDownLoad.UpLoadFile(localFilePath, ref fileName, ref fileNameExt, ref RemoteFileName, ref uploadURI);
//上传原件成功后，将原件信息存储至数据库
if (upload)
{
int xh = Convert.ToInt32(IndexNum); //序号
string description = fileName.Substring(0, fileName.LastIndexOf(".")); //获取文件名称为描述
int index = UpLoadDownLoad.TopUploadURI.Length;
string saveURI = uploadURI.Substring(index);
//添加原件信息到数据库
int YjID = uploadScan_WS.GetYjID(ContentNum, FileNum, DocNum, IndexNum);
if (YjID > 0)
{
if (IsDeleteOld)
{
uploadScan_WS.DeleteYj(YjID);
}
else
{
return;
}
}
uploadScan_WS.InsertYj(DocID, xh, description, fileNameExt, saveURI, RemoteFileName);
}
}
}
//删除行
void tsdelete_Click(object sender, EventArgs e)
{
dgvYj.CancelEdit();
dgvYj.EndEdit();
if (dgvYj.SelectedRows.Count > 0)
{
DialogResult result = MessageBox.Show("确实要删除原件吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
for (int i = 0; i < dgvYj.SelectedRows.Count; i++)
{
object YjID = dgvYj.Rows[dgvYj.SelectedRows[i].Index].Cells["原件ID"].Value;
object path = dgvYj.Rows[dgvYj.SelectedRows[i].Index].Cells["路径"].Value;
object fileName = dgvYj.Rows[dgvYj.SelectedRows[i].Index].Cells["保存名称"].Value;
if (Object.Equals(YjID, "") || Object.Equals(YjID, null) || Object.Equals(YjID, DBNull.Value))
{
continue;
}
else
{
if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value))
{
if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value))
{
UpLoadDownLoad.DeleteFile(path.ToString(), fileName.ToString());
}
}
CJ_yj.DeleteYj(Convert.ToInt32(YjID));
}
}
//MessageBox.Show("删除成功！");
ds = CJ_yj.getData(DocID);
dgvYj.DataSource = ds.Tables[0];
table = ds.Tables[0];
lbldgvNum.Text = "共有纪录数：" + Convert.ToString(dgvYj.Rows.Count - 1);
if (dgvYj.Rows.Count == 1)
{
txtYjIndex.Text = "1";
}
else
{
txtYjIndex.Text = Convert.ToString(dgvYj.CurrentCell.RowIndex + 1);
}
int num = dgvYj.Rows.Count;
publicDgv.DataGridView导航(dgvYj, num);
}
}
else
{
MessageBox.Show("请选择要删除的行！");
return;
}
}
private void btnOpenImages_Click(object sender, EventArgs e)
{
if (dgvYj.Rows.Count <= 1)
{
return;
}
#region 定义目录
string directory = DBUtility.AppTempFilePath + "\\TempImgFile\\";
if (!Directory.Exists(directory))
{
Directory.CreateDirectory(directory);
}
else
{
try
{
Directory.Delete(directory, true);
Directory.CreateDirectory(directory);
}
catch { }
}
#endregion
#region 载所有图片原件
string localfilename = "";
string firstFileName = "";
string filename = "";//FTP保存名称，后缀名带x
DataSet ds = gd_yj.getImageData(DocID);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
object path = ds.Tables[0].Rows[i]["Ftp目录"];
object fileName = ds.Tables[0].Rows[i]["Ftp保存名称"];
object desc = ds.Tables[0].Rows[i]["描述"];
object ext = ds.Tables[0].Rows[i]["扩展名"];
filename = Convert.ToString(fileName);
localfilename = filename.Substring(0, filename.Length - 1);
UpLoadDownLoad.DownLoadFile(Convert.ToString(path), Convert.ToString(fileName), directory, localfilename);
if (i == 0)
{
firstFileName = localfilename;
}
}
//打开第一个图片
if (File.Exists(directory + firstFileName))
{
System.Diagnostics.Process.Start(directory + firstFileName);
}
}
#endregion
}
private void btnCK_Click(object sender, EventArgs e)
{
#region
if (showModel == ShowModel.List)
{
if (UIPublicClass.PublicClass.OpenYj == YjOpenModel.ImageType)
{
this.Visible = false;
panelDgv.Visible = false;
panelPhoto.Visible = true;
showModel = ShowModel.Photo;
getPhotoList(DocID);
if (dgvYj.CurrentCell != null)
{
if (dgvYj.Rows.Count == 1)
{
ShowPhotoIndex(-1);
}
else
{
ShowPhotoIndex(dgvYj.CurrentCell.RowIndex);
}
}
else
{
ShowPhotoIndex(-1);
}
this.Visible = true;
}
else
{
if (dgvYj.CurrentCell != null)
{
object path = dgvYj.Rows[dgvYj.CurrentCell.RowIndex].Cells["Ftp目录"].Value;
object fileName = dgvYj.Rows[dgvYj.CurrentCell.RowIndex].Cells["Ftp保存名称"].Value;
if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value))
{
if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value))
{
UpLoadDownLoad.OpenFile(path.ToString(), fileName.ToString());
}
}
}
}
}
#endregion
}
//查看原件
private void btnCheckYj_Click(object sender, EventArgs e)
{
if (dgvYj.CurrentCell != null)
{
object path = dgvYj.Rows[dgvYj.CurrentCell.RowIndex].Cells["路径"].Value;
object fileName = dgvYj.Rows[dgvYj.CurrentCell.RowIndex].Cells["保存名称"].Value;
if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value))
{
if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value))
{
UpLoadDownLoad.OpenFile(path.ToString(), fileName.ToString());
}
}
}
}
private bool UpLoadYj(int newYjNum, int docID)
{
bool upload = UpLoadDownLoad.UpLoadFile(localFilePath, ref fileName, ref fileNameExt, ref RemoteFileName, ref uploadURI);
//上传原件成功后，将原件信息存储至数据库
if (upload)
{
int xh = newYjNum; //序号
string description = fileName.Substring(0, fileName.LastIndexOf(".")); //获取文件名称为描述
int index = UpLoadDownLoad.TopUploadURI.Length;
string saveURI = uploadURI.Substring(index);
if (uploadScan_CJ.insertCJYJ(isCJNew, docID, xh, description, fileNameExt, saveURI, RemoteFileName) > 0)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 上传一个归档文件档案原件
/// </summary>
/// <param name="title">文件名(不含扩展名)</param>
/// <param name="localFilePath">完整路径</param>
public void UploadFile_GD(string title, string localFilePath, bool IsDeleteOld)
{
//Title:GD_10年_2010_党务人事类_001_002
string[] list = title.Split('_');
if (list != null && list.Length == 6)
{
Limit = list[1].ToString();
Year = list[2].ToString();
LeiMu = list[3].ToString();
DocNum = list[4].ToString();
IndexNum = list[5].ToString();
}
int DocID = uploadScan_GD.GetDocID(Limit, Year, LeiMu, DocNum);
if (DocID != 0)
{
bool upload = UpLoadDownLoad.UpLoadFile(localFilePath, ref fileName, ref fileNameExt, ref RemoteFileName, ref uploadURI);
//上传原件成功后，将原件信息存储至数据库
if (upload)
{
int xh = Convert.ToInt32(IndexNum); //序号
string description = fileName.Substring(0, fileName.LastIndexOf(".")); //获取文件名称为描述
int index = UpLoadDownLoad.TopUploadURI.Length;
string saveURI = uploadURI.Substring(index);
//添加原件信息到数据库
int YjID = uploadScan_GD.GetYjID(Limit, Year, LeiMu, DocNum, IndexNum);
if (YjID > 0)
{
if (IsDeleteOld)
{
uploadScan_GD.DeleteYj(YjID);
}
else
{
return;
}
}
uploadScan_GD.InsertYj(DocID, xh, description, fileNameExt, saveURI, RemoteFileName);
}
}
}
//查看详细信息
private void dgvYj_CellClick(object sender, DataGridViewCellEventArgs e)
{
#region 查看和下载原件
if (e.ColumnIndex >= 0 && e.RowIndex >= 0)
{
object YjID = dgvYj.Rows[e.RowIndex].Cells["原件ID"].Value;
object desc = dgvYj.Rows[e.RowIndex].Cells["描述"].Value;
object ext = dgvYj.Rows[e.RowIndex].Cells["扩展名"].Value;
object path = dgvYj.Rows[e.RowIndex].Cells["Ftp目录"].Value;
object fileName = dgvYj.Rows[e.RowIndex].Cells["Ftp保存名称"].Value;
if (dgvYj.Columns[e.ColumnIndex].Name == "载入")
{
//新增行，直接调用添加原件
if (e.RowIndex == (dgvYj.Rows.Count - 1))
{
InputYJ(false, 0);
}
else//修改原件
{
if (!Object.Equals(YjID, "") && !Object.Equals(YjID, null) && !Object.Equals(YjID, DBNull.Value))
{
//如存在原件文件，先删除原有文件，再载入新的文件
if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value))
{
DialogResult result = MessageBox.Show("已经存在原件文件，是否要替换原有文件？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
UpLoadDownLoad.DeleteFile(path.ToString(), fileName.ToString());
}
else
{
return;
}
}
//单个原件加载
InputYJ(false, Convert.ToInt32(YjID));
}
}
if (dgvYj.Rows.Count > 1)
{
dgvYj.CurrentCell = dgvYj.Rows[e.RowIndex].Cells[dgvYj.FirstDisplayedCell.ColumnIndex];
}
}
if (dgvYj.Columns[e.ColumnIndex].Name == "查看" &&
e.RowIndex != (dgvYj.Rows.Count - 1))
{
if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value))
{
if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value))
{
UpLoadDownLoad.OpenFile(path.ToString(), fileName.ToString());
}
}
}
if (dgvYj.Columns[e.ColumnIndex].Name == "下载" &&
e.RowIndex != (dgvYj.Rows.Count - 1))
{
if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value))
{
if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value))
{
UIPublicClass.PublicClass.DownLoadFile(Convert.ToString(path), Convert.ToString(fileName), Convert.ToString(desc), Convert.ToString(ext));
}
}
}
if (dgvYj.Columns[e.ColumnIndex].Name == "删除" &&
e.RowIndex != (dgvYj.Rows.Count - 1))
{
DialogResult result = MessageBox.Show("确实要删除原件吗？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result == DialogResult.OK)
{
if (!Object.Equals(YjID, "") && !Object.Equals(YjID, null) && !Object.Equals(YjID, DBNull.Value))
{
if (!Object.Equals(path, string.Empty) && !Object.Equals(path, null) && !Object.Equals(path, DBNull.Value))
{
if (!Object.Equals(fileName, string.Empty) && !Object.Equals(fileName, null) && !Object.Equals(fileName, DBNull.Value))
{
UpLoadDownLoad.DeleteFile(path.ToString(), fileName.ToString());
}
}
gd_yj.DeleteYj(Convert.ToInt32(YjID));
}
MessageBox.Show("删除成功！");
ds = gd_yj.getData(DocID);
dgvYj.DataSource = ds.Tables[0];
table = ds.Tables[0];
lblCount.Text = Convert.ToString(dgvYj.Rows.Count - 1);
if (dgvYj.Rows.Count == 1)
{
txt行号.Text = "1";
}
else
{
txt行号.Text = Convert.ToString(dgvYj.CurrentCell.RowIndex + 1);
}
}
}
}
#endregion
}
