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 bool checkIsRepeat(string sql) { this.dbo = new DB_OPT(); DataSet set = new DataSet(); set = this.dbo.BackDataSet(sql, null); return ((set != null) && (set.Tables[0].Rows.Count > 0)); }
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 int Delete(string PK, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("delete GOV_TC_DB_SFProExecuteStandard "); 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; }
public override int Add(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("insert into DB_Menu("); builder.Append("MenuBH,MenuName,PageUrl,ImgUrl,FatherPK,IsHasBaby,Grade,PKPath,IsShow,PowerCode,InsertPC,UpdatePC,DeletePC,PrintPC,OpenType,IsCheckPower,VisitPoint,MenuType,OrderBy,Discription,pk_corp"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + base.MenuBH + "',"); builder.Append("'" + base.MenuName + "',"); builder.Append("'" + base.PageUrl + "',"); builder.Append("'" + base.ImgUrl + "',"); builder.Append("'" + base.FatherPK + "',"); builder.Append("'" + base.IsHasBaby + "',"); builder.Append(base.Grade + ","); builder.Append("'" + base.PKPath + "',"); builder.Append("'" + base.IsShow + "',"); builder.Append("'" + base.PowerCode + "',"); builder.Append("'" + base.InsertPC + "',"); builder.Append("'" + base.UpdatePC + "',"); builder.Append("'" + base.DeletePC + "',"); builder.Append("'" + base.PrintPC + "',"); builder.Append("'" + base.OpenType + "',"); builder.Append("'" + base.IsCheckPower + "',"); builder.Append(base.VisitPoint + ","); builder.Append("'" + base.MenuType + "',"); builder.Append(base.OrderBy + ","); builder.Append("'" + base.Discription + "',"); builder.Append("'" + base.pk_corp + "'"); builder.Append(")"); return dbo.ExecutionIsSucess(builder.ToString(), null); }
public override int Delete(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("delete from DB_Menu "); builder.Append(" where MemuPK='" + base.MemuPK + "'"); return dbo.ExecutionIsSucess(builder.ToString(), null); }
public string GetStrParent(string pkpath) { string str; try { string str2 = ""; this.dbo = new DB_OPT(); this.dbo.Open(); BranchModel[] parents = new BranchDal { PKPath = pkpath }.GetParents(false, this.dbo); for (int i = 0; i < parents.Length; i++) { str2 = parents[i].BranchPK + "~" + str2; } str = str2.Substring(0, str2.Length - 1); } catch (Exception) { str = ""; } finally { if (this.dbo != null) { this.dbo.Close(); } } return str; }
public override DataRowPowerModel[] GetModels(DB_OPT dbo) { DataRowPowerModel[] modelArray = null; StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" PK,Name,PowerCode,TJType,TableName,ColumnName,strWhere,Discription "); builder.Append(" from DataRowPower "); builder.Append(" where TableName='" + base.TableName + "'"); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count > 0) { modelArray = new DataRowPowerModel[set.Tables[0].Rows.Count]; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { modelArray[i] = new DataRowPowerModel(); modelArray[i].Name = set.Tables[0].Rows[i]["Name"].ToString(); modelArray[i].PowerCode = set.Tables[0].Rows[i]["PowerCode"].ToString(); modelArray[i].TJType = set.Tables[0].Rows[i]["TJType"].ToString(); modelArray[i].TableName = set.Tables[0].Rows[i]["TableName"].ToString(); modelArray[i].ColumnName = set.Tables[0].Rows[i]["ColumnName"].ToString(); modelArray[i].strWhere = set.Tables[0].Rows[i]["strWhere"].ToString(); modelArray[i].Discription = set.Tables[0].Rows[i]["Discription"].ToString(); modelArray[i].CodeAndWhere = set.Tables[0].Rows[i]["PowerCode"].ToString() + "|" + set.Tables[0].Rows[i]["strWhere"].ToString(); } } return modelArray; }
public override int Delete(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("delete DataRowPower "); builder.Append(" where PK='" + base.PK + "'"); return dbo.ExecutionIsSucess(builder.ToString(), null); }
public int Delete(string PK, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("delete GOV_TC_DB_OprateToInformation "); builder.Append(" where PK='" + PK + "' "); return dbo.ExecutionIsSucess(builder.ToString(), null); }
public override int Add(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("insert into DB_Role("); builder.Append("BH,Name,Power,DataPower,RowPower,ServicesPower,CompanyPower,Discription,IsUserPower,FatherPK,IsHasBaby,Grade,PKPath,BranchPK,pk_corp"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + base.BH + "',"); builder.Append("'" + base.Name + "',"); builder.Append("'" + base.Power + "',"); builder.Append("'" + base.DataPower + "',"); builder.Append("'" + base.RowPower + "',"); builder.Append("'" + base.ServicesPower + "',"); builder.Append("'" + base.CompanyPower + "',"); builder.Append("'" + base.Discription + "',"); builder.Append("'" + base.IsUserPower + "',"); builder.Append("'" + base.FatherPK + "',"); builder.Append("'" + base.IsHasBaby + "',"); builder.Append(base.Grade + ","); builder.Append("'" + base.PKPath + "',"); builder.Append("'" + base.BranchPK + "',"); builder.Append("'" + base.pk_corp + "'"); builder.Append(")"); return dbo.ExecutionIsSucess(builder.ToString(), null); }
public DataSet GetDataSet(string sql) { DataSet ds; DataBaseType dBT = DB_OPT.DBT; try { if (base.Request["MSSQL"] != null) { this.db = new DB_OPT("2", base.Request["MSSQL"], DataBaseType.SqlServer); DB_OPT.DBT = DataBaseType.SqlServer; } else { this.db = new DB_OPT(); } this.ds = new DataSet(); this.ds = this.db.BackDataSet(sql, null); ds = this.ds; } catch { ds = null; } finally { DB_OPT.DBT = dBT; } return ds; }
public int TaxFee(string mainTableName, string mainPK, string tableName, string PK, string executeMan, string computerIP, int step, string riticize, decimal money1, decimal money2, decimal money3, DB_OPT dbo) { string strSql = "update " + tableName + " set Sign='1', ExecuteMan='" + executeMan + "', ComputerIP='" + computerIP + "', ExecuteDate='" + DateTime.Now.ToShortDateString() + "', Riticize='" + riticize + "', Money1=" + money1.ToString() + ", Money2=" + money2.ToString() + ", Money3=" + money3.ToString() + " where PK='" + PK + "'"; dbo.ExecutionIsSucess(strSql, null); string[] strArray = new string[] { "update ", mainTableName, " set Step='", (step + 1).ToString(), "' where PK='", mainPK, "'" }; strSql = string.Concat(strArray); return dbo.ExecutionIsSucess(strSql, null); }
public override int Exists(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select count(PK) from gov_tc_db_ServicesType"); builder.Append(" where PK=:PK"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.VarChar) }; parameters[0].Value = base.PK; return dbo.BackIsSelect(builder.ToString(), parameters, ""); }
public override int Delete(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("delete from gov_tc_db_ServicesType "); builder.Append(" where PK=:PK"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.VarChar) }; parameters[0].Value = base.PK; return dbo.ExecutionIsSucess(builder.ToString(), parameters, ""); }
public void ShowData(string str) { try { string year = HttpContext.Current.Request.Cookies["YearND"].Value.ToString(); this.dbo = new DB_OPT(); this.dbo.Open(); str = " where lbdm=5 and substr(fzdm,1,1)='3' and gsdm='" + year + "'"; DataSet set = this.pagesize.pagesize(GetColsName(), "gl_fzxzl ", str, "fzdm", " order by fzdm ", 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)) { DataTable table = set.Tables[0]; DataColumn dc = new DataColumn(); dc.ColumnName = "LEVEL"; dc.Expression = "(len(trim(fzdm))-1)/2"; table.Columns.Add(dc); DataColumn dc2 = new DataColumn(); dc2.ColumnName = "PID"; dc2.Expression = "iif(len(trim(fzdm))=3,'0',substring(fzdm,1,len(trim(fzdm))-2))"; table.Columns.Add(dc2); DataColumn dc3 = new DataColumn(); dc3.ColumnName = "FZDMM"; dc3.Expression = "FZDM+'-'+FZMC"; table.Columns.Add(dc3); this.gvResult.DataSource = table; this.gvResult.DataBind(); } else { DataTable table3 = new DataTable(); this.gvResult.DataSource = table3.DefaultView; this.gvResult.DataBind(); } //PublicDal.setGridKeepAll(this.gvResult); } 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 int Exists(string PK, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select count(PK) from GOV_TC_DB_SFProExecuteStandard"); builder.Append(" where PK=:PK"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.Char) }; parameters[0].Value = PK; return dbo.BackIsSelect(builder.ToString(), parameters, ""); }