//根据日期模糊查询获取编号
public string GetIdByTime(string dateTime)
{
T_File fileModel = new T_File();
DataTable file = dal.GetIdByTime(dateTime);
string str = null;
if (file.Rows.Count == 0)
{
str = dateTime + "001";
}
else
{
fileModel.FileId = file.Rows[0]["C_FileId"].ToString().Trim();
int strId = Int32.Parse(fileModel.FileId.Substring(8, 3)) + 1;
if (strId >= 10)
{
str = dateTime + "0" + strId.ToString().Trim();
}
else if (strId >= 100)
{
str = dateTime + strId.ToString().Trim();
}
else
{
str = dateTime + "00" + strId.ToString().Trim();
}
}
return(str);
}
public ActionResult CreateFileMgr(HttpPostedFileWrapper file, string name)
{
var fileModel = new T_File()
{
Name = name ?? file.FileName,
Path = SaveFile(file, "files"),
CreateDate = DateTime.Now
};
dbContent.File.Add(fileModel);
dbContent.SaveChanges();
return(Ok());
}
//插入
public int Insert(T_File file)
{
string sql = "insert into T_File values(@id,@name,@time,@sector,@summary,@path,@ext,@num)";
SqlParameter[] sp =
{
new SqlParameter("@id", file.FileId),
new SqlParameter("@name", file.FileName),
new SqlParameter("@time", file.FileTime),
new SqlParameter("@sector", file.FileSector),
new SqlParameter("@summary", file.FileSummary),
new SqlParameter("@path", file.FilePath),
new SqlParameter("@ext", file.FileExt),
new SqlParameter("@num", file.FileDowNum)
};
return(SqlHelper.ExecuteNonQuery(sql, CommandType.Text, sp));
}
//转化datatable 为list
public List <T_File> DataTableToList(DataTable tb)
{
List <T_File> list = new List <T_File>();
if (tb.Rows.Count > 0)
{
for (int i = 0; i < tb.Rows.Count; i++)
{
T_File model = new T_File();
model.FileId = tb.Rows[i]["C_FileId"].ToString();
if (tb.Rows[i]["C_FileId"].ToString() != "")
{
model.FileName = tb.Rows[i]["C_FileName"].ToString();
}
if (tb.Rows[i]["C_FileSector"].ToString() != "")
{
model.FileSector = tb.Rows[i]["C_FileSector"].ToString();
}
if (tb.Rows[i]["C_FileTime"] != null)
{
DateTime time = DateTime.Parse(tb.Rows[i]["C_FileTime"].ToString());
model.FileTime = time.ToString("yyyy-MM-dd");
}
if (tb.Rows[i]["C_FileSummary"].ToString() != "")
{
model.FileSummary = tb.Rows[i]["C_FileSummary"].ToString();
}
if (tb.Rows[i]["C_FilePath"].ToString() != "")
{
model.FilePath = tb.Rows[i]["C_FilePath"].ToString();
}
if (tb.Rows[i]["C_FileExt"].ToString() != "")
{
model.FileExt = tb.Rows[i]["C_FileExt"].ToString();
}
if (tb.Rows[i]["C_FileDowNum"].ToString() != "")
{
model.FileDowNum = int.Parse(tb.Rows[i]["C_FileDowNum"].ToString());
}
list.Add(model);
}
}
return(list);
}
//根据id获取mode
public T_File GetModelById(string id)
{
DataTable tb = dal.GetModelById(id);
T_File model = new T_File();
if (tb.Rows.Count > 0)
{
model.FileId = tb.Rows[0]["C_FileId"].ToString();
if (tb.Rows[0]["C_FileId"].ToString() != "")
{
model.FileName = tb.Rows[0]["C_FileName"].ToString();
}
if (tb.Rows[0]["C_FileSector"].ToString() != "")
{
model.FileSector = tb.Rows[0]["C_FileSector"].ToString();
}
if (tb.Rows[0]["C_FileTime"] != null)
{
DateTime time = DateTime.Parse(tb.Rows[0]["C_FileTime"].ToString());
model.FileTime = time.ToString("yyyy-MM-dd");
}
if (tb.Rows[0]["C_FileSummary"].ToString() != "")
{
model.FileSummary = tb.Rows[0]["C_FileSummary"].ToString();
}
if (tb.Rows[0]["C_FilePath"].ToString() != "")
{
model.FilePath = tb.Rows[0]["C_FilePath"].ToString();
}
if (tb.Rows[0]["C_FileExt"].ToString() != "")
{
model.FileExt = tb.Rows[0]["C_FileExt"].ToString();
}
if (tb.Rows[0]["C_FileDowNum"].ToString() != "")
{
model.FileDowNum = int.Parse(tb.Rows[0]["C_FileDowNum"].ToString());
}
}
return(model);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["fileid"] != "" || Request["fileid"] != null)
{
string id = Context.Request["fileid"];
model = bll.GetModelById(id);
if (model.FileName == null)
{
Response.Redirect("error.html");
}
//上下篇
List <T_File> lastFileList = bll.GetLastFile(id);
List <T_File> nextFileList = bll.GetNextFile(id);
if (lastFileList.Count > 0)
{
lastFileHref = "FileDetail.aspx?FileId=" + lastFileList[0].FileId;
lastFileTitle = lastFileList[0].FileSummary;
}
else
{
lastFileHref = "";
lastFileTitle = "没有了";
}
if (nextFileList.Count > 0)
{
nextFileHref = "FileDetail.aspx?FileId=" + nextFileList[0].FileId;
nextFileTitle = nextFileList[0].FileSummary;
}
else
{
nextFileHref = "";
nextFileTitle = "没有了";
}
}
else
{
Response.Redirect("error.html");
}
}
public ResponseBase InsertOrUpdate(ManipulationLibraryModel model, List <ManipulationEquipmentModel> TMUModel, List <FileUploadModel> fileModel)
{
try
{
using (db = new IEDEntities())
{
var result = new ResponseBase();
T_ManipulationLibrary mani = null;
T_ManipulationEquipment maniEquipment = null;
T_ManipulationFile maniFile = null;
T_File file = null;
if (CheckExists(model.Name.Trim().ToUpper(), model.Id, true))
{
result.IsSuccess = false;
result.Errors.Add(new Error()
{
MemberName = "Insert ", Message = "Tên Thao Tác này đã tồn tại . Vui lòng chọn lại Tên khác !."
});
return(result);
}
if (!string.IsNullOrEmpty(model.Code))
{
if (CheckExists(model.Code.Trim().ToUpper(), model.Id, false))
{
result.IsSuccess = false;
result.Errors.Add(new Error()
{
MemberName = "Insert ", Message = "Mã Thao Tác này đã tồn tại này. Vui lòng chọn lại Mã khác !."
});
return(result);
}
}
if (model.Id == 0)
{
#region add
mani = new T_ManipulationLibrary();
mani.Id = model.Id;
mani.Name = model.Name;
mani.Code = model.Code;
mani.Description = model.Description;
mani.ManipulationTypeId = model.ManipulationTypeId;
mani.StandardTMU = Math.Round(model.StandardTMU, 2);
mani.UserTMU = Math.Round(model.UserTMU, 2);
if (model.Distance == 0)
{
mani.EquipmentTypeId = null;
mani.StopPrecisionId = null;
mani.ApplyPressureId = null;
mani.NatureCutsId = null;
mani.Distance = null;
}
else
{
mani.EquipmentTypeId = model.EquipmentTypeId;
mani.ApplyPressureId = model.ApplyPressureId;
mani.NatureCutsId = model.NatureCutsId;
mani.StopPrecisionId = model.StopPrecisionId;
mani.Distance = model.Distance;
}
mani.CreatedUser = model.ActionUser;
mani.CreatedDate = DateTime.Now;
if (TMUModel != null && TMUModel.Count > 0)
{
mani.T_ManipulationEquipment = new System.Collections.ObjectModel.Collection <T_ManipulationEquipment>();
foreach (var item in TMUModel)
{
maniEquipment = new T_ManipulationEquipment();
Parse.CopyObject(item, ref maniEquipment);
maniEquipment.T_ManipulationLibrary = mani;
maniEquipment.CreatedUser = mani.CreatedUser;
maniEquipment.CreatedDate = mani.CreatedDate;
mani.T_ManipulationEquipment.Add(maniEquipment);
}
}
if (fileModel != null && fileModel.Count > 0)
{
mani.T_ManipulationFile = new System.Collections.ObjectModel.Collection <T_ManipulationFile>();
foreach (var item in fileModel)
{
// add file
file = new T_File();
Parse.CopyObject(item, ref file);
file.T_ManipulationFile = new System.Collections.ObjectModel.Collection <T_ManipulationFile>();
file.CreatedUser = mani.CreatedUser;
file.CreatedDate = mani.CreatedDate;
// add commodity file
maniFile = new T_ManipulationFile();
maniFile.T_ManipulationLibrary = mani;
//maniFile.FileId = file.Id;
maniFile.CreatedUser = mani.CreatedUser;
maniFile.CreatedDate = mani.CreatedDate;
maniFile.T_File = file;
mani.T_ManipulationFile.Add(maniFile);
file.T_ManipulationFile.Add(maniFile);
db.T_File.Add(file);
}
}
db.T_ManipulationLibrary.Add(mani);
#endregion
}
else
{
#region Update
mani = db.T_ManipulationLibrary.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id);
if (mani == null)
{
result.IsSuccess = false;
result.Errors.Add(new Error()
{
MemberName = "Update ", Message = "Dữ liệu bạn đang thao tác đã bị xóa hoặc không tồn tại. Vui lòng kiểm tra lại !."
});
return(result);
}
else
{
mani.Name = model.Name;
mani.Code = model.Code;
mani.Description = model.Description;
mani.ManipulationTypeId = model.ManipulationTypeId;
mani.StandardTMU = Math.Round(model.StandardTMU, 2);
mani.UserTMU = Math.Round(model.UserTMU, 2);
//if (maniModel.Distance == null)
//{
// mani.EquipmentTypeId = null;
// mani.StopPrecisionId = null;
// mani.ApplyPressureId = null;
// mani.NatureCutsId = null;
// mani.Distance = null;
//}
//else
//{
mani.EquipmentTypeId = model.EquipmentTypeId;
mani.ApplyPressureId = model.ApplyPressureId;
mani.NatureCutsId = model.NatureCutsId;
mani.StopPrecisionId = model.StopPrecisionId;
mani.Distance = model.Distance;
//}
mani.UpdatedUser = model.ActionUser;
mani.UpdatedDate = DateTime.Now;
//remove old
if (model.isListMachineTMUChange)
{
var maniEquipOld = db.T_ManipulationEquipment.Where(x => !x.IsDeleted && x.ManipulationId == model.Id);
if (maniEquipOld != null && maniEquipOld.Count() > 0)
{
foreach (var item in maniEquipOld)
{
item.IsDeleted = true;
item.DeletedUser = mani.UpdatedUser;
item.DeletedDate = mani.UpdatedDate;
}
}
// add new
if (TMUModel != null && TMUModel.Count() > 0)
{
foreach (var item in TMUModel)
{
maniEquipment = new T_ManipulationEquipment();
Parse.CopyObject(item, ref maniEquipment);
maniEquipment.ManipulationId = mani.Id;
maniEquipment.CreatedUser = mani.UpdatedUser ?? 0;
maniEquipment.CreatedDate = mani.UpdatedDate ?? DateTime.Now;
db.T_ManipulationEquipment.Add(maniEquipment);
}
}
}
#region File
if (model.isListAttachFileChange)
{
var maniFiles = db.T_ManipulationFile.Where(x => !x.IsDeleted && x.ManipulationId == mani.Id);
if (maniFiles != null && maniFiles.Count() > 0)
{
foreach (var item in maniFiles)
{
item.IsDeleted = true;
item.DeletedUser = mani.UpdatedUser;
item.DeletedDate = mani.UpdatedDate;
}
}
if (fileModel != null && fileModel.Count > 0)
{
// mani.T_ManipulationFile = new System.Collections.ObjectModel.Collection<T_ManipulationFile>();
foreach (var item in fileModel)
{
// add file
file = new T_File();
Parse.CopyObject(item, ref file);
file.T_ManipulationFile = new System.Collections.ObjectModel.Collection <T_ManipulationFile>();
file.CreatedUser = mani.UpdatedUser ?? 0;
file.CreatedDate = mani.UpdatedDate ?? DateTime.Now;
// add commodity file
maniFile = new T_ManipulationFile();
// maniFile.T_ManipulationLibrary = mani;
maniFile.ManipulationId = model.Id;
maniFile.CreatedUser = mani.UpdatedUser ?? 0;
maniFile.CreatedDate = mani.UpdatedDate ?? DateTime.Now;
maniFile.T_File = file;
//mani.T_ManipulationFile.Add(maniFile);
file.T_ManipulationFile.Add(maniFile);
db.T_File.Add(file);
}
}
}
#endregion
#endregion
}
}
db.SaveChanges();
result.IsSuccess = true;
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public void ProcessRequest(HttpContext context)
{
String aspxUrl = context.Request.Path.Substring(0, context.Request.Path.LastIndexOf("/") + 1);
//文件保存目录路径
String savePath = "/FileSavePath/";
//文件保存目录URL
String saveUrl = "/FileSavePath/";
//定义允许上传的文件扩展名
Hashtable extTable = new Hashtable();
extTable.Add("flash", "swf,flv");
extTable.Add("media", "mp3,wmv,avi,rmvb");
extTable.Add("file", "doc,docx,xls,xlsx,ppt,pdf,txt,html,txt,zip,rar");
//最大文件大小
int maxSize = 2000000;
this.context = context;
HttpPostedFile imgFile = context.Request.Files["files"];
if (imgFile == null)
{
showError("请选择文件。");
}
String dirPath = context.Server.MapPath(savePath);
if (!Directory.Exists(dirPath))
{
showError("上传目录不存在。");
}
string dirName = "";
String fileName = imgFile.FileName;
String fileExt = Path.GetExtension(fileName).ToLower();
if (CheckFileExt(fileExt) != "")
{
dirName = CheckFileExt(fileExt);
}
if (String.IsNullOrEmpty(dirName))
{
dirName = "file";
}
if (!extTable.ContainsKey(dirName))
{
showError("目录名不正确。");
}
if (imgFile.InputStream == null || imgFile.InputStream.Length > maxSize)
{
showError("上传文件大小超过限制。");
}
if (String.IsNullOrEmpty(fileExt) || Array.IndexOf(((String)extTable[dirName]).Split(','), fileExt.Substring(1).ToLower()) == -1)
{
showError("上传文件扩展名是不允许的扩展名。\n只允许" + ((String)extTable[dirName]) + "格式。");
}
//创建文件夹
dirPath += dirName + "/";
saveUrl += dirName + "/";
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
String ymd = DateTime.Now.ToString("yyyyMMdd", DateTimeFormatInfo.InvariantInfo);
dirPath += ymd + "/";
saveUrl += ymd + "/";
if (!Directory.Exists(dirPath))
{
Directory.CreateDirectory(dirPath);
}
String newFileName = DateTime.Now.ToString("yyyyMMddHHmmss_ffff", DateTimeFormatInfo.InvariantInfo) + fileExt;
String filePath = dirPath + newFileName;
imgFile.SaveAs(filePath);
String fileUrl = saveUrl + newFileName;
//构造输出显示的model
//FileDescription fileDes = new FileDescription();
//fileDes.FileName = Path.GetFileNameWithoutExtension(fileName);
//fileDes.FileSize = (imgFile.ContentLength / 1024).ToString()+"KB";
//fileDes.FileTime = DateTime.Now.ToString();
//fileDes.FileSavePath =filePath;
//fileDes.FileExt = fileExt;
//构造插入内容
T_File model = new T_File();
model.FileId = bll.GetIdByTime(DateTime.Now.ToString("yyyyMMdd"));
model.FileName = fileName;
model.FilePath = fileUrl;
model.FileExt = fileExt;
model.FileSector = "";//(context.Session["model"] as T_InfoAdmin).InfoAdminSector;
model.FileSummary = context.Request["summary"];
model.FileTime = DateTime.Now.ToString();
model.FileSector = "liushangnan";
bll.Insert(model);
context.Response.Write("添加成功，请关闭此窗口~");
}
//插入
public int Insert(T_File file)
{
return(dal.Insert(file));
}
