protected void btnDeleteAppendix_Click(object sender, EventArgs e)
{
//if (lbAppendixList.SelectedIndex >= 0)
//{
// SelectAppendix = lbAppendixList.SelectedItem.Value;
// //Title = lbAppendixList.SelectedItem.Text;
// EventHandler DeleteAppendixTemp = DeleteAppendix;
// if (DeleteAppendixTemp != null)
// {
// DeleteAppendixTemp(this, EventArgs.Empty);
// }
// //DataBindForAppendixList();
//}
CompanyReguAppendix selected = CompanyReguAppendixList[SelectedCompanyReguAppendixId];
//foreach (CompanyReguAppendix item in CompanyReguAppendixList)
//{
// if(item.AppendixID == SelectedCompanyReguAppendixId)
// {
// selected = item;
// break;
// }
//}
if (selected != null && DeleteAppendix != null)
{
DeleteAppendix(selected, null);
}
RefreshListBoxAppendixList();
}
private void FindAppendixInDirectory()
{
CompanyReguAppendix[] appendixtemp = new CompanyReguAppendix[_View.AppendixList.Count];
(_View.AppendixList).CopyTo(appendixtemp);
foreach (CompanyReguAppendix appendix in appendixtemp)
{
if (!File.Exists(appendix.Directory))
{
_View.AppendixList.Remove(appendix);
}
}
_View.AppendixList = _View.AppendixList;
}
protected void btnAddAppendix_Click(object sender, EventArgs e)
{
string fileDir = Server.MapPath(ConstParameters.UploadFile);
if (!Directory.Exists(fileDir))
{
Directory.CreateDirectory(fileDir);
}
HttpPostedFile hpf = Upload.PostedFile;
string fileName = Path.GetFileName(hpf.FileName);
string fileExt = Path.GetExtension(hpf.FileName);
CompanyReguAppendixListErrorMessage = "";
if (!string.IsNullOrEmpty(fileName.Trim()))
{
if (hpf.ContentLength > 5242880)
{
CompanyReguAppendixListErrorMessage = "附件大小不能大于5M";
return;
}
if (fileExt == ".exe")
{
CompanyReguAppendixListErrorMessage = "不能上传exe文件";
return;
}
if (AddAppendix != null)
{
string fileNamePrefix = DateTime.Now.ToString().Replace(" ", "").Replace(":", "").Replace("-", "");
string dir = Server.MapPath(ConstParameters.UploadFile) + "\\" + fileNamePrefix + "_" + fileName;
CompanyReguAppendix Appendix = new CompanyReguAppendix(ComanyReguId, fileName, dir);
//FileName = filename;
//string NowDate = DateTime.Now.ToString();
//NowDate = NowDate;
//NowDate = NowDate;
//NowDate = NowDate;
//filename = NowDate + "_" + filename;
//SelectAppendix = _UploadFileLocation + "\\" + filename;
hpf.SaveAs(dir);
//Title = filename;
AddAppendix(Appendix, EventArgs.Empty);
}
}
RefreshListBoxAppendixList();
}
/// <summary>
/// 插入公司规章制度附件
/// </summary>
public int InsertCompanyReguAppendix(CompanyReguAppendix obj)
{
int pkid;
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_AppendixID, SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add(_CompanyReguID, SqlDbType.Int).Value = obj.CompanyReguID;
cmd.Parameters.Add(_FileName, SqlDbType.NVarChar, 100).Value = obj.FileName;
cmd.Parameters.Add(_Directory, SqlDbType.NVarChar, 255).Value = obj.Directory;
cmd.Parameters.Add(_UpLoadDate, SqlDbType.DateTime).Value = DateTime.Now.Date;
SqlHelper.ExecuteNonQueryReturnPKID("CompanyReguAppendixInsert", cmd, out pkid);
obj.AppendixID = pkid;
return(pkid);
}
public List <CompanyReguAppendix> GetCompanyReguAppendixByCompanyRegulationsID(int companyRegulationsID)
{
List <CompanyReguAppendix> companyReguAppendixList = new List <CompanyReguAppendix>();
SqlCommand cmd = new SqlCommand();
cmd.Parameters.Add(_CompanyReguID, SqlDbType.Int).Value = companyRegulationsID;
using (SqlDataReader sdr = SqlHelper.ExecuteReader("GetCompanyReguAppendixByCompanyReguID", cmd))
{
while (sdr.Read())
{
CompanyReguAppendix appendix = new CompanyReguAppendix(
Convert.ToInt32(sdr[_DbAppendixID]),
Convert.ToInt32(sdr[_DbCompanyReguID]),
sdr[_DbFileName].ToString(),
sdr[_DbDirectory].ToString(),
Convert.ToDateTime(sdr[_DbUpLoadDate]));
companyReguAppendixList.Add(appendix);
}
}
return(companyReguAppendixList);
}
