1.上传附件
html
<input name="ExcelPath" type="text" maxlength="255" id="txtExcelPath" readonly="readonly" style="width:200px" class="txtInput normal left">
<a href="javascript:$('#FileUpload').trigger('click').void(0);" class="files">@Resource.Browse</a>
<input class="displaynone" type="file" id="FileUpload" name="FileUpload" onchange="Upload('SingleFile', 'txtExcelPath', 'FileUpload','1','1');">
@*<input class="displaynone" type="file" id="FileUpload" name="FileUpload" onchange="AttachUpload('txtExcelPath','txtExcelPath');">*@
<span class="uploading">@Resource.Uploading</span>
<input type="hidden" id="enumStatus" />
重点是Upload()使用 在common.js中 最重要的第一个参数 决定你上传文件的类型
js
//导入压缩包
function ImportData() {
showLoading();
var id = '@Model.Id';
var url = "@Url.Action("ImportPackage")?filePath=" + $("#txtExcelPath").val() + "&daiKuanId="+id;
$.post(url, function (data) {
//if (data.type == 1) {
// $('#uploadExcel').window('close');
// $('#FileUpload').val('');
// $("#List").datagrid('load');
//}
hideLoading();
$.messageBox5s('提示', data.message);
}, "json");
}
后台.net
#region 附件导入
[HttpPost]
public JsonResult ImportPackage(string filePath, string daiKuanId)
{
try
{
//得到这个用户有没有附件
var firstDaiKuan = _CZ_FileBLL.m_Rep.Find(m => m.PK_CZ_Daikuan_UserName == daiKuanId);
if (firstDaiKuan == null)
{
//如果没有新增
CZ_File file = new CZ_File();
file.Id = ResultHelper.NewId;
file.CreateTime = DateTime.Now;
file.ModificationTime = DateTime.Now;
file.CreateUserName = GetUserId();
file.FileUrl = filePath;
file.PK_CZ_Daikuan_UserName = daiKuanId;
_CZ_FileBLL.m_Rep.Create(file);
}
else
{
var url = firstDaiKuan.FileUrl;
if (url != filePath)
{ //删除已存在的旧文件
Utils.DeleteUpFile(url);
}
//如果有
firstDaiKuan.FileUrl = filePath;
firstDaiKuan.ModificationTime = DateTime.Now;
firstDaiKuan.ModificationUserName = GetUserId();
_CZ_FileBLL.m_Rep.Edit(firstDaiKuan);
}
}
catch (Exception ex)
{
string ErrorCol = ex.ToString();
LogHandler.WriteServiceLog(GetUserId(), ErrorCol, "失败", "导入", "LoanController.Import");
return Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol));
}
return Json(JsonHandler.CreateMessage(0,"导入成功"));
}
#endregion
2.导出(在globalUtils进行了封装,直接调用DownloadAttach方法就可以,第一个传路径参数,第二个传方法名就可以)
$("#btnExportPackage").click(function () {
showLoading();
var row = $('#List').datagrid('getSelected');
if (row != null) {
var url = "@Url.Action("ExportPackage")?&daiKuanId=" + row.Id;
$.post(url, function (data) {
if (data.type == 1) {
console.log(data.message);
globalUtils.DownloadAttach(data.message, row.UserName);
} else { $.messageBox5s('提示', data.message); }
hideLoading();
}, "json");
} else {
$.messageBox5s('@Resource.Tip', '@Resource.PlaseChooseToOperatingRecords');
}
});