//删除合同索赔附件
public static void Del_SPAttachment(string htbh)
{
//删除对应的文件，用唯一编号关联
//一个合同可能对应多个索赔单号，一个索赔单号可能对应多个附件
string sql_atfilepath = "select AT_FILEPATH from TBPM_ATTACHMENTS where AT_HTBH in (" +
"select GUID from TBPM_SUBCLAIM where SPS_HTBH='" + htbh + "')";
System.Data.DataTable dt_atfilepath = DBCallCommon.GetDTUsingSqlText(sql_atfilepath);
for (int i = 0; i < dt_atfilepath.Rows.Count; i++)
{
string fileName = dt_atfilepath.Rows[i]["AT_FILEPATH"].ToString();
//string fileName = DBCallCommon.GetFieldValue(dt_atfilepath.Rows[i]["AT_FILEPATH"].ToString());
string attachPath = @"E:/合同管理附件";//附件上传位置
string proj_type = "索赔文档";
string filepath = CommonFun.CreateDirName(attachPath, proj_type) + fileName;
//判断文件是否存在，如果不存在提示重新上传
if (System.IO.File.Exists(filepath))
{
DBCallCommon.DeleteFile(filepath);
//重新读出附件信息
}
}
DBCallCommon.ExeSqlText("delete from TBPM_ATTACHMENTS where AT_HTBH in(" +
"select GUID from TBPM_SUBCLAIM where SPS_HTBH='" + htbh + "')");
}
protected void btnUpload_Click(object sender, EventArgs e)
{
//这个attachName表示原文件名。
HttpPostedFile hpf = FileUpload1.PostedFile;
//string attachName = FileUpload1.PostedFile.FileName.Substring(FileUpload1.PostedFile.FileName.LastIndexOf("\\")).Substring(1);
string attachName = System.IO.Path.GetFileName(hpf.FileName);
//把文件上传到Attachments目录下
string path = CommonFun.CreateDirName(attachPath, proj_type); //带'\'
string fileName = DBCallCommon.Savefile(FileUpload1, path); //fileName表示新文件名
//把附件信息插入到attachment表
if (attachName != "" || fileName != "")
{
string sqlText = "insert into TBPM_ATTACHMENTS";
sqlText += "(AT_HTBH,AT_NAME,AT_DESCRIBE,AT_CREATDATE,AT_FILEPATH,AT_TYPE,AT_SPLB) " +
"Values('" + _at_htbh + "','" + attachName + "','" + txtDesc.Text.Trim() + "',getdate(),'" + fileName + "'," + _at_type + "," + _at_sp + ")";
DBCallCommon.ExeSqlText(sqlText);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请添加附件！！！');", true);
}
//把所有附件信息显示出来
bindGrid();
txtDesc.Text = "";
//txtBeizhu.Text = "";
//Response.Redirect(Request.Url.ToString());//防止二次刷新
}
protected void btnUpload_Click(object sender, EventArgs e)
{
//这个attachName表示原文件名。
HttpPostedFile hpf = FileUpload1.PostedFile;
string attachName = System.IO.Path.GetFileName(hpf.FileName);
//把文件上传到Attachments目录下
string path = CommonFun.CreateDirName(attachPath, proj_type); //带'\'
string fileName = DBCallCommon.Savefile(FileUpload1, path); //fileName表示新文件名
//把附件信息插入到TBQC_FILEUPLOAD表
if (attachName != "" || fileName != "")
{
string sqlText = "insert into TBQC_FILEUPLOAD";
sqlText += "(UF_CODE,UF_NAME,UF_UPLOADTIME,UF_FILEPATH,UF_TYPE) " +
"Values('" + _uf_code + "','" + attachName + "',getdate(),'" + fileName + "'," + _uf_type + ")";
DBCallCommon.ExeSqlText(sqlText);
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请添加附件！！！');", true);
}
//把所有附件信息显示出来
bindGrid();
upl_load_del();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "attachdel")
{
//获取当前操作的行索引
GridViewRow gvrow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
int index = gvrow.RowIndex;
//根据获取到得行索引，读出该条记录的ID
string id = ((Label)(GridView1.Rows[index].FindControl("lblID"))).Text.Trim();
//删除对应的文件
string fileName = DBCallCommon.GetFieldValue("select AT_FILEPATH from TBPM_ATTACHMENTS where AT_ID=" + id);
string filepath = CommonFun.CreateDirName(attachPath, proj_type) + fileName;
//判断文件是否存在，如果不存在提示重新上传
if (System.IO.File.Exists(filepath))
{
DBCallCommon.DeleteFile(filepath);
//重新读出附件信息
}
else
{
Lbl_remind.Visible = true;
}
//根据记录的ID从数据库中删除该记录
DBCallCommon.ExeSqlText("delete from TBPM_ATTACHMENTS where AT_ID=" + id);
bindGrid();
}
if (e.CommandName == "attachview")
{
//获取当前操作的行索引
GridViewRow gvrow = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
int index = gvrow.RowIndex;
//根据获取到得行索引，读出该条记录的ID
string id = ((Label)(GridView1.Rows[index].FindControl("lblID"))).Text.Trim();
//读出对应的文件名和路径
string fileName = DBCallCommon.GetFieldValue("select AT_FILEPATH from TBPM_ATTACHMENTS where AT_ID=" + id);
string filepath = CommonFun.CreateDirName(attachPath, proj_type) + fileName;
//判断文件是否存在，如果不存在提示重新上传
if (System.IO.File.Exists(filepath))
{
DBCallCommon.FileDown_byte(fileName, filepath);
}
else
{
Lbl_remind.Visible = true;
}
}
//Response.Redirect(Request.Url.ToString());
}
