/// <summary>
/// 删除文件
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DelResurces(int id)
{
BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("Resources", "ltrim(rtrim(ResID))");
cl_h_info.AddRecord(id);
cl_h_info.DeletedIntoLogs(BLL.CommonClass.ChangeCategory.company18, id.ToString(), BLL.CommonClass.ENUM_USERTYPE.objecttype10);
ResourcesDAL dao = new ResourcesDAL();
return(dao.DelResurces(id));
}
/// <summary>
/// This procedure is used for the update the resource key value.
/// </summary>
/// <param name="i_sConnectionString">DB Connection string</param>
/// <param name="m_objResourceDTO">Object of Resource DTO</param>
/// <returns>If saves return true otherwise false</returns>
public bool SaveDetails(string i_sConnectionString, ResourcesDTO m_objResourcesDTO)
{
try
{
using (var objResourcesDAL = new ResourcesDAL())
{
return(objResourcesDAL.Save(i_sConnectionString, m_objResourcesDTO));
}
}
catch (Exception exp)
{
throw exp;
}
}
/// <summary>
/// 修改上传资料
/// </summary>
/// <param name="resource"></param>
/// <returns></returns>
public bool UpdateResource(ResourceModel resource)
{
BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("Resources", "ltrim(rtrim(ResID))");
cl_h_info.AddRecord(resource.ResID);
ResourcesDAL dao = new ResourcesDAL();
bool boo = dao.UpdateResource(resource);
cl_h_info.AddRecord(resource.ResID);
cl_h_info.ModifiedIntoLogs(BLL.CommonClass.ChangeCategory.company18, resource.ResID.ToString(), BLL.CommonClass.ENUM_USERTYPE.objecttype10);
return(boo);
}
/// <summary>
/// This method is used for fetching details of resource key.
/// </summary>
/// <param name="i_sConnectionString">DB COnnection string</param>
/// <param name="inp_sResourceKey">Resource Key</param>
/// <returns>Object of ResourceDTO</returns>
public ResourcesDTO GetDetails(string i_sConnectionString, string inp_sResourceKey)
{
try
{
using (var objResourcesDAL = new ResourcesDAL())
{
return(objResourcesDAL.GetDetails(i_sConnectionString, inp_sResourceKey));
}
}
catch (Exception exp)
{
throw exp;
}
}
public void GetAllResources(string i_sConnectionString, out Dictionary <string, string> o_lstResources)
{
o_lstResources = new Dictionary <string, string>();
//InsiderTradingDAL.ResourcesDAL objResourcesDAL = new ResourcesDAL();
try
{
using (var objResourcesDAL = new ResourcesDAL())
{
objResourcesDAL.GetAllResources(i_sConnectionString, out o_lstResources);
}
}
catch (Exception exp)
{
throw exp;
}
}
/// <summary>
/// 更新指定的下载次数
/// </summary>
/// <param name="resID">资源ID</param>
/// <returns>返回更新指定的下载次数所影响的行数</returns>
public static int UpdResourcesResTimesByResID(int resID)
{
return(ResourcesDAL.UpdResourcesResTimesByResID(resID));
}
/// <summary>
/// 查询指定条件的Resources信息
/// </summary>
/// <param name="columnNames">列名</param>
/// <param name="conditions">条件</param>
/// <returns>返回DataTable对象</returns>
public static DataTable GetResourcesInfoByConditions(string columnNames, string conditions)
{
return(ResourcesDAL.GetResourcesInfoByConditions(columnNames, conditions));
}
public int updresources(string resid)
{
ResourcesDAL rd = new ResourcesDAL();
return(rd.updresources(resid));
}
/// <summary>
/// 检查文件名称是否存在 DS2012
/// </summary>
/// <param name="ResName"></param>
/// <returns></returns>
public bool CheckReourceResname(string ResName)
{
ResourcesDAL dao = new ResourcesDAL();
return(dao.CheckReourceResname(ResName));
}
/// <summary>
/// 插入上传文件
/// </summary>
/// <param name="resource"></param>
/// <returns></returns>
public bool InsertResource(ResourceModel resource)
{
ResourcesDAL dao = new ResourcesDAL();
return(dao.InsertResource(resource));
}
/// <summary>
/// 查询出老的文件名
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public string GetOldfilename(int id)
{
ResourcesDAL dao = new ResourcesDAL();
return(dao.GetOldfilename(id));
}
/// <summary>
/// 检查上传的文件名字是否存在
/// </summary>
/// <param name="FileName"></param>
/// <returns></returns>
public bool CheckFileName(string FileName)
{
ResourcesDAL dao = new ResourcesDAL();
return(dao.CheckFileName(FileName));
}
/// <summary>
/// 根据条件查出数据 返回一个结果集 （导出excel）
/// </summary>
/// <param name="conction"></param>
/// <returns></returns>
public DataTable GetTableForExcel(string conction)
{
ResourcesDAL dao = new ResourcesDAL();
return(dao.GetTableForExcel(conction));
}
/// <summary>
/// 根据id查询Resource
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ResourceModel GetResourcesById(int id)
{
ResourcesDAL dao = new ResourcesDAL();
return(dao.GetResourcesById(id));
}
/// <summary>
/// 修改下载次数
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool UpdateResutcesResTime(int id)
{
ResourcesDAL dao = new ResourcesDAL();
return(dao.UpdateResutcesResTime(id));
}
