public Model.Member_BaseInfo GetModelByAccountId(int AccountId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id, CredentialsType, CredentialsNumber, Sex, Birthday, Nation, PoliticalStatus, Delflag, CreateDate, RegionId, StudySection, AccountId, Organid, Job, WorkRank, TeachDate, TeachStudySection, TeachSubject, TeachGrade, TraningType, TraningObject, EduLevel, TeacherNo, EduDegree, EduMajor, EduMajorOhter, GraduateSchool, GraduateTime, GroupId, RealName, Mobile, Phone, Address, PostCode ");
strSql.Append(" from Member_BaseInfo ");
strSql.Append(" where ");
strSql.Append(" AccountId = @AccountId and Delflag='false' ");
SqlParameter[] parameters = {
new SqlParameter("@AccountId", SqlDbType.Int,4)
};
parameters[0].Value = AccountId;
Model.Member_BaseInfo model = new Model.Member_BaseInfo();
DataSet ds = MSEntLibSqlHelper.ExecuteDataSetBySql(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["CredentialsType"].ToString() != "")
{
model.CredentialsType = int.Parse(ds.Tables[0].Rows[0]["CredentialsType"].ToString());
}
model.CredentialsNumber = ds.Tables[0].Rows[0]["CredentialsNumber"].ToString();
if (ds.Tables[0].Rows[0]["Sex"].ToString() != "")
{
model.Sex = int.Parse(ds.Tables[0].Rows[0]["Sex"].ToString());
}
if (ds.Tables[0].Rows[0]["Birthday"].ToString() != "")
{
model.Birthday = DateTime.Parse(ds.Tables[0].Rows[0]["Birthday"].ToString());
}
if (ds.Tables[0].Rows[0]["Nation"].ToString() != "")
{
model.Nation = int.Parse(ds.Tables[0].Rows[0]["Nation"].ToString());
}
if (ds.Tables[0].Rows[0]["PoliticalStatus"].ToString() != "")
{
model.PoliticalStatus = int.Parse(ds.Tables[0].Rows[0]["PoliticalStatus"].ToString());
}
if (ds.Tables[0].Rows[0]["Delflag"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["Delflag"].ToString() == "1") || (ds.Tables[0].Rows[0]["Delflag"].ToString().ToLower() == "true"))
{
model.Delflag = true;
}
else
{
model.Delflag = false;
}
}
if (ds.Tables[0].Rows[0]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(ds.Tables[0].Rows[0]["CreateDate"].ToString());
}
if (ds.Tables[0].Rows[0]["RegionId"].ToString() != "")
{
model.RegionId = int.Parse(ds.Tables[0].Rows[0]["RegionId"].ToString());
}
model.StudySection = ds.Tables[0].Rows[0]["StudySection"].ToString();
if (ds.Tables[0].Rows[0]["AccountId"].ToString() != "")
{
model.AccountId = int.Parse(ds.Tables[0].Rows[0]["AccountId"].ToString());
}
if (ds.Tables[0].Rows[0]["Organid"].ToString() != "")
{
model.Organid = int.Parse(ds.Tables[0].Rows[0]["Organid"].ToString());
}
if (ds.Tables[0].Rows[0]["Job"].ToString() != "")
{
model.Job = int.Parse(ds.Tables[0].Rows[0]["Job"].ToString());
}
if (ds.Tables[0].Rows[0]["WorkRank"].ToString() != "")
{
model.WorkRank = int.Parse(ds.Tables[0].Rows[0]["WorkRank"].ToString());
}
if (ds.Tables[0].Rows[0]["TeachDate"].ToString() != "")
{
model.TeachDate = DateTime.Parse(ds.Tables[0].Rows[0]["TeachDate"].ToString());
}
model.TeachStudySection = ds.Tables[0].Rows[0]["TeachStudySection"].ToString();
model.TeachSubject = ds.Tables[0].Rows[0]["TeachSubject"].ToString();
model.TeachGrade = ds.Tables[0].Rows[0]["TeachGrade"].ToString();
if (ds.Tables[0].Rows[0]["TraningType"].ToString() != "")
{
model.TraningType = int.Parse(ds.Tables[0].Rows[0]["TraningType"].ToString());
}
if (ds.Tables[0].Rows[0]["TraningObject"].ToString() != "")
{
model.TraningObject = int.Parse(ds.Tables[0].Rows[0]["TraningObject"].ToString());
}
if (ds.Tables[0].Rows[0]["EduLevel"].ToString() != "")
{
model.EduLevel = int.Parse(ds.Tables[0].Rows[0]["EduLevel"].ToString());
}
model.TeacherNo = ds.Tables[0].Rows[0]["TeacherNo"].ToString();
if (ds.Tables[0].Rows[0]["EduDegree"].ToString() != "")
{
model.EduDegree = int.Parse(ds.Tables[0].Rows[0]["EduDegree"].ToString());
}
if (ds.Tables[0].Rows[0]["EduMajor"].ToString() != "")
{
model.EduMajor = int.Parse(ds.Tables[0].Rows[0]["EduMajor"].ToString());
}
model.EduMajorOhter = ds.Tables[0].Rows[0]["EduMajorOhter"].ToString();
model.GraduateSchool = ds.Tables[0].Rows[0]["GraduateSchool"].ToString();
if (ds.Tables[0].Rows[0]["GraduateTime"].ToString() != "")
{
model.GraduateTime = DateTime.Parse(ds.Tables[0].Rows[0]["GraduateTime"].ToString());
}
if (ds.Tables[0].Rows[0]["GroupId"].ToString() != "")
{
model.GroupId = int.Parse(ds.Tables[0].Rows[0]["GroupId"].ToString());
}
model.RealName = ds.Tables[0].Rows[0]["RealName"].ToString();
model.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString();
model.Phone = ds.Tables[0].Rows[0]["Phone"].ToString();
model.Address = ds.Tables[0].Rows[0]["Address"].ToString();
model.PostCode = ds.Tables[0].Rows[0]["PostCode"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得数据列表
/// </summary>
public List<Model.Member_BaseInfo> DataTableToList(DataTable dt)
{
List<Model.Member_BaseInfo> modelList = new List<Model.Member_BaseInfo>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Model.Member_BaseInfo model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.Member_BaseInfo();
if (dt.Rows[n]["Id"].ToString() != "")
{
model.Id = int.Parse(dt.Rows[n]["Id"].ToString());
}
if (dt.Rows[n]["CredentialsType"].ToString() != "")
{
model.CredentialsType = int.Parse(dt.Rows[n]["CredentialsType"].ToString());
}
model.CredentialsNumber = dt.Rows[n]["CredentialsNumber"].ToString();
if (dt.Rows[n]["Sex"].ToString() != "")
{
model.Sex = int.Parse(dt.Rows[n]["Sex"].ToString());
}
if (dt.Rows[n]["Birthday"].ToString() != "")
{
model.Birthday = DateTime.Parse(dt.Rows[n]["Birthday"].ToString());
}
if (dt.Rows[n]["Nation"].ToString() != "")
{
model.Nation = int.Parse(dt.Rows[n]["Nation"].ToString());
}
if (dt.Rows[n]["PoliticalStatus"].ToString() != "")
{
model.PoliticalStatus = int.Parse(dt.Rows[n]["PoliticalStatus"].ToString());
}
if (dt.Rows[n]["Delflag"].ToString() != "")
{
if ((dt.Rows[n]["Delflag"].ToString() == "1") || (dt.Rows[n]["Delflag"].ToString().ToLower() == "true"))
{
model.Delflag = true;
}
else
{
model.Delflag = false;
}
}
if (dt.Rows[n]["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(dt.Rows[n]["CreateDate"].ToString());
}
if (dt.Rows[n]["RegionId"].ToString() != "")
{
model.RegionId = int.Parse(dt.Rows[n]["RegionId"].ToString());
}
model.StudySection = dt.Rows[n]["StudySection"].ToString();
if (dt.Rows[n]["AccountId"].ToString() != "")
{
model.AccountId = int.Parse(dt.Rows[n]["AccountId"].ToString());
}
if (dt.Rows[n]["Organid"].ToString() != "")
{
model.Organid = int.Parse(dt.Rows[n]["Organid"].ToString());
}
if (dt.Rows[n]["Job"].ToString() != "")
{
model.Job = int.Parse(dt.Rows[n]["Job"].ToString());
}
if (dt.Rows[n]["WorkRank"].ToString() != "")
{
model.WorkRank = int.Parse(dt.Rows[n]["WorkRank"].ToString());
}
if (dt.Rows[n]["TeachDate"].ToString() != "")
{
model.TeachDate = DateTime.Parse(dt.Rows[n]["TeachDate"].ToString());
}
model.TeachStudySection = dt.Rows[n]["TeachStudySection"].ToString();
model.TeachSubject = dt.Rows[n]["TeachSubject"].ToString();
model.TeachGrade = dt.Rows[n]["TeachGrade"].ToString();
if (dt.Rows[n]["TraningType"].ToString() != "")
{
model.TraningType = int.Parse(dt.Rows[n]["TraningType"].ToString());
}
if (dt.Rows[n]["TraningObject"].ToString() != "")
{
model.TraningObject = int.Parse(dt.Rows[n]["TraningObject"].ToString());
}
if (dt.Rows[n]["EduLevel"].ToString() != "")
{
model.EduLevel = int.Parse(dt.Rows[n]["EduLevel"].ToString());
}
model.TeacherNo = dt.Rows[n]["TeacherNo"].ToString();
if (dt.Rows[n]["EduDegree"].ToString() != "")
{
model.EduDegree = int.Parse(dt.Rows[n]["EduDegree"].ToString());
}
if (dt.Rows[n]["EduMajor"].ToString() != "")
{
model.EduMajor = int.Parse(dt.Rows[n]["EduMajor"].ToString());
}
model.EduMajorOhter = dt.Rows[n]["EduMajorOhter"].ToString();
model.GraduateSchool = dt.Rows[n]["GraduateSchool"].ToString();
if (dt.Rows[n]["GraduateTime"].ToString() != "")
{
model.GraduateTime = DateTime.Parse(dt.Rows[n]["GraduateTime"].ToString());
}
if (dt.Rows[n]["GroupId"].ToString() != "")
{
model.GroupId = int.Parse(dt.Rows[n]["GroupId"].ToString());
}
model.RealName = dt.Rows[n]["RealName"].ToString();
model.Mobile = dt.Rows[n]["Mobile"].ToString();
model.Phone = dt.Rows[n]["Phone"].ToString();
model.Address = dt.Rows[n]["Address"].ToString();
model.PostCode = dt.Rows[n]["PostCode"].ToString();
modelList.Add(model);
}
}
return modelList;
}
