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