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;
}