public JsonResult SaveReportComponent(ReportComponentInfo info)
{
ResultModel <ReportComponentInfo> result = new ResultModel <ReportComponentInfo>();
if (CheckSession(false) == false)
{
return(Json(ResultModelBase.CreateTimeoutModel(), JsonRequestBehavior.AllowGet));
}
if (CheckSessionID() == false)
{
return(Json(ResultModelBase.CreateLogoutModel(), JsonRequestBehavior.AllowGet));
}
try
{
List <UploadFileInfo> fileReportComponent = GetUploadFilesInSession();
if (fileReportComponent != null)
{
foreach (UploadFileInfo file in fileReportComponent)
{
file.FileContent = ParseBase64String(file.FileContent);
}
}
info = dispatchManager.SaveReportComponent(info, fileReportComponent);
result.Data = info;
}
catch (Exception ex)
{
NLog.LogManager.GetCurrentClassLogger().Error(ex, ex.Message);
result.SetFailed(ResultCodes.SystemError, ControlManager.GetSettingInfo().ErrorMessage);
}
return(JsonResult(result));
}
public int AddReportComponent(ReportComponentInfo info)
{
sqlStr = "INSERT INTO tblReportComponent(DispatchReportID,ComponentID,NewSerialCode,OldSerialCode) " +
" VALUES(@DispatchReportID,@ComponentID,@NewSerialCode,@OldSerialCode)" +
" SELECT @@IDENTITY";
using (SqlCommand command = ConnectionUtil.GetCommand(sqlStr))
{
command.Parameters.Add("@DispatchReportID", SqlDbType.Int).Value = info.DispatchReportID;
command.Parameters.Add("@ComponentID", SqlDbType.Int).Value = info.NewComponent.Component.ID;
command.Parameters.Add("@NewSerialCode", SqlDbType.NVarChar).Value = info.NewComponent.SerialCode;
command.Parameters.Add("@OldSerialCode", SqlDbType.NVarChar).Value = info.OldComponent.SerialCode;
info.ID = SQLUtil.ConvertInt(command.ExecuteScalar());
}
return(info.ID);
}
public ReportComponentInfo SaveReportComponent(ReportComponentInfo info, List <UploadFileInfo> fileReportComponent)
{
info.ID = this.dispatchReportDao.AddReportComponent(info);
if (fileReportComponent != null)
{
foreach (UploadFileInfo file in fileReportComponent)
{
file.ObjectID = info.ID;
file.ObjectTypeId = ObjectTypes.ReportAccessory;
file.ID = this.fileManager.SaveUploadFile(file).ID;
file.FileContent = "";
}
info.FileInfos = fileReportComponent;
}
return(info);
}
