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