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