/// <summary>
/// 修改目录
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public BaseResopne <string> UpdateResourceMenu(AcademicResources_Menu Param)
{
BaseResopne <string> result = new BaseResopne <string>();
try
{
//获取当前登录人
AccountProvider _AccountProvider = new AccountProvider();
var user = _AccountProvider.GetCurrentUser();
if (user == null)
{
result.IsSuccess = false;
result.Error = "获取当前用户信息失败";
return(result);
}
Param.lastModifyTime = DateTime.Now;
Param.lastModifyUsrID = user.id;
string sql = @"update de2_aresource_menu set title=@title,parentID=@parentID,sourceTypeID=@sourceTypeID,author=@author,lastModifyUsrID=@lastModifyUsrID,lastModifyTime=@lastModifyTime";
//执行sql
MySqlClient _Client = new MySqlClient();
var ResourceID = _Client.Inster(sql
, new MySqlParameter("@title", Param.title)
, new MySqlParameter("@parentID", Param.parentID)
, new MySqlParameter("@sourceTypeID", Param.sourceTypeID)
, new MySqlParameter("@author", Param.author)
, new MySqlParameter("@lastModifyUsrID", Param.lastModifyUsrID)
, new MySqlParameter("@lastModifyTime", Param.lastModifyTime));
//判断文件路径是否为空
if (!string.IsNullOrEmpty(Param.resourceFile))
{
AcademicResources_File _AcademicResources_File = new AcademicResources_File();
_AcademicResources_File.lastModifyTime = DateTime.Now;
_AcademicResources_File.lastModifyUsrID = user.id;
_AcademicResources_File.parentID = Param.id;
_AcademicResources_File.sourceTypeID = Param.sourceTypeID;
_AcademicResources_File.targetFileUrl = Param.resourceFile;
_AcademicResources_File.title = Param.title;
UpdateResourcesFile(_AcademicResources_File);
}
else
{
result.IsSuccess = false;
result.Error = "资源文件路径为空";
return(result);
}
result.IsSuccess = true;
}
catch (Exception ex)
{
LogFactory _LogFactory = new LogFactory(this.GetType());
_LogFactory.CreateLog(LogType.Error, "修改目录", "UpdateResourceMenu", ex);
result.IsSuccess = false;
}
return(result);
}
/// <summary>
/// 新建工作计划
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public bool AddWorkPlan(WorkPlan Data)
{
try
{
AccountProvider _AccountProvider = new AccountProvider();
var user = _AccountProvider.GetCurrentUser();
string sql = @"insert into de2_workplan (`year`,startTime,endTime,name,content,scale,addressProvinceID,addressProvince,addressCityID,addressCity,address,createTime,lastModifyTime,createUserID,workPlanTypeID)
values (@`year`,@startTime,@endTime,@name,@content,@scale,@addressProvinceID,@addressProvince,@addressCityID,@addressCity,@address,@createTime,@lastModifyTime,@createUserID,@workPlanTypeID)";
Data.createTime = DateTime.Now;
Data.lastModifyTime = DateTime.Now;
if (user == null)
{
Data.createUserID = user.id;
}
MySqlClient _Client = new MySqlClient();
Data.id = (int)_Client.Inster(sql,
new MySqlParameter("@`year`", Data.year)
, new MySqlParameter("@startTime", Data.startTime)
, new MySqlParameter("@endTime", Data.endTime)
, new MySqlParameter("@name", Data.name)
, new MySqlParameter("@content", Data.content)
, new MySqlParameter("@scale", Data.scale)
, new MySqlParameter("@addressProvinceID", Data.addressProvinceID)
, new MySqlParameter("@addressProvince", Data.addressProvince)
, new MySqlParameter("@addressCityID", Data.addressCityID)
, new MySqlParameter("@addressCity", Data.addressCity)
, new MySqlParameter("@address", Data.address)
, new MySqlParameter("@createTime", Data.createTime)
, new MySqlParameter("@lastModifyTime", Data.lastModifyTime)
, new MySqlParameter("@createUserID", Data.createUserID)
, new MySqlParameter("@workPlanTypeID", Data.workPlanTypeID));
SaveWorkPlanContacts(Data);
return(true);
}
catch (Exception ex)
{
LogFactory _LogFactory = new LogFactory(this.GetType());
_LogFactory.CreateLog(LogType.Error, "新建工作计划", "AddWorkPlan", ex);
return(false);
}
}
/// <summary>
/// 保存学术资源信息
/// </summary>
/// <param name="Data"></param>
/// <returns></returns>
public BaseResopne <Int32> AddAcademicResources(AcademicResources Data)
{
BaseResopne <Int32> result = new BaseResopne <Int32>();
try
{
//获取当前登录人
AccountProvider _AccountProvider = new AccountProvider();
var user = _AccountProvider.GetCurrentUser();
if (user == null)
{
result.IsSuccess = false;
result.Error = "获取当前用户信息失败";
return(result);
}
Data.createUserID = user.id;
Data.createTime = DateTime.Now;
Data.lastModifyTime = DateTime.Now;
Data.lastModifyUsrID = user.id;
//生成sql
StringBuilder sql = new StringBuilder();
sql.AppendLine(@"insert into de2_aresource (`name`,parentID,sourceTypeID,createTime,createUserID,isChild,author,isPublish,`year`,periodNumber,lastModifyTime,lastModifyUsrID,isMenu) values(@`name`,@parentID,@sourceTypeID,@createTime,@createUserID,@isChild,@author,@isPublish,@`year`,@periodNumber,@lastModifyTime,@lastModifyUsrID,@isMenu)");
//执行sql语句
MySqlClient _Client = new MySqlClient();
var ResourceID = _Client.Inster(sql.ToString()
, new MySqlParameter("@`name`", Data.name)
, new MySqlParameter("@parentID", Data.parentID)
, new MySqlParameter("@sourceTypeID", Data.sourceTypeID)
, new MySqlParameter("@createTime", Data.createTime)
, new MySqlParameter("@createUserID", Data.createUserID)
, new MySqlParameter("@isChild", Data.isChild)
, new MySqlParameter("@author", Data.author)
, new MySqlParameter("@isPublish", Data.isPublish)
, new MySqlParameter("@`year`", Data.year)
, new MySqlParameter("@periodNumber", Data.periodNumber)
, new MySqlParameter("@lastModifyTime", Data.lastModifyTime)
, new MySqlParameter("@lastModifyUsrID", Data.lastModifyUsrID)
, new MySqlParameter("@isMenu", Data.isMenu));
result.Data = Convert.ToInt32(ResourceID);
//判断文件路径是否为空
if (!string.IsNullOrEmpty(Data.resourceFile))
{
AcademicResources_File _AcademicResources_File = new AcademicResources_File();
_AcademicResources_File.lastModifyTime = DateTime.Now;
_AcademicResources_File.lastModifyUsrID = user.id;
_AcademicResources_File.createTime = DateTime.Now;
_AcademicResources_File.createUserID = user.id;
_AcademicResources_File.parentID = Convert.ToInt32(ResourceID);
_AcademicResources_File.sourceTypeID = Data.sourceTypeID;
_AcademicResources_File.targetFileUrl = Data.resourceFile;
_AcademicResources_File.title = Data.name;
AddResourcesFile(_AcademicResources_File);
}
result.IsSuccess = true;
}
catch (Exception ex)
{
LogFactory _LogFactory = new LogFactory(this.GetType());
_LogFactory.CreateLog(LogType.Error, "保存学术资源信息", "AddAcademicResources", ex);
result.IsSuccess = false;
}
return(result);
}