public override UsualBookTableModel[] GetChilds(string parentpk, DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("select  ");
     builder.Append(" * ");
     builder.Append(" from " + base.TableName + " ");
     if (parentpk != "")
     {
         builder.Append(" where FatherPK='" + parentpk + "'");
     }
     DataSet set = dbo.BackDataSet(builder.ToString(), null);
     if (set.Tables[0].Rows.Count <= 0)
     {
         return null;
     }
     UsualBookTableModel[] modelArray = new UsualBookTableModel[set.Tables[0].Rows.Count];
     for (int i = 0; i < set.Tables[0].Rows.Count; i++)
     {
         modelArray[i] = new UsualBookTableModel();
         modelArray[i] = this.Getmm(set.Tables[0].Rows[i], true, dbo);
     }
     return modelArray;
 }
 public void addupdate()
 {
     try
     {
         this.dbo = new DB_OPT();
         this.dbo.Open();
         if ((this.txtname.Text.Trim() == "") || (this.txtBH.Text.Trim() == ""))
         {
             Const.ShowMessage("带*的数据必须填写!", this.Page);
         }
         else
         {
             this.ubtm = new UsualBookTableDal();
             this.um = new UsualBookTableModel();
             this.ubtm.FatherPK = this.FatherPk.Value.Trim();
             this.ubtm.TableName = base.Request.QueryString["tn"].ToString().Trim();
             if (this.ubtm.FatherPK != "")
             {
                 this.ubtm.PK = this.ubtm.FatherPK.Trim();
                 this.um = this.ubtm.GetModel(false, this.dbo);
                 if (this.um.IsHasBaby == "0")
                 {
                     this.ubtm.TableName = base.Request.QueryString["tn"].ToString();
                     this.ubtm.UpdateHasBaby(this.dbo);
                 }
                 this.ubtm.PKPath = this.ubtm.PKPath + this.ubtm.PK + "|";
                 this.ubtm.Grade = this.um.Grade;
             }
             this.ubtm.BH = this.txtBH.Text.Trim();
             this.ubtm.TableName = base.Request.QueryString["tn"].ToString().Trim();
             this.ubtm.Name = this.txtname.Text.Trim();
             this.ubtm.Discription = this.txtDiscription.Text.Trim();
             this.ubtm.FatherPK = this.FatherPk.Value.Trim();
             this.ubtm.IsHasBaby = "0";
             this.ubtm.Grade++;
             int count = 0;
             if ((base.Request["PK"] != null) && (base.Request["PK"].ToString() != ""))
             {
                 this.ubtm.PK = base.Request["PK"].ToString().Trim();
                 Const.UpdateSuccess(this.ubtm.Update(this.dbo), this.Page);
             }
             else
             {
                 this.ubtm.BH = this.txtBH.Text.Trim();
                 if (this.ubtm.Exists(this.dbo) > 0)
                 {
                     Const.ShowMessage("该编号已经存在!", this.Page);
                 }
                 else
                 {
                     count = this.ubtm.Add(this.dbo);
                     if (base.Request["reload"] != null)
                     {
                         Const.AddSuccess(count, base.Request["reload"].ToString(), this.Page);
                     }
                     else
                     {
                         Const.AddSuccess(count, "", this.Page);
                     }
                 }
             }
         }
     }
     catch (Exception exception)
     {
         this.el = new ExceptionLog.ExceptionLog();
         this.el.ErrClassName = base.GetType().ToString();
         this.el.ErrMessage = exception.Message.ToString();
         this.el.ErrMethod = "addupdate()";
         this.el.WriteExceptionLog(true);
         Const.OpenErrorPage("操作失败,请联系管理员!", this.Page);
     }
     finally
     {
         if (this.dbo != null)
         {
             this.dbo.Close();
         }
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     string userName = ((UserModel)this.Session["User"]).UserName;
     string power = ((UserModel)this.Session["User"]).Power;
     ButtonsModel model = new ButtonsModel(userName)
     {
         IfAdd = false,
         IfUpdate = false,
         IfDelete = false,
         IfLook = false,
         IfSearch = false,
         IfRefresh = true,
         IfHuiZong = false,
         IfPutOut = false,
         IfSet = false,
         IfExit = true
     };
     this.Master.btModel = model;
     this.Master.ButtonsPushDown = new ButtonsHandler(this.Buttons);
     if (!base.IsPostBack)
     {
         if (this.Session["user"] == null)
         {
             Const.GoLoginPath_OpenWindow(this.Page);
         }
         else
         {
             if ((base.Request["PK"] != null) && (base.Request["PK"].ToString() != ""))
             {
                 model.IfSave = true;
                 this.getTitleUpdate();
                 this.txtBH.ReadOnly = true;
                 this.flog.Value = "Update";
                 try
                 {
                     this.dbo = new DB_OPT();
                     this.dbo.Open();
                     this.ubtm = new UsualBookTableDal();
                     this.ubtm.TableName = base.Request["tn"].ToString();
                     this.ubtm.PK = base.Request["PK"].ToString();
                     this.ubtm = this.ubtm.GetModel(true, this.dbo);
                     this.txtBH.Text = this.ubtm.BH;
                     this.txtname.Text = this.ubtm.Name.ToString();
                     this.txtDiscription.Text = this.ubtm.Discription.ToString();
                     this.FatherPk.Value = this.ubtm.FatherPK.Trim();
                     if (this.ubtm.FatherPK.ToString() != "")
                     {
                         DataSet set = new DataSet();
                         string strSql = "select * from " + base.Request["tn"].ToString() + " where pk='" + this.ubtm.FatherPK.Trim() + "'";
                         set = this.dbo.BackDataSet(strSql, null);
                         if ((set != null) && (set.Tables[0].Rows.Count > 0))
                         {
                             this.txtFatherPk.Text = set.Tables[0].Rows[0]["Name"].ToString();
                         }
                     }
                 }
                 catch (Exception exception)
                 {
                     this.el = new ExceptionLog.ExceptionLog();
                     this.el.ErrClassName = base.GetType().ToString();
                     this.el.ErrMessage = exception.Message.ToString();
                     this.el.ErrMethod = "addupdate()";
                     this.el.WriteExceptionLog(true);
                     Const.OpenErrorPage("获取数据失败,请联系管理员!", this.Page);
                 }
                 finally
                 {
                     if (this.dbo != null)
                     {
                         this.dbo.Close();
                     }
                 }
             }
             else
             {
                 model.IfSave = true;
                 this.getTitleAdd();
                 this.flog.Value = "add";
             }
             if (base.Request["tn"] != null)
             {
                 this.tableName.Value = base.Request["tn"].ToString();
             }
         }
     }
 }
示例#4
0
 public bool checkUsualBookTable(string strWhere, string tableName)
 {
     this.um = new UsualBookTableDal();
     this.dbo = new DB_OPT();
     this.um.TableName = tableName;
     return (this.um.GetList(strWhere, this.dbo).Tables[0].Rows.Count > 0);
 }
 protected void SearchControl(object sender, string strselect, string strcloname, string strsql, DataSet dstable, DataSet dsclo)
 {
     this.ubtm = new UsualBookTableDal();
     if (base.Request.QueryString["tn"].ToString() != "")
     {
         this.ubtm.TableName = base.Request.QueryString["tn"].ToString();
     }
     PageUsuClass.SearchControl(strselect, strcloname, strsql, this.pageind, this.ubtm.TableName + "DictionaryStep", this.Page);
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (base.Request["strTitle"] != null)
     {
         this.txttitle.Value = base.Server.UrlDecode(base.Request["strTitle"].ToString().Trim());
     }
     this.Master.strTitle = this.txttitle.Value;
     this.Master.ButtonsPushDown = new ButtonsHandler(this.Buttons);
     this.Master.SearchHasGone = new SearchHandler(this.SearchControl);
     this.Master.PageNavigatorChange = new PageNavigatorHandler(this.PageChangControl);
     if (!base.IsPostBack)
     {
         if (this.Session["user"] == null)
         {
             Const.GoLoginPath_List(this.Page);
         }
         else
         {
             string userName = ((UserModel)this.Session["User"]).UserName;
             string power = ((UserModel)this.Session["User"]).Power;
             ButtonsModel model = new ButtonsModel(userName);
             if (userName == "admin")
             {
                 model.IfAdd = true;
                 model.IfUpdate = true;
                 model.IfDelete = true;
                 model.IfLook = false;
                 model.IfSearch = false;
                 model.IfRefresh = true;
                 model.IfHuiZong = false;
                 model.IfPutOut = false;
                 model.IfSet = false;
                 model.IfExit = true;
             }
             else if ((((base.Request["List"] != null) && (base.Request["Add"] != null)) && ((base.Request["Update"] != null) && (base.Request["Delete"] != null))) && (base.Request["Print"] != null))
             {
                 if (PowerClass.IfHasPower(userName, power, base.Request["List"].ToString()))
                 {
                     if (PowerClass.IfHasPower(userName, power, base.Request["Add"].ToString()))
                     {
                         model.IfAdd = true;
                     }
                     if (PowerClass.IfHasPower(userName, power, base.Request["Update"].ToString()))
                     {
                         model.IfUpdate = true;
                     }
                     if (PowerClass.IfHasPower(userName, power, base.Request["Delete"].ToString()))
                     {
                         model.IfDelete = true;
                     }
                 }
                 else
                 {
                     Const.SorryForPower_List(this.Page);
                 }
             }
             this.Master.btModel = model;
             this.ubtm = new UsualBookTableDal();
             if (base.Request.QueryString["tn"].ToString() != "")
             {
                 this.ubtm.TableName = base.Request.QueryString["tn"].ToString();
             }
             string[] names = new string[] { "Name", "BH" };
             DataSet searchControlDataSet = Common.GetSearchControlDataSet(names);
             this.Master.DataSetClo = searchControlDataSet;
             names[0] = "名称";
             names[1] = "编号";
             DataSet set2 = Common.GetSearchControlDataSet(names);
             this.Master.DataSetTable = set2;
         }
     }
 }
 protected void PageChangControl(object sender, int nPageIndex)
 {
     this.ubtm = new UsualBookTableDal();
     if (base.Request.QueryString["tn"].ToString() != "")
     {
         this.ubtm.TableName = base.Request.QueryString["tn"].ToString();
     }
     PageUsuClass.PageChangControl(nPageIndex, this.ubtm.TableName + "DictionaryStep", this.Page);
 }
 public void ShowData(string str)
 {
     try
     {
         this.dbo = new DB_OPT();
         this.ubtm = new UsualBookTableDal();
         this.dbo.Open();
         if ((base.Request.QueryString["tn"] != null) && (base.Request.QueryString["tn"] != ""))
         {
             this.ubtm.TableName = base.Request.QueryString["tn"].ToString();
             if ((str != "") && (str != null))
             {
                 str = " where " + str + " ";
             }
             DataSet set = this.pagesize.pagesize("*", this.ubtm.TableName, str, "PK", "", this.Master.PageIndex, this.Master.PageSize, out this.count);
             this.Master.RecordCount = Convert.ToInt32(this.count);
             if ((set != null) && (set.Tables[0].Rows.Count > 0))
             {
                 set.Tables[0].Columns.Add(new DataColumn("FatherName", Type.GetType("System.String")));
                 DataSet list = new DataSet();
                 list = this.ubtm.GetList("", this.dbo);
                 foreach (DataRow row in set.Tables[0].Rows)
                 {
                     if ((row["FatherPK"].ToString().Trim() == "0") || (row["FatherPK"].ToString() == ""))
                     {
                         row["FatherName"] = "无";
                     }
                     else
                     {
                         DataRow[] rowArray = list.Tables[0].Select("PK='" + row["FatherPK"].ToString().Trim() + "'");
                         if ((rowArray != null) && (rowArray.Length > 0))
                         {
                             row["FatherName"] = rowArray[0]["Name"];
                         }
                     }
                 }
                 DataView defaultView = set.Tables[0].DefaultView;
                 if ((this.ViewState["SortOrder"] != null) && (this.ViewState["OrderDire"] != null))
                 {
                     string str2 = ((string)this.ViewState["SortOrder"]) + " " + ((string)this.ViewState["OrderDire"]);
                     defaultView.Sort = str2;
                 }
                 this.gvResult.DataSource = defaultView;
                 this.gvResult.DataBind();
             }
             else
             {
                 DataTable table = new DataTable();
                 table = set.Tables[0];
                 set.Tables[0].Columns.Add(new DataColumn("FatherName", Type.GetType("System.String")));
                 foreach (DataRow row2 in set.Tables[0].Rows)
                 {
                     row2["FatherName"] = "无";
                 }
                 DataRow row3 = table.NewRow();
                 table.Rows.Add(row3);
                 this.gvResult.DataSource = table.DefaultView;
                 this.gvResult.DataBind();
             }
         }
     }
     catch (Exception exception)
     {
         this.el = new ExceptionLog.ExceptionLog();
         this.el.ErrClassName = base.GetType().ToString();
         this.el.ErrMessage = exception.Message.ToString();
         this.el.ErrMethod = "ShowData()";
         this.el.WriteExceptionLog(true);
         Const.OpenErrorPage("获取数据失败,请联系系统管理员!", this.Page);
     }
     finally
     {
         if (this.dbo != null)
         {
             this.dbo.Close();
         }
     }
 }
 public void delete()
 {
     if ((this.gvResult.SelectedIndex >= 0) && (this.gvResult.Rows.Count >= this.gvResult.SelectedIndex))
     {
         try
         {
             try
             {
                 this.dbo = new DB_OPT();
                 this.ubtm = new UsualBookTableDal();
                 this.dbo.Open();
                 this.ubtm.TableName = base.Request.QueryString["tn"].ToString();
                 this.ubtm.PK = ((TextBox)this.gvResult.Rows[this.gvResult.SelectedIndex].Cells[0].FindControl("txtPK")).Text;
                 this.ubtm.Delete(this.dbo);
             }
             catch (Exception exception)
             {
                 this.el = new ExceptionLog.ExceptionLog();
                 this.el.ErrClassName = base.GetType().ToString();
                 this.el.ErrMessage = exception.Message.ToString();
                 this.el.ErrMethod = "delete()";
                 this.el.WriteExceptionLog(true);
                 Const.OpenErrorPage("操作失败,请联系系统管理员!", this.Page);
             }
             return;
         }
         finally
         {
             if (this.dbo != null)
             {
                 this.dbo.Close();
             }
         }
     }
     PageShowText.ShowMessage_List("请先选择一行再删除!", this.Page);
 }
 public override UsualBookTableModel[] GetEgality(bool bj, DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("select  ");
     builder.Append(" * ");
     builder.Append(" from " + base.TableName + " ");
     if (base.Grade >= 0)
     {
         builder.Append(" where Grade='" + base.Grade + "'");
     }
     else
     {
         if (base.PK == "")
         {
             throw new Exception("条件不足.");
         }
         builder.Append(" where Grade=(select Grade from " + base.TableName + " where PK='" + base.PK + "')");
     }
     DataSet set = dbo.BackDataSet(builder.ToString(), null);
     if (set.Tables[0].Rows.Count <= 0)
     {
         return null;
     }
     UsualBookTableModel[] modelArray = new UsualBookTableModel[set.Tables[0].Rows.Count];
     for (int i = 0; i < set.Tables[0].Rows.Count; i++)
     {
         modelArray[i] = new UsualBookTableModel();
         modelArray[i] = this.Getmm(set.Tables[0].Rows[i], bj, dbo);
     }
     return modelArray;
 }
 private UsualBookTableModel Getmm(DataRow dr, bool bj, DB_OPT dbo)
 {
     UsualBookTableModel model = new UsualBookTableModel {
         PK = dr["PK"].ToString(),
         Name = dr["Name"].ToString(),
         Discription = dr["Discription"].ToString(),
         FatherPK = dr["FatherPK"].ToString(),
         IsHasBaby = dr["IsHasBaby"].ToString(),
         BH = dr["BH"].ToString()
     };
     if (dr["Grade"].ToString() != "")
     {
         model.Grade = int.Parse(dr["Grade"].ToString());
     }
     model.PKPath = dr["PKPath"].ToString();
     if ((dr["IsHasBaby"].ToString() == "1") && bj)
     {
         model.ubtm = this.GetChilds(model.PK, dbo);
     }
     return model;
 }
 public override UsualBookTableModel[] GetParents(DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("select  ");
     builder.Append(" * ");
     builder.Append(" from " + base.TableName + " ");
     if (base.PKPath != "")
     {
         string[] strArray = base.PKPath.Split(new char[] { '|' });
         string str = "";
         for (int j = 0; j < strArray.Length; j++)
         {
             if (strArray[j] != "")
             {
                 str = str + "'" + strArray[j] + "',";
             }
         }
         builder.Append(" where PK in (" + str.Substring(0, str.Length - 1) + ")");
     }
     else
     {
         if (!(base.PK != ""))
         {
             return null;
         }
         string strSql = "select PKPath from " + base.TableName + " where PK='" + base.PK + "'";
         DataSet set = dbo.BackDataSet(strSql, null);
         if (set.Tables[0].Rows[0][0].ToString() != "")
         {
             string[] strArray2 = set.Tables[0].Rows[0][0].ToString().Split(new char[] { '|' });
             string str3 = "";
             for (int k = 0; k < strArray2.Length; k++)
             {
                 if (strArray2[k] != "")
                 {
                     str3 = str3 + "'" + strArray2[k] + "',";
                 }
             }
             builder.Append(" where PK in (" + str3.Substring(0, str3.Length - 1) + ")");
         }
         else
         {
             builder.Append(" where PK='" + base.PK + "'");
         }
     }
     DataSet set2 = dbo.BackDataSet(builder.ToString(), null);
     if (set2.Tables[0].Rows.Count <= 0)
     {
         return null;
     }
     UsualBookTableModel[] modelArray = new UsualBookTableModel[set2.Tables[0].Rows.Count];
     for (int i = 0; i < set2.Tables[0].Rows.Count; i++)
     {
         modelArray[i] = new UsualBookTableModel();
         modelArray[i] = this.Getmm(set2.Tables[0].Rows[i], false, dbo);
     }
     return modelArray;
 }
 public override UsualBookTableModel[] GetModels(string strwhere, bool bj, DB_OPT dbo)
 {
     UsualBookTableModel[] modelArray = null;
     StringBuilder builder = new StringBuilder();
     builder.Append("select ");
     builder.Append(" * ");
     builder.Append(" from " + base.TableName + " ");
     if (strwhere.Trim() != "")
     {
         builder.Append(" where " + strwhere);
     }
     DataSet set = dbo.BackDataSet(builder.ToString(), null);
     if (set.Tables[0].Rows.Count > 0)
     {
         modelArray = new UsualBookTableModel[set.Tables[0].Rows.Count];
         for (int i = 0; i < set.Tables[0].Rows.Count; i++)
         {
             modelArray[i] = new UsualBookTableModel();
             modelArray[i] = this.Getmm(set.Tables[0].Rows[i], bj, dbo);
         }
     }
     return modelArray;
 }