public override UnitCountModel[] GetChilds(string parentpk, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" * ");
builder.Append(" from GOV_TC_DB_UNITCOUNT ");
if (parentpk != "")
{
builder.Append(" where FatherPK='" + parentpk + "'");
}
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], true, dbo);
}
return modelArray;
}
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 UnitCountModel[] GetParents(DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" * ");
builder.Append(" from GOV_TC_DB_UNITCOUNT ");
if (base.PKPath != "")
{
string[] strArray = base.PKPath.Split(new char[] { '|' });
string str = "";
for (int j = 0; j < strArray.Length; j++)
{
if (strArray[j] != "")
{
str = str + "'" + strArray[j] + "',";
}
}
builder.Append(" where PK in (" + str.Substring(0, str.Length - 1) + ")");
}
else
{
if (!(base.PK != ""))
{
throw new Exception("条件不足.");
}
string strSql = "select PKPath from GOV_TC_DB_UNITCOUNT where PK='" + base.PK + "'";
DataSet set = dbo.BackDataSet(strSql, null);
if (!(set.Tables[0].Rows[0][0].ToString() != ""))
{
throw new Exception("没有上级.");
}
string[] strArray2 = set.Tables[0].Rows[0][0].ToString().Split(new char[] { '|' });
string str3 = "";
for (int k = 0; k < strArray2.Length; k++)
{
if (strArray2[k] != "")
{
str3 = str3 + "'" + strArray2[k] + "',";
}
}
builder.Append(" where PK in (" + str3.Substring(0, str3.Length - 1) + ")");
}
DataSet set2 = dbo.BackDataSet(builder.ToString(), null);
if (set2.Tables[0].Rows.Count <= 0)
{
return null;
}
UnitCountModel[] modelArray = new UnitCountModel[set2.Tables[0].Rows.Count];
for (int i = 0; i < set2.Tables[0].Rows.Count; i++)
{
modelArray[i] = new UnitCountModel();
modelArray[i] = this.Getmm(set2.Tables[0].Rows[i], false, dbo);
}
return modelArray;
}
private UnitCountModel Getmm(DataRow dr, bool bj, DB_OPT dbo)
{
UnitCountModel model = new UnitCountModel {
PK = dr["PK"].ToString(),
Name = dr["Name"].ToString(),
Discription = dr["Discription"].ToString(),
FatherPK = dr["FatherPK"].ToString(),
IsHasBaby = dr["IsHasBaby"].ToString(),
BH = dr["BH"].ToString()
};
if (dr["Grade"].ToString() != "")
{
model.CountFactor = int.Parse(dr["CountFactor"].ToString());
}
if (dr["Grade"].ToString() != "")
{
model.Grade = int.Parse(dr["Grade"].ToString());
}
model.PKPath = dr["PKPath"].ToString();
if ((dr["IsHasBaby"].ToString() == "1") && bj)
{
model.ubtm = this.GetChilds(model.PK, dbo);
}
return model;
}
public override UnitCountModel[] GetModels(string strwhere, bool bj, DB_OPT dbo)
{
UnitCountModel[] modelArray = null;
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" * ");
builder.Append(" from GOV_TC_DB_UNITCOUNT ");
if (strwhere.Trim() != "")
{
builder.Append(" where " + strwhere);
}
DataSet set = dbo.BackDataSet(builder.ToString(), null);
if (set.Tables[0].Rows.Count > 0)
{
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;
}
