public override EmployeeModel[] GetChilds(string parentpk, bool bj_company, bool bj_branch, bool bj_role, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append(this.GetSql());
if (parentpk != "")
{
builder.Append(" where FatherPK='" + parentpk + "'");
}
builder.Append(" order by EmployeePK");
DataSet set = dbo.BackDataSet(builder.ToString(), null);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
EmployeeModel[] modelArray = new EmployeeModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new EmployeeModel();
modelArray[i] = this.Getem(set.Tables[0].Rows[i], true, false, bj_company, bj_branch, bj_role, dbo);
}
return modelArray;
}
private EmployeeModel Getem(DataRow dr, bool bj_child, bool bj_father, bool bj_company, bool bj_branch, bool bj_role, DB_OPT dbo)
{
EmployeeModel model = new EmployeeModel();
if (bj_father)
{
model.BranchPK = dr["FatherPK"].ToString();
model.FatherInfo = model.GetModel(false, false, false, false, true, dbo);
}
model.BranchPK = dr["BranchPK"].ToString().Trim();
if (bj_branch)
{
BranchModel model2 = new BranchDal
{
BranchPK = dr["BranchPK"].ToString()
};
model2 = model2.GetModel(false, false, false, false, dbo);
model.Branch = model2;
}
model.RolePK = dr["RolePK"].ToString().Trim();
if (bj_role)
{
RoleModel model3 = new RoleDal
{
RolePK = dr["RolePK"].ToString()
};
model3 = model3.GetModel(false, false, dbo);
model.Role = model3;
}
model.BH = dr["BH"].ToString();
model.Name = dr["Name"].ToString();
model.CardNum = dr["CardNum"].ToString();
model.Sex = dr["Sex"].ToString();
if (dr["Age"].ToString() != "")
{
model.Age = int.Parse(dr["Age"].ToString());
}
if (dr["WorkAge"].ToString() != "")
{
model.WorkAge = int.Parse(dr["WorkAge"].ToString());
}
if (dr["BirthDay"].ToString() != "")
{
model.BirthDay = DateTime.Parse(dr["BirthDay"].ToString());
}
model.MZ = dr["MZ"].ToString();
model.Nationals = dr["Nationals"].ToString();
model.Province = dr["Province"].ToString();
model.Area = dr["Area"].ToString();
model.City = dr["City"].ToString();
model.Address = dr["Address"].ToString();
model.PostalCode = dr["PostalCode"].ToString();
model.OfficePhone = dr["OfficePhone"].ToString();
model.Phone = dr["Phone"].ToString();
model.Mobile1 = dr["Mobile1"].ToString();
model.Mobile2 = dr["Mobile2"].ToString();
model.Mobile3 = dr["Mobile3"].ToString();
model.QQNum = dr["QQNum"].ToString();
model.ICQNum = dr["ICQNum"].ToString();
model.MSNNum = dr["MSNNum"].ToString();
model.Email = dr["Email"].ToString();
model.OtherLink = dr["OtherLink"].ToString();
model.pk_corp = dr["pk_corp"].ToString();
if (bj_company)
{
CompanyModel model4 = new CompanyDal
{
pk_corp = dr["pk_corp"].ToString()
};
model4 = model4.GetModel(false, false, false, dbo);
model.Company = model4;
}
model.FatherPK = dr["FatherPK"].ToString().Trim();
model.IsHasBaby = dr["IsHasBaby"].ToString();
if (dr["Grade"].ToString() != "")
{
model.Grade = int.Parse(dr["Grade"].ToString());
}
model.PKPath = dr["PKPath"].ToString();
if ((dr["IsHasBaby"].ToString() == "1") && bj_child)
{
this.GetChilds(model.EmployeePK, false, false, false, dbo);
}
return model;
}
public override EmployeeModel[] GetModels(string strwhere, bool bj_child, bool bj_father, bool bj_company, bool bj_branch, bool bj_role, DB_OPT dbo)
{
EmployeeModel[] modelArray = null;
StringBuilder builder = new StringBuilder();
builder.Append(this.GetSql());
if (strwhere.Trim() != "")
{
builder.Append(" where " + strwhere);
}
builder.Append(" order by EmployeePK");
DataSet set = dbo.BackDataSet(builder.ToString(), null);
if (set.Tables[0].Rows.Count > 0)
{
modelArray = new EmployeeModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new EmployeeModel();
modelArray[i] = this.Getem(set.Tables[0].Rows[i], bj_child, bj_father, bj_company, bj_branch, bj_role, dbo);
}
}
return modelArray;
}
public override EmployeeModel[] GetParents(bool bj_company, bool bj_branch, bool bj_role, DB_OPT dbo)
{
string[] strArray;
string str;
int num;
StringBuilder builder = new StringBuilder();
builder.Append(this.GetSql());
if (base.PKPath != "")
{
strArray = base.PKPath.Split(new char[] { '|' });
str = "";
for (num = 0; num < strArray.Length; num++)
{
str = str + "'" + strArray[num] + "',";
}
if (str.Length > 0)
{
str = str.Substring(0, str.Length - 1);
}
builder.Append(" where EmployeePK in (" + str + ")");
}
else
{
if (!(base.EmployeePK != ""))
{
throw new Exception("条件不足.");
}
string strSql = "select PKPath from Employee where EmployeePK='" + base.EmployeePK + "'";
DataSet set = dbo.BackDataSet(strSql, null);
if (!(set.Tables[0].Rows[0][0].ToString() != ""))
{
throw new Exception("没有上级.");
}
strArray = set.Tables[0].Rows[0][0].ToString().Split(new char[] { '|' });
str = "";
for (num = 0; num < strArray.Length; num++)
{
str = str + "'" + strArray[num] + "',";
}
builder.Append(" where EmployeePK in (" + str.Substring(0, str.Length - 1) + ")");
}
builder.Append(" order by EmployeePK");
DataSet set2 = dbo.BackDataSet(builder.ToString(), null);
if (set2.Tables[0].Rows.Count <= 0)
{
return null;
}
EmployeeModel[] modelArray = new EmployeeModel[set2.Tables[0].Rows.Count];
for (num = 0; num < set2.Tables[0].Rows.Count; num++)
{
modelArray[num] = new EmployeeModel();
modelArray[num] = this.Getem(set2.Tables[0].Rows[num], false, true, bj_company, bj_branch, bj_role, dbo);
}
return modelArray;
}
public override EmployeeModel[] GetEgality(bool bj_child, bool bj_father, bool bj_company, bool bj_branch, bool bj_role, DB_OPT dbo)
{
StringBuilder builder = new StringBuilder();
builder.Append(this.GetSql());
if (base.Grade >= 0)
{
builder.Append(" where Grade='" + base.Grade + "'");
}
else
{
if (base.EmployeePK == "")
{
throw new Exception("条件不足.");
}
builder.Append(" where Grade=(select Grade from Employee where EmployeePK='" + base.EmployeePK + "')");
}
builder.Append(" order by EmployeePK");
DataSet set = dbo.BackDataSet(builder.ToString(), null);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
EmployeeModel[] modelArray = new EmployeeModel[set.Tables[0].Rows.Count];
for (int i = 0; i < set.Tables[0].Rows.Count; i++)
{
modelArray[i] = new EmployeeModel();
modelArray[i] = this.Getem(set.Tables[0].Rows[i], bj_child, bj_father, bj_company, bj_branch, bj_role, dbo);
}
return modelArray;
}