/// <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());
}
/// <summary>
/// 加载默认数据库基本信息
/// </summary>
protected void loaddefaultdb()
{
DataTable dt = new T_EnterpriseDB().GetDefault();
string td = string.Empty;
if (dt != null && dt.Rows.Count == 1)
{
DataRow row = dt.Rows[0];
if (Convert.ToInt32(row["EnterpriseNum"]) < Convert.ToInt32(row["MaxNum"]))
{
td = string.Format("<td><span style='color:green;'>您创建的企业数据表将放在[{0}]库中,数据库中当前企业数量：{1},最大数量：{2}。</span></td>", row["DBName"], row["EnterpriseNum"], row["MaxNum"]);
}
else
{
td = "<td><span style='color:red;'>目前默认数据库已满，请设更改或创建默认数据库后再操作！</span></td>";
btnSubmit.Enabled = false;
}
}
else
{
td = "<td><span style='color:red;'>目前没有默认数据库，您无法创建企业，请设置默认数据库后再操作！</span></td>";
btnSubmit.Enabled = false;
}
string msg = string.Format("<td style='height:50px;' class='title'>提示：</td>{0}", td);
ltTips.Text = msg;
}
/// <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>
/// <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>
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");
}
