/// <summary>
/// 视图类转实体类
/// </summary>
/// <param name="view">视图类</param>
/// <returns>实体类</returns>
private Model.TableModel.Dms_file View2Model(ModelView.DmsFileView view)
{
Model.TableModel.Dms_file model = new Model.TableModel.Dms_file();
if (string.IsNullOrEmpty(view.id))
{
model.id = Common.Md5Operate.CreateGuidId();
}
else
{
model.id = view.id;
}
GlobalDataCtrl globalDataCtrl = new GlobalDataCtrl();
model.file_no = string.IsNullOrEmpty(view.file_no) ? globalDataCtrl.GetNextNoByTblName("mpo_item") : view.file_no;
model.file_name = System.IO.Path.GetFileNameWithoutExtension(view.file_info);
model.file_extension = System.IO.Path.GetExtension(view.file_info);
model.file_type_no = string.IsNullOrEmpty(view.file_type_no) ? "01" : view.file_type_no;
model.file_type_name = view.file_type_name;
model.file_version = string.IsNullOrEmpty(view.file_version) ? "1" : view.file_version;
model.file_desc = view.file_desc;
model.eqm_no = string.IsNullOrEmpty(view.eqm_no) ? "EqmNo" : view.eqm_no;
model.file_md5 = string.IsNullOrEmpty(view.file_md5) ? "FileMd5" : view.file_md5;
model.is_passed = string.IsNullOrEmpty(view.is_passed) ? false : (view.is_passed == "是"?true:false);
model.file_status = string.IsNullOrEmpty(view.file_status) ? "未确认" : view.file_status;
model.ralate_file_name = view.ralate_file_name;
DateTime tmpDt = DateTime.Now;
model.valid_date_start = string.IsNullOrEmpty(view.valid_date_start) ? (DateTime?)null : (DateTime.TryParse(view.valid_date_start, out tmpDt) ? tmpDt : (DateTime?)null);
model.valid_date_end = string.IsNullOrEmpty(view.valid_date_end) ? (DateTime?)null : (DateTime.TryParse(view.valid_date_end, out tmpDt) ? tmpDt : (DateTime?)null);
return(model);
}
public void FileShow(string fileName, string fileNo)
{
if (string.IsNullOrEmpty(fileName) || string.IsNullOrEmpty(fileNo))
{
return;
}
string path = _localDirectory + @"\current\" + fileName;
Ctrl.DbConStrFactory conFactory = Ctrl.DbConStrFactory.CreateInstance();
Ctrl.DataLoadCtrl dataLoadCtrl = DataLoadCtrl.CreateInstance(conFactory.GetSqlConStr("defaultSqlDb"), conFactory.GetAccessConStr("defaultAccessDb"));
Model.TableModel.Dms_file model = dataLoadCtrl.GetDmsFile(fileNo);
if (model == null)
{
return;
}
if (!System.IO.File.Exists(path))
{
string ftpFileName = model.file_md5 + "_" + fileName;
string newPath = _localDirectory + @"\current\" + ftpFileName;
if (!System.IO.File.Exists(newPath))
{
Common.FTPStreamHelper.DownloadFile(_localDirectory + @"\current", "current", ftpFileName, _host, _writeUser, _writePwd);
}
System.IO.File.Copy(newPath, path, true);
System.IO.File.Delete(newPath);
}
Process proc = new Process();
proc.StartInfo.FileName = _localDirectory + @"\current\" + fileName;
proc.StartInfo.UseShellExecute = true;
proc.Start();
}
/// <summary>
/// 数据更新
/// </summary>
/// <param name="newValue">更新后对象</param>
/// <returns>影响记录条数</returns>
public int Update(ModelView.DmsFileView newValue)
{
Model.TableModel.Dms_file model = View2Model(newValue);
List <Model.TableModel.Dms_file> modelList = new List <Model.TableModel.Dms_file>();
modelList.Add(model);
return(DbEngine.QueryInt <Model.TableModel.Dms_file>("update", modelList));
}
/// <summary>
/// 更新操作
/// </summary>
/// <param name="listNewValue">更新后的视图模板类的集合</param>
/// <returns>影响记录条数</returns>
public int Update(List <ModelView.DmsFileView> listNewValue)
{
List <Model.TableModel.Dms_file> modelList = new List <Model.TableModel.Dms_file>();
foreach (ModelView.DmsFileView item in listNewValue)
{
Model.TableModel.Dms_file model = View2Model(item);
modelList.Add(model);
}
return(DbEngine.QueryInt <Model.TableModel.Dms_file>("update", modelList));
}
/// <summary>
/// 删除操作
/// </summary>
/// <param name="oldValues">要删除的多个值</param>
/// <returns>影响记录条数</returns>
public int Delete(List <ModelView.DmsFileView> oldValues)
{
List <Model.TableModel.Dms_file> modelList = new List <Model.TableModel.Dms_file>();
foreach (ModelView.DmsFileView item in oldValues)
{
Model.TableModel.Dms_file model = View2Model(item);
modelList.Add(model);
}
return(DbEngine.QueryInt <Model.TableModel.Dms_file>("Delete", modelList));
}
/// <summary>
/// 数据插入
/// </summary>
/// <param name="newValue">新插入的值</param>
/// <returns>影响记录条数</returns>
public int Insert(ModelView.DmsFileView newValue)
{
try
{
Model.TableModel.Dms_file model = View2Model(newValue);
Ctrl.Bll.ApoActBll apoActBll = new Bll.ApoActBll();
apoActBll.CreateApprove(Model2View(model), newValue.login_user_no);
List <Model.TableModel.Dms_file> modelList = new List <Model.TableModel.Dms_file>();
modelList.Add(model);
return(DbEngine.QueryInt <Model.TableModel.Dms_file>("Insert", modelList));
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 实体类转视图类
/// </summary>
/// <param name="model">实体类</param>
/// <returns>视图类</returns>
private ModelView.DmsFileView Model2View(Model.TableModel.Dms_file model)
{
ModelView.DmsFileView view = new ModelView.DmsFileView();
view.id = model.id;
view.file_no = model.file_no;
view.file_name = model.file_name;
view.file_extension = model.file_extension;
view.file_info = model.file_name + model.file_extension;
view.file_type_no = model.file_type_no;
view.file_type_name = model.file_type_name;
view.file_version = model.file_version;
view.file_desc = model.file_desc;
view.eqm_no = model.eqm_no;
view.file_md5 = model.file_md5;
view.is_passed = model.is_passed?"是":"否";
view.file_status = model.file_status;
view.ralate_file_name = model.ralate_file_name;
view.valid_date_start = model.valid_date_start.HasValue ? ((DateTime)model.valid_date_start).ToString("yyyy-MM-dd") : string.Empty;
view.valid_date_end = model.valid_date_end.HasValue ? ((DateTime)model.valid_date_end).ToString("yyyy-MM-dd HH:mm:ss.fff") : string.Empty;
return(view);
}
