public override DataSet GetList(string strWhere, DB_OPT dbo) { string selectSql = this.GetSelectSql(); if (strWhere.Trim() != "") { selectSql = selectSql + " where " + strWhere; } return dbo.BackDataSet(selectSql, null); }
public static void GetCompanyPK(string username, ref string pk_corp, DB_OPT dbo) { string strSql = "select PK_CORP from DB_Users where UserName='******'"; DataSet set = dbo.BackDataSet(strSql, null); if ((set != null) && (set.Tables[0].Rows.Count > 0)) { pk_corp = set.Tables[0].Rows[0]["pk_corp"].ToString(); } }
public static void GetCompanyName(string pk_corp, ref string ccode, ref string cname, DB_OPT dbo) { string strSql = "select Name from DB_Company where pk_corp='" + pk_corp + "'"; DataSet set = dbo.BackDataSet(strSql, null); if ((set != null) && (set.Tables[0].Rows.Count > 0)) { ccode = pk_corp; cname = set.Tables[0].Rows[0]["Name"].ToString(); } }
public override DataSet GetList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append(this.GetSqlString()); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public override DataSet GetList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,OperationPK,ServicePK,Name,ServiceStep,CompanyPK,BranchPK,ConnectionTypePK,FatherPK,ConnectionPath,Grade,IsHasBaby,TopLevelConnectionPK,IfTax,IfFee,IfLast,Memo "); builder.Append(" FROM gov_tc_db_ServicesConnection "); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public override DataSet GetViewList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select BANKPK,PK_CORP,BANKNAME,BANKNUM,BANKNUMMAN,DISCRIPTION,NAME "); builder.Append(" FROM gov_tc_view_Bank "); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public override DataSet GetList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,OPERATIONPK,SFPK,PROJECTTYPE,TERMNAME,TERMVALUE,EXECUTEVALUE1,EXECUTEVALUE2,DISCRIPTION,EXECUTEVALUE3,SFNAME,YWNAME,SFZSXMNAME"); builder.Append(" FROM gov_tc_view_ZSZXFJ "); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public override DataSet GetList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,BH,Name "); builder.Append(" FROM gov_tc_db_ServicesType "); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public override DataSet GetList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,Name,PowerCode,TJType,TableName,ColumnName,strWhere,Discription "); builder.Append(" FROM DataRowPower "); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public override DataSet GetList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,Name,Discription,pk_corp "); builder.Append(" FROM gov_tc_view_SFType "); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public override DataSet GetList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,OPERATIONPK,SERVERPKS "); builder.Append(" FROM gov_tc_db_Operation "); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public DataSet GetList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PARAGRAPHS,ID,TYPEID,CURRENTVALUE,ENDSIGN,STEP,ISRESTORE,INITIALVALUE,RESTORECYCLE,MAXVALUE "); builder.Append(" FROM DB_IdRules join DB_RulesType on DB_IdRules.TypeId=DB_RulesType.TypeId "); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public override DataSet GetList(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select pk,UserName,opType,Business,Content,ifPass,opTime "); builder.Append(" FROM DB_OPERATIONLOG "); if (strWhere.Trim() != "") { builder.Append(" where " + strWhere); } return dbo.BackDataSet(builder.ToString(), null); }
public DataTableModel GetModel(string PK, DB_OPT dbo) { string strSql = this.GetSql() + " where PK=:PK"; OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.Char) }; parameters[0].Value = PK; DataSet set = dbo.BackDataSet(strSql, parameters, ""); if (set.Tables[0].Rows.Count > 0) { new DataTableModel(); return this.GetModel(set.Tables[0].Rows[0]); } return null; }
public override RoleModel GetModel(bool bj_child, bool bj_father, DB_OPT dbo) { RoleModel model = null; StringBuilder builder = new StringBuilder(); builder.Append(this.GetSqlString()); builder.Append(" where RolePK='" + base.RolePK + "'"); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count > 0) { model = new RoleModel(); model = this.Getmm(set.Tables[0].Rows[0], bj_child, bj_father, dbo); } return model; }
public override BusinessMessModel GetModel(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append(this.GetSelectSql()); builder.Append(" where PK=:PK"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.Char) }; parameters[0].Value = base.PK; DataSet set = dbo.BackDataSet(builder.ToString(), parameters, ""); if (set.Tables[0].Rows.Count > 0) { new BusinessMessModel(); return this.GetModel(false, false, set.Tables[0].Rows[0], dbo); } return null; }
public override ZSZXFJModel GetModel(DB_OPT dbo) { new ZSZXFJModel(); StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" PK,OperationPK,SFPK,ProjectType,TermName1,TermName2,ExecuteValue1,ExecuteValue2,ExecuteValue3,flog,Discription "); builder.Append(" from GOV_TC_DB_ZSZXFJ "); builder.Append(" where PK='" + base.pk + "' "); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count > 0) { return this.Getmm(set.Tables[0].Rows[0], dbo); } return null; }
public override OperationModel GetModel(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,OPERATIONPK,SERVERPKS from gov_tc_db_Operation "); builder.Append(" where OperationPK=:OperationPK"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":OperationPK", OracleType.Char) }; parameters[0].Value = base.OperationPK; DataSet set = dbo.BackDataSet(builder.ToString(), parameters, ""); if (set.Tables[0].Rows.Count > 0) { new OperationModel(); return this.GetModel(set.Tables[0].Rows[0]); } return null; }
public override SFTypeModel GetModel(DB_OPT dbo) { new SFTypeModel(); StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" PK,Name,Discription,pk_corp "); builder.Append(" from GOV_TC_DB_SFType "); builder.Append(" where PK='" + base.PK + "' "); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count > 0) { return this.Getmm(set.Tables[0].Rows[0], dbo); } return null; }
public override ServicesTypeModel GetModel(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,BH,Name from gov_tc_db_ServicesType "); builder.Append(" where PK=:PK"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.VarChar) }; parameters[0].Value = base.PK; DataSet set = dbo.BackDataSet(builder.ToString(), parameters, ""); if (set.Tables[0].Rows.Count > 0) { new ServicesTypeModel(); return this.GetModel(set.Tables[0].Rows[0]); } return null; }
public override ServicesConnectionModel GetModel(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,OperationPK,ServicePK,Name,ServiceStep,CompanyPK,BranchPK,ConnectionTypePK,FatherPK,ConnectionPath,Grade,IsHasBaby,TopLevelConnectionPK,IfTax,IfFee,IfLast,Memo from gov_tc_db_ServicesConnection "); builder.Append(" where PK=:PK"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":PK", OracleType.VarChar) }; parameters[0].Value = base.PK; DataSet set = dbo.BackDataSet(builder.ToString(), parameters, ""); if (set.Tables[0].Rows.Count > 0) { new ServicesConnectionModel(); return this.GetModel(set.Tables[0].Rows[0]); } return null; }
public static SFProjectModel[] GetTacheSFMessByTachePK(string TachePK, DB_OPT dbo) { string strSql = "select distinct SFPROJECTPK,NAME from GOV_TC_VIEW_SFPROCOUNTSTANDARD where TACHEPK='" + TachePK + "'"; DataSet set = dbo.BackDataSet(strSql, null); SFProjectModel[] modelArray = null; if ((set != null) && (set.Tables[0].Rows.Count > 0)) { modelArray = new SFProjectModel[set.Tables[0].Rows.Count]; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { modelArray[i] = new SFProjectModel(); modelArray[i].PK = set.Tables[0].Rows[0]["SFPROJECTPK"].ToString(); modelArray[i].NAME = set.Tables[0].Rows[0]["NAME"].ToString(); } } return modelArray; }
public override void GetModel(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" BankPK,pk_corp,BankName,BankNum,BankNumMan,Discription "); builder.Append(" from DB_Bank "); builder.Append(" where BankPK='" + base.BankPK + "'"); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count > 0) { base.pk_corp = set.Tables[0].Rows[0]["pk_corp"].ToString(); base.BankName = set.Tables[0].Rows[0]["BankName"].ToString(); base.BankNum = set.Tables[0].Rows[0]["BankNum"].ToString(); base.BankNumMan = set.Tables[0].Rows[0]["BankNumMan"].ToString(); base.Discription = set.Tables[0].Rows[0]["Discription"].ToString(); } }
public override OperationLogModel GetModel(DB_OPT dbo) { new OperationLogModel(); StringBuilder builder = new StringBuilder(); builder.Append("select pk,UserName,opType,Business,Content,ifPass,opTime "); builder.Append(" FROM DB_OPERATIONLOG "); if (base.pk.Trim() != "") { builder.Append(" where pk='" + base.pk + "'"); } DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count > 0) { return this.Getmm(set.Tables[0].Rows[0], dbo); } return null; }
public override void GetModel(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" PK,Name,PowerCode,TableName,ColumnName,QXList,strWhere,ShowTJ,Discription "); builder.Append(" from db_DataRowPowerItem "); builder.Append(" where PK='" + base.PK + "'"); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count > 0) { base.Name = set.Tables[0].Rows[0]["Name"].ToString(); base.PowerCode = set.Tables[0].Rows[0]["PowerCode"].ToString(); base.TableName = set.Tables[0].Rows[0]["TableName"].ToString(); base.ColumnName = set.Tables[0].Rows[0]["ColumnName"].ToString(); base.QXList = set.Tables[0].Rows[0]["QXList"].ToString(); base.strWhere = set.Tables[0].Rows[0]["strWhere"].ToString(); base.ShowTJ = set.Tables[0].Rows[0]["ShowTJ"].ToString(); base.Discription = set.Tables[0].Rows[0]["Discription"].ToString(); } }
public override void GetModel(DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" PK,Name,PowerCode,TJType,TableName,ColumnName,strWhere,Discription "); builder.Append(" from DataRowPower "); builder.Append(" where PK='" + base.PK + "'"); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count > 0) { base.Name = set.Tables[0].Rows[0]["Name"].ToString(); base.PowerCode = set.Tables[0].Rows[0]["PowerCode"].ToString(); base.TJType = set.Tables[0].Rows[0]["TJType"].ToString(); base.TableName = set.Tables[0].Rows[0]["TableName"].ToString(); base.ColumnName = set.Tables[0].Rows[0]["ColumnName"].ToString(); base.strWhere = set.Tables[0].Rows[0]["strWhere"].ToString(); base.Discription = set.Tables[0].Rows[0]["Discription"].ToString(); base.CodeAndWhere = set.Tables[0].Rows[0]["PowerCode"].ToString() + "|" + set.Tables[0].Rows[0]["strWhere"].ToString(); } }
public override OperationModel[] GetModel(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,OPERATIONPK,SERVERPKS from gov_tc_db_Operation "); if (strWhere != "") { builder.Append(" where " + strWhere); } DataSet set = dbo.BackDataSet(builder.ToString(), null); OperationModel[] modelArray = null; if (set.Tables[0].Rows.Count <= 0) { return null; } modelArray = new OperationModel[set.Tables[0].Rows.Count]; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { modelArray[i] = new OperationModel(); modelArray[i] = this.GetModel(set.Tables[0].Rows[i]); } return modelArray; }
public override ServicesTypeModel[] GetModel(string strWhere, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append("select PK,BH,Name from gov_tc_db_ServicesType "); if (strWhere != "") { builder.Append(" where " + strWhere); } DataSet set = dbo.BackDataSet(builder.ToString(), null); ServicesTypeModel[] modelArray = null; if (set.Tables[0].Rows.Count <= 0) { return null; } modelArray = new ServicesTypeModel[set.Tables[0].Rows.Count]; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { modelArray[i] = new ServicesTypeModel(); modelArray[i] = this.GetModel(set.Tables[0].Rows[i]); } return modelArray; }
public override ServicesRegisterModel[] GetChilds(string parentpk, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append(this.GetSql()); if (parentpk != "") { builder.Append(" where FatherPK='" + parentpk + "'"); } builder.Append(" order by PK"); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count <= 0) { return null; } ServicesRegisterModel[] modelArray = new ServicesRegisterModel[set.Tables[0].Rows.Count]; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { modelArray[i] = new ServicesRegisterModel(); modelArray[i] = this.GetModel(set.Tables[0].Rows[i], false, false, dbo); } return modelArray; }
public override BranchModel[] GetChilds(string parentpk, bool bj_employee, DB_OPT dbo) { StringBuilder builder = new StringBuilder(); builder.Append(this.GetSql()); if (parentpk != "") { builder.Append(" where FatherPK='" + parentpk + "'"); } builder.Append(" order by pk_corp"); DataSet set = dbo.BackDataSet(builder.ToString(), null); if (set.Tables[0].Rows.Count <= 0) { return null; } BranchModel[] modelArray = new BranchModel[set.Tables[0].Rows.Count]; for (int i = 0; i < set.Tables[0].Rows.Count; i++) { modelArray[i] = new BranchModel(); modelArray[i] = this.Getmm(set.Tables[0].Rows[i], true, false, false, bj_employee, dbo); } return modelArray; }