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()); }