public DataTable GetList(PagerQueryParam Pager, out int total, int id)
{
try
{
DBResourceUpload db = new DBResourceUpload();
DataTable dt = db.GetList(Pager, out total);
if (dt == null)
{
return(null);
}
DBResourceDetail dbResource = new DBResourceDetail();
ResourceDetailEntity dbEntity = dbResource.GetInfo(id);
DataTable dtNew = new DataTable();
dtNew.Columns.Add("id", typeof(int));
dtNew.Columns.Add("url", typeof(string));
dtNew.Columns.Add("name", typeof(string));
foreach (DataRow dataRow in dt.Rows)
{
dtNew.Rows.Add(new object[] { dataRow["id"], dbEntity.Url + dataRow["files_dir"] + "/" + dataRow["files_name"], dataRow["files_name"] });
}
return(dtNew);
}
catch (Exception e)
{
throw;
}
}
private string UpdateSql(ResourceDetailEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" UPDATE dbo.t_resource_detail SET");
if (model.Name.Length > 0)
{
strSql.Append(" name = '" + model.Name + "',");
}
if (model.Memo.Length > 0)
{
strSql.Append(" memo = '" + model.Memo + "',");
}
if (model.Type != null && model.Type.Id > 0)
{
strSql.Append(" type_id = '" + model.Type.Id + "',");
strSql.Append(" type = '" + model.Type.Name + "',");
}
if (model.UploadPeople.Length > 0)
{
strSql.Append(" upload_people = '" + model.UploadPeople + "',");
}
if (model.update_user != null)
{
strSql.Append(" update_people = '" + model.update_user.Name + "',");
}
strSql.Append(" update_time = getdate()");
strSql.Append(" where id = '" + model.Id + "'");
return(strSql.ToString());
}
/// <summary>
/// 更新一条是数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
private int Update(ResourceDetailEntity info)
{
try
{
//先删除原来的主表数据
ResourceDetailManager bll = new ResourceDetailManager();
bll.Delete(info.Id);
//增加新的数据到主表
//bll.Add(info);
//修改剩余的原来的数据
ResourceUploadBussiness resourceUpload = new ResourceUploadBussiness();
DataTable dtUpload = resourceUpload.GetInfosByDetailId(info.Id);
bll.DeleteUpload(0, info.Id);
ResourceDetailUploadEntity detailEntity = new ResourceDetailUploadEntity();
int id = bll.Add(info);
if (dtUpload != null)
{
foreach (DataRow dataRow in dtUpload.Rows)
{
detailEntity.Files_name = CommonDBCheck.ToString(dataRow["files_name"]);
detailEntity.FilesDir = CommonDBCheck.ToString(dataRow["files_dir"]);
detailEntity.Resource_detail_id = id;
resourceUpload.Add(detailEntity);
}
}
return(id);
}
catch (Exception e)
{
throw;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
private int Add(ResourceDetailEntity info)
{
try
{
ResourceDetailManager detailManager = new ResourceDetailManager();
return(detailManager.Add(info));
}
catch (Exception e)
{
throw;
}
}
public void Update(ResourceDetailEntity model)
{
try
{
DBResourceDetail db = new DBResourceDetail();
db.Update(model);
}
catch (Exception e)
{
throw;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model"></param>
public int Add(ResourceDetailEntity model)
{
try
{
DBResourceDetail db = new DBResourceDetail();
return(db.Add(model));
}
catch (Exception e)
{
throw;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ResourceDetailEntity model)
{
try
{
string strSql = UpdateSql(model);
ExecuteNonQuery(strSql.ToString());
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ResourceDetailEntity model)
{
try
{
string strSql = AddSql(model);
return(CommonDBCheck.ToInt(ExecuteScalar(strSql)));
}
catch (Exception e)
{
throw e;
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
string mode = context.Request["mode"].ToLower();
ResourceTypeManager typeManager = new ResourceTypeManager();
//ResourceDetailEntity entity=new ResourceDetailEntity();
string dir = context.Request["dir"];
string name = context.Request["name"];
string peo = context.Request["peo"];
string memo = context.Request["memo"];
string id = context.Request["id"];
ResourceDetailEntity entity = new ResourceDetailEntity();
entity.Memo = memo;
entity.Name = name;
entity.Type = new SpareResourceTypeEntity()
{
Id = CommonDBCheck.ToInt(dir),
Name = typeManager.GetInfo(CommonDBCheck.ToInt(dir)).Name,
Directory = typeManager.GetInfo(CommonDBCheck.ToInt(dir)).Directory
};
entity.UploadPeople = peo;
entity.Url = ConfigurationSettings.AppSettings["UploadFilePath"];
entity.insert_user = entity.update_user = context.Session["user"] as UserEntity;
switch (mode)
{
case "add":
context.Response.Write(Add(entity));
break;
case "update":
entity.Id = CommonDBCheck.ToInt(id);
context.Response.Write(Update(entity));
break;
}
}
catch (Exception e)
{
context.Response.Write("error");
}
}
private ResourceDetailEntity ReadBind(IDataReader dataReader)
{
ResourceDetailEntity model = new ResourceDetailEntity();
model.Id = CommonDBCheck.ToInt(dataReader["id"]);
model.Name = CommonDBCheck.ToString(dataReader["name"]);
if (model.Type == null)
{
model.Type = new SpareResourceTypeEntity();
}
model.Type.Id = CommonDBCheck.ToInt(dataReader["type_id"]);
model.Type.Name = CommonDBCheck.ToString(dataReader["type"]);
model.Url = CommonDBCheck.ToString(dataReader["url"]);
model.Memo = CommonDBCheck.ToString(dataReader["memo"]);
model.UploadPeople = CommonDBCheck.ToString(dataReader["upload_people"]);
return(model);
}
/// <summary>
/// 通过ID取得数据信息
/// </summary>
/// <param name="id"></param>
public ResourceDetailEntity GetInfo(int id)
{
ResourceDetailEntity model = new ResourceDetailEntity();
try
{
string strSql = GetInfoSql(id);
using (IDataReader dataReader = ExecuteReader(strSql))
{
if (dataReader.Read())
{
model = ReadBind(dataReader);
}
}
return(model);
}
catch (Exception e)
{
throw e;
}
}
private string AddSql(ResourceDetailEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into dbo.t_resource_detail(");
strSql.Append("name,");
strSql.Append("type,");
strSql.Append("type_id,");
strSql.Append("url,");
strSql.Append("memo,");
strSql.Append("insert_people,");
strSql.Append("upload_people,");
strSql.Append("insert_time");
strSql.Append(")values(");
strSql.Append("'" + model.Name + "',");
if (model.Type != null)
{
strSql.Append("'" + model.Type.Name + "',");
strSql.Append("'" + model.Type.Id + "',");
}
strSql.Append("'" + model.Url + "',");
strSql.Append("'" + model.Memo + "',");
if (model.insert_user != null)
{
strSql.Append("'" + model.insert_user.Name + "',");
}
else
{
strSql.Append("NULL,");
}
strSql.Append("'" + model.UploadPeople + "',");
strSql.Append("getdate())");
strSql.Append("SELECT @@IDENTITY");
return(strSql.ToString());
}
