C# DataAccess.DB_OPT类代码示例

 public override int Delete(DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("delete from GOV_TC_DB_ZSZXFJ ");
     builder.Append(" where PK='" + base.pk + "' ");
     return dbo.ExecutionIsSucess(builder.ToString(), null);
 }

 public override int Delete(DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("delete from GOV_TC_DB_UNITCOUNT ");
     builder.Append(" where PK = '" + base.PK + "' or PKPath like '%" + base.PK + "%'");
     return dbo.ExecutionIsSucess(builder.ToString(), null);
 }

 public override UnitCountModel[] GetEgality(bool bj, DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("select  ");
     builder.Append(" * ");
     builder.Append(" from GOV_TC_DB_UNITCOUNT ");
     if (base.Grade >= 0)
     {
         builder.Append(" where Grade='" + base.Grade + "'");
     }
     else
     {
         if (base.PK == "")
         {
             throw new Exception("条件不足.");
         }
         builder.Append(" where Grade=(select Grade from GOV_TC_DB_UNITCOUNT where PK='" + base.PK + "')");
     }
     DataSet set = dbo.BackDataSet(builder.ToString(), null);
     if (set.Tables[0].Rows.Count <= 0)
     {
         return null;
     }
     UnitCountModel[] modelArray = new UnitCountModel[set.Tables[0].Rows.Count];
     for (int i = 0; i < set.Tables[0].Rows.Count; i++)
     {
         modelArray[i] = new UnitCountModel();
         modelArray[i] = this.Getmm(set.Tables[0].Rows[i], bj, dbo);
     }
     return modelArray;
 }

 public override int Add(DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into gov_tc_db_ServicesConnection(");
     builder.Append("OperationPK,ServicePK,Name,ServiceStep,CompanyPK,BranchPK,ConnectionTypePK,FatherPK,ConnectionPath,Grade,IsHasBaby,TopLevelConnectionPK,IfTax,IfFee,IfLast,Memo)");
     builder.Append(" values (");
     builder.Append(":OperationPK,:ServicePK,:Name,:ServiceStep,:CompanyPK,:BranchPK,:ConnectionTypePK,:FatherPK,:ConnectionPath,:Grade,:IsHasBaby,:TopLevelConnectionPK,:IfTax,:IfFee,:IfLast,:Memo)");
     OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":OperationPK", OracleType.VarChar, 40), new OracleParameter(":ServicePK", OracleType.VarChar, 40), new OracleParameter(":Name", OracleType.VarChar, 100), new OracleParameter(":ServiceStep", OracleType.Int32, 4), new OracleParameter(":CompanyPK", OracleType.VarChar, 40), new OracleParameter(":BranchPK", OracleType.VarChar, 40), new OracleParameter(":ConnectionTypePK", OracleType.VarChar, 40), new OracleParameter(":FatherPK", OracleType.VarChar, 40), new OracleParameter(":ConnectionPath", OracleType.VarChar, 0xff), new OracleParameter(":Grade", OracleType.Int32, 4), new OracleParameter(":IsHasBaby", OracleType.Char, 1), new OracleParameter(":TopLevelConnectionPK", OracleType.VarChar, 40), new OracleParameter(":IfTax", OracleType.Char, 1), new OracleParameter(":IfFee", OracleType.Char, 1), new OracleParameter(":IfLast", OracleType.Char, 1), new OracleParameter(":Memo", OracleType.VarChar, 0xff) };
     parameters[0].Value = base.OperationPK;
     parameters[1].Value = base.ServicePK;
     parameters[2].Value = base.Name;
     parameters[3].Value = base.ServiceStep;
     parameters[4].Value = base.CompanyPK;
     parameters[5].Value = base.BranchPK;
     parameters[6].Value = base.ConnectionTypePK;
     parameters[7].Value = base.FatherPK;
     parameters[8].Value = base.ConnectionPath;
     parameters[9].Value = base.Grade;
     parameters[10].Value = base.IsHasBaby;
     parameters[11].Value = base.TopLevelConnectionPK;
     parameters[12].Value = base.IfTax;
     parameters[13].Value = base.IfFee;
     parameters[14].Value = base.IfLast;
     parameters[15].Value = base.Memo;
     return dbo.ExecutionIsSucess(builder.ToString(), parameters, "");
 }

 public override int Delete(DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("delete DB_OPERATIONLOG ");
     builder.Append(" where pk='" + base.pk + "' ");
     return dbo.ExecutionIsSucess(builder.ToString(), null);
 }

 public bool checkIsRepeat(string text, string sql)
 {
     bool flag = false;
     try
     {
         this.dbo = new DB_OPT();
         this.dbo.Open();
         DataSet set = new DataSet();
         set = this.dbo.BackDataSet(sql, null);
         if ((set != null) && (set.Tables[0].Rows.Count > 0))
         {
             for (int i = 0; i < set.Tables[0].Rows.Count; i++)
             {
                 if (text == set.Tables[0].Rows[0][0].ToString())
                 {
                     flag = true;
                 }
             }
         }
         return flag;
     }
     catch (Exception)
     {
     }
     finally
     {
         if (this.dbo != null)
         {
             this.dbo.Close();
         }
     }
     return flag;
 }

 public int Delete(string PK, DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("delete from GOV_TC_DB_SFZSZXFJ ");
     builder.Append(" where PK=" + PK);
     return dbo.ExecutionIsSucess(builder.ToString(), null);
 }

 public override void Delete(DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("delete from DB_Bank ");
     builder.Append(" where BankPK='" + base.BankPK + "'");
     dbo.ExecutionIsSucess(builder.ToString(), null);
 }

 public override int Add(DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("insert into gov_tc_db_ServicesRegister(");
     builder.Append("ServiceTypePK,Name,Path,ClassName,ContParameters,IfTwoCont,Method,IfTwoMet,Parameters,Discription,GetServiceType,StartSign,InTime,OutTime,FatherPK,IsHasBaby,Grade,PKPath,MaxNum)");
     builder.Append(" values (");
     builder.Append(":ServiceTypePK,:Name,:Path,:ClassName,:ContParameters,:IfTwoCont,:Method,:IfTwoMet,:Parameters,:Discription,:GetServiceType,:StartSign,:InTime,:OutTime,:FatherPK,:IsHasBaby,:Grade,:PKPath,:MaxNum)");
     OracleParameter[] parameters = new OracleParameter[] {
         new OracleParameter(":ServiceTypePK", OracleType.Char, 40), new OracleParameter(":Name", OracleType.VarChar, 40), new OracleParameter(":Path", OracleType.VarChar, 0xff), new OracleParameter(":ClassName", OracleType.VarChar, 40), new OracleParameter(":ContParameters", OracleType.VarChar, 0xff), new OracleParameter(":IfTwoCont", OracleType.Char, 1), new OracleParameter(":Method", OracleType.VarChar, 40), new OracleParameter(":IfTwoMet", OracleType.Char, 1), new OracleParameter(":Parameters", OracleType.VarChar, 0xff), new OracleParameter(":Discription", OracleType.VarChar, 0xff), new OracleParameter(":GetServiceType", OracleType.VarChar, 1), new OracleParameter(":StartSign", OracleType.VarChar, 1), new OracleParameter(":InTime", OracleType.DateTime, 40), new OracleParameter(":OutTime", OracleType.DateTime, 40), new OracleParameter(":FatherPK", OracleType.VarChar, 40), new OracleParameter(":IsHasBaby", OracleType.Char, 1),
         new OracleParameter(":Grade", OracleType.Int32, 4), new OracleParameter(":PKPath", OracleType.Clob), new OracleParameter(":MaxNum", OracleType.Int32, 4)
      };
     parameters[0].Value = base.ServiceTypePK;
     parameters[1].Value = base.Name;
     parameters[2].Value = base.Path;
     parameters[3].Value = base.ClassName;
     parameters[4].Value = base.ContParameters;
     parameters[5].Value = base.IfTwoCont;
     parameters[6].Value = base.Method;
     parameters[7].Value = base.IfTwoMet;
     parameters[8].Value = base.Parameters;
     parameters[9].Value = base.Discription;
     parameters[10].Value = base.GetServiceType;
     parameters[11].Value = base.StartSign;
     parameters[12].Value = base.InTime;
     parameters[13].Value = base.OutTime;
     parameters[14].Value = base.FatherPK;
     parameters[15].Value = base.IsHasBaby;
     parameters[0x10].Value = base.Grade;
     parameters[0x11].Value = base.PKPath;
     parameters[0x12].Value = base.MaxNum;
     return dbo.ExecutionIsSucess(builder.ToString(), parameters, "");
 }

 public override int Exists(DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("select count(1) from GOV_TC_DB_ZSZXFJ");
     builder.Append(" where pk='" + base.pk + "' ");
     return dbo.BackIsSelect(builder.ToString(), null);
 }

 public static void ChangeChildPkPath(string pk_corp, string pkpath, int grade, DB_OPT dbo)
 {
     CompanyModel model = new CompanyDal();
     CompanyModel[] modelArray = model.GetChilds(pk_corp, false, dbo);
     if (modelArray != null)
     {
         for (int i = 0; i < modelArray.Length; i++)
         {
             model.pk_corp = modelArray[i].pk_corp;
             model.Grade = grade;
             model.PKPath = pkpath;
             model.UpdatePKPathAndGrade(dbo);
             if (modelArray[i].IsHasBaby == "1")
             {
                 ChangeChildPkPath(modelArray[i].pk_corp, pkpath + model.pk_corp + "|", grade + 1, dbo);
             }
         }
     }
     else
     {
         model.pk_corp = pk_corp;
         model.IsHasBaby = "0";
         model.UpdateHasBaby(dbo);
     }
 }

 protected void btDo_Click(object sender, EventArgs e)
 {
     try
     {
         this.dbo = new DB_OPT();
         this.dbo.Open();
         this.drpm = new DataRowPowerDal();
         this.drpm.Name = this.txtname.Text.Trim();
         this.drpm.PowerCode = this.txtpowercode.Text.Trim();
         this.drpm.TableName = this.ddltablename.SelectedValue;
         this.drpm.ColumnName = this.ddlColumnName.SelectedValue.Split(new char[] { '|' })[0];
         this.drpm.TJType = this.ddlColumnName.SelectedValue.Split(new char[] { '|' })[1];
         this.drpm.strWhere = this.GetStrWhere();
         this.drpm.Discription = this.txtDiscription.Text.Trim();
         if (this.ifadd.Value == "0")
         {
             this.drpm.PK = this.pk.Value;
             this.drpm.Update(this.dbo);
             Const.DoSuccessOpen("修改成功！", this.Page);
         }
         else
         {
             this.drpm.Add(this.dbo);
             Const.DoSuccessOpen("添加成功！", this.Page);
         }
     }
     catch (Exception exception)
     {
         Const.ShowMessage("操作失败！" + exception.Message, this.Page);
     }
 }

 public static void ChangeChildPkPath(string menupk, string pkpath, int grade, DB_OPT dbo)
 {
     MenuModel model = new MenuDal();
     MenuModel[] childs = model.GetChilds(menupk, dbo);
     if (childs != null)
     {
         for (int i = 0; i < childs.Length; i++)
         {
             model.MemuPK = childs[i].MemuPK;
             model.Grade = grade;
             model.PKPath = pkpath;
             model.UpdatePKPathAndGrade(dbo);
             if (childs[i].IsHasBaby == "1")
             {
                 ChangeChildPkPath(childs[i].MemuPK, pkpath + model.MemuPK + "|", grade + 1, dbo);
             }
         }
     }
     else
     {
         model.MemuPK = menupk;
         model.IsHasBaby = "0";
         model.UpdateHasBaby(dbo);
     }
 }

 public int Delete(string PK, DB_OPT dbo)
 {
     StringBuilder builder = new StringBuilder();
     builder.Append("delete from DB_DATATABLE ");
     builder.Append(" where PK='" + PK + "' ");
     return dbo.ExecutionIsSucess(builder.ToString(), null);
 }

 public static string GetUserCompany(string username)
 {
     string str = "false";
     DB_OPT dbo = null;
     try
     {
         dbo = new DB_OPT();
         dbo.Open();
         string str2 = "";
         UserDal.GetCompanyPK(username.Trim(), ref str2, dbo);
         if (str2 != "")
         {
             string ccode = "";
             string cname = "";
             CompanyDal.GetCompanyName(str2, ref ccode, ref cname, dbo);
             str = ccode + "," + cname;
         }
     }
     catch (Exception exception)
     {
         new ExceptionLog.ExceptionLog { ErrClassName = "UserBll", ErrMessage = exception.Message.ToString(), ErrMethod = "GetUserCompany()" }.WriteExceptionLog(true);
     }
     finally
     {
         if (dbo != null)
         {
             dbo.Close();
         }
     }
     return str;
 }