本文整理汇总了C#中SoMeTech.DataAccess.DB_OPT.BackDataSet方法的典型用法代码示例。如果您正苦于以下问题：C# DB_OPT.BackDataSet方法的具体用法？C# DB_OPT.BackDataSet怎么用？C# DB_OPT.BackDataSet使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SoMeTech.DataAccess.DB_OPT的用法示例。
在下文中一共展示了DB_OPT.BackDataSet方法的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetList
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);
}示例2: GetCompanyPK
public static void GetCompanyPK(string username, ref string pk_corp, DB_OPT dbo)
{
string strSql = "select PK_CORP from DB_Users where UserName='" + 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();
}
}示例3: GetCompanyName
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();
}
}示例4: GetList
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);
}示例5: GetList
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);
}示例6: GetViewList
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);
}示例7: GetList
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);
}示例8: GetModel
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;
}示例9: GetModel
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;
}示例10: GetModel
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;
}示例11: GetModel
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;
}示例12: GetModel
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;
}示例13: GetModel
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;
}示例14: GetModel
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;
}示例15: GetModel
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;
}