/// <summary> /// 获取单个对象 /// </summary> private void GetModel() { int dbid; if (!int.TryParse(nv["dbid"], out dbid)) { HttpContext.Current.Response.Write("0"); return; } E_EnterpriseDB data = new E_EnterpriseDB(); data.EnterpriseDBID = dbid; data = new T_EnterpriseDB().GetModel(data); if (data == null) { data = new E_EnterpriseDB(); data.EnterpriseDBID = 0; } JsonObjectCollection colDR = new JsonObjectCollection(); colDR.Add(new JsonStringValue("id", data.EnterpriseDBID.ToString())); colDR.Add(new JsonStringValue("maxnum", data.MaxNum.ToString())); HttpContext.Current.Response.Write(colDR.ToString()); }
private void DeleteDB() { int dbid; if (!int.TryParse(nv["dbid"], out dbid)) { HttpContext.Current.Response.Write("0"); return; } E_EnterpriseDB data = new E_EnterpriseDB(); }
/// <summary> /// 数据绑定 /// </summary> protected void databind() { E_EnterpriseDB data = new E_EnterpriseDB(); data.EnterpriseDBID = dbid; data = new T_EnterpriseDB().GetModel(data); if (data == null) { Jscript.AlertAndRedirect(this, "没有找到对象!", "List.aspx"); return; } txtDBName.Text = data.DBName; txtMaxNum.Text = data.MaxNum.ToString(); }
/// <summary> /// 获取下一个数据库名称 /// </summary> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-04</remarks> public string NextName() { string DBName = string.Empty; E_EnterpriseDB data = SelectLast(); if (data == null) { DBName = "EP_00001"; } else { int num = Convert.ToInt32(data.DBName.Substring(3)); DBName = string.Format("EP_{0:d5}", num + 1); } return(DBName); }
/// <summary> /// 点击确定按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { //获取界面数据 string name = txtDBName.Text.Trim(); //获取界面数据 int num; if (!int.TryParse(txtMaxNum.Text.Trim(), out num)) { Jscript.ShowMsg("参数错误", this); return; } E_EnterpriseDB data = new E_EnterpriseDB(); data.DBName = name; data.MaxNum = num; bool flag = false; if (type == "update") { data.EnterpriseDBID = dbid; flag = new T_EnterpriseDB().UpdateMaxNum(data); } else { //获取数据库文件存放位置 data.Path = Config.GetAppSettings("DBFilePath"); if (string.IsNullOrEmpty(data.Path)) { Jscript.ShowMsg("配置文件错误,没有找到DBFilePath", this); return; } flag = new T_EnterpriseDB().Add(data); } if (flag) { Jscript.AlertAndRedirect(this, "操作成功", "list.aspx"); } else { Jscript.ShowMsg("操作失败", this); } }
/// <summary> /// 设置默认数据库 /// </summary> private void DefaultFlag() { int dbid; if (!int.TryParse(nv["dbid"], out dbid)) { HttpContext.Current.Response.Write("0"); return; } E_EnterpriseDB data = new E_EnterpriseDB(); data.EnterpriseDBID = dbid; bool flag = new T_EnterpriseDB().UpdateDefaultFlag(data); HttpContext.Current.Response.Write(flag ? "1" : "0"); }
/// <summary> /// 数据绑定 /// </summary> public void databind() { E_EnterpriseDB data = new E_EnterpriseDB(); data.Page = new MLMGC.DataEntity.E_Page(); data.Page.PageIndex = pageIndex; data.Page.PageSize = pageSize; rpList.DataSource = new T_EnterpriseDB().SelectList(data); rpList.DataBind(); //设置分页样式 pageList1.PageSize = pageSize; pageList1.CurrentPageIndex = pageIndex; pageList1.RecordCount = data.Page.TotalCount; pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount); pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " "; }
/// <summary> /// 修改数据库最大容量 /// </summary> private void UpdateMaxNum() { int dbid, maxnum; if (!int.TryParse(nv["dbid"], out dbid) || !int.TryParse(nv["maxnum"], out maxnum)) { HttpContext.Current.Response.Write("0"); return; } E_EnterpriseDB data = new E_EnterpriseDB(); data.EnterpriseDBID = dbid; data.MaxNum = maxnum; bool flag = new T_EnterpriseDB().UpdateMaxNum(data); HttpContext.Current.Response.Write(flag ? "1" : "0"); }
/// <summary> /// 修改默认数据库 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-03</remarks> public bool UpdateDefaultFlag(E_EnterpriseDB data) { return(dal.UpdateDefaultFlag(data)); }
/// <summary> /// 后台管理员查看数据库列表 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-03</remarks> public DataTable SelectList(E_EnterpriseDB data) { return(dal.SelectList(data)); }
/// <summary> /// 获取单个对象 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-03</remarks> public E_EnterpriseDB GetModel(E_EnterpriseDB data) { return(dal.GetModel(data)); }
/// <summary> /// 后台管理员删除数据库 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-03</remarks> public bool Delete(E_EnterpriseDB data) { return(dal.Delete(data)); }
/// <summary> /// 后台管理员添加数据库 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-03</remarks> public bool Add(E_EnterpriseDB data) { return(dal.Add(data)); }
/// <summary> /// 修改数据库容量(最大容量) /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-05-07</remarks> public bool UpdateMaxNum(E_EnterpriseDB data) { return(dal.UpdateMaxNum(data)); }