/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.extend_Environment DataRowToModel(DataRow row)
{
Maticsoft.Model.extend_Environment model=new Maticsoft.Model.extend_Environment();
if (row != null)
{
if(row["EnvironmentID"]!=null && row["EnvironmentID"].ToString()!="")
{
model.EnvironmentID=int.Parse(row["EnvironmentID"].ToString());
}
if(row["E_Kind"]!=null && row["E_Kind"].ToString()!="")
{
model.E_Kind=int.Parse(row["E_Kind"].ToString());
}
if(row["E_Type"]!=null && row["E_Type"].ToString()!="")
{
model.E_Type=int.Parse(row["E_Type"].ToString());
}
if(row["E_UserID"]!=null && row["E_UserID"].ToString()!="")
{
model.E_UserID=int.Parse(row["E_UserID"].ToString());
}
}
return model;
}
protected void extendBtn_Click(object sender, EventArgs e)
{
//扩展信息
//疾病史
Maticsoft.BLL.extend_DiseaseHistory extend_DiseaseHistory_bll = new Maticsoft.BLL.extend_DiseaseHistory();
List<Maticsoft.Model.extend_DiseaseHistory> extend_DiseaseHistory_old_models = extend_DiseaseHistory_bll.GetModelList("DH_UserID = " + UserID);
List<int> DiseaseHistoryIDs = new List<int>();
JsonData jsonData = JsonMapper.ToObject(DiseaseHistory_data.Value);
foreach (JsonData item in jsonData)
{
int DH_Type = (int)item["type"];
Maticsoft.Model.extend_DiseaseHistory extend_DiseaseHistory_model = extend_DiseaseHistory_bll.GetModel(string.Format("DH_Type={0} and DH_UserID={1}", DH_Type, UserID));
if (extend_DiseaseHistory_model == null)
{
extend_DiseaseHistory_model = new Maticsoft.Model.extend_DiseaseHistory();
extend_DiseaseHistory_model.DiseaseHistoryID = 0;
}
extend_DiseaseHistory_model.DH_Type = DH_Type;
extend_DiseaseHistory_model.DH_UserID = UserID;
long time = (long)item["date"];
extend_DiseaseHistory_model.DH_DiagnosisDate = TimeParser.FROM_UNIXTIME(time);
if (DH_Type == 11)
extend_DiseaseHistory_model.DH_Note = DH_Type_11_note.Value;
if (extend_DiseaseHistory_model.DiseaseHistoryID == 0)
extend_DiseaseHistory_model.DiseaseHistoryID = extend_DiseaseHistory_bll.Add(extend_DiseaseHistory_model);
else
extend_DiseaseHistory_bll.Update(extend_DiseaseHistory_model);
DiseaseHistoryIDs.Add(extend_DiseaseHistory_model.DiseaseHistoryID);
}
//如果是取消的则要删除
for (int i = 0; i < extend_DiseaseHistory_old_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < DiseaseHistoryIDs.Count; j++)
{
if (extend_DiseaseHistory_old_models[i].DiseaseHistoryID == DiseaseHistoryIDs[j])
flag = true;
}
if (!flag)
{
extend_DiseaseHistory_bll.Delete(extend_DiseaseHistory_old_models[i].DiseaseHistoryID);
}
}
//遗传病史
Maticsoft.BLL.extend_GeneticDisease extend_GeneticDisease_bll = new Maticsoft.BLL.extend_GeneticDisease();
Maticsoft.Model.extend_GeneticDisease extend_GeneticDisease_model = extend_GeneticDisease_bll.GetModel("GD_UserID=" + UserID);
if (GeneticDisease_check.Checked)
{
if (extend_GeneticDisease_model == null)
{
extend_GeneticDisease_model = new Maticsoft.Model.extend_GeneticDisease();
extend_GeneticDisease_model.GeneticDiseaseID = 0;
}
extend_GeneticDisease_model.GD_Name = GD_Name.Value;
extend_GeneticDisease_model.GD_UserID = UserID;
if (extend_GeneticDisease_model.GeneticDiseaseID == 0)
extend_GeneticDisease_bll.Add(extend_GeneticDisease_model);
else
extend_GeneticDisease_bll.Update(extend_GeneticDisease_model);
}
else
{
if (extend_GeneticDisease_model != null)
extend_GeneticDisease_bll.Delete(extend_GeneticDisease_model.GeneticDiseaseID);
}
//残疾情况
Maticsoft.BLL.extend_Disability extend_Disability_bll = new Maticsoft.BLL.extend_Disability();
List<Maticsoft.Model.extend_Disability> extend_Disability_old_models = extend_Disability_bll.GetModelList("D_UserID=" + UserID);
List<int> DisabilityIDs = new List<int>();
for (int i = 0; i < DisabilityList.Items.Count; i++)
{
Maticsoft.Model.extend_Disability extend_Disability_model = null;
if (DisabilityList.Items[i].Selected)
{
extend_Disability_model = extend_Disability_bll.GetModel(string.Format("D_Type={0} and D_UserID={1}", DisabilityList.Items[i].Value, UserID));
if (extend_Disability_model == null)
{
extend_Disability_model = new Maticsoft.Model.extend_Disability();
extend_Disability_model.DisabilityID = 0;
}
extend_Disability_model.D_Type = Convert.ToInt32(DisabilityList.Items[i].Value);
extend_Disability_model.D_UserID = UserID;
if (DisabilityList.Items[i].Value == "7")
extend_Disability_model.D_Note = D_Note.Value;
if (extend_Disability_model.DisabilityID == 0)
extend_Disability_model.DisabilityID = extend_Disability_bll.Add(extend_Disability_model);
else
extend_Disability_bll.Update(extend_Disability_model);
DisabilityIDs.Add(extend_Disability_model.DisabilityID);
}
}
//如果是取消的则要删除
for (int i = 0; i < extend_Disability_old_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < DisabilityIDs.Count; j++)
{
if (extend_Disability_old_models[i].DisabilityID == DisabilityIDs[j])
flag = true;
}
if (!flag)
{
extend_Disability_bll.Delete(extend_Disability_old_models[i].DisabilityID);
}
}
//家族史
Maticsoft.BLL.extend_FamilyHistory extend_FamilyHistory_bll = new Maticsoft.BLL.extend_FamilyHistory();
//父亲
List<Maticsoft.Model.extend_FamilyHistory> extend_FamilyHistory_father_old_models = extend_FamilyHistory_bll.GetModelList("FH_Who = " + 1);
List<int> FamilyHistoryIDs = new List<int>();
jsonData = JsonMapper.ToObject(fatherDisease_data.Value);
foreach (JsonData item in jsonData)
{
int FH_Type = (int)item["type"];
Maticsoft.Model.extend_FamilyHistory extend_FamilyHistory_model = extend_FamilyHistory_bll.GetModel(string.Format("FH_Type={0} and FH_UserID={1} and FH_Who={2}", FH_Type, UserID, 1));
if (extend_FamilyHistory_model == null)
{
extend_FamilyHistory_model = new Maticsoft.Model.extend_FamilyHistory();
extend_FamilyHistory_model.FamilyHistoryID = 0;
}
extend_FamilyHistory_model.FH_Type = FH_Type;
extend_FamilyHistory_model.FH_Who = 1;
extend_FamilyHistory_model.FH_UserID = UserID;
if (FH_Type == 11)
extend_FamilyHistory_model.FH_Note = father_note.Value;
if (extend_FamilyHistory_model.FamilyHistoryID == 0)
extend_FamilyHistory_model.FamilyHistoryID = extend_FamilyHistory_bll.Add(extend_FamilyHistory_model);
else
extend_FamilyHistory_bll.Update(extend_FamilyHistory_model);
FamilyHistoryIDs.Add(extend_FamilyHistory_model.FamilyHistoryID);
}
//如果是取消的则要删除
for (int i = 0; i < extend_FamilyHistory_father_old_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < FamilyHistoryIDs.Count; j++)
{
if (extend_FamilyHistory_father_old_models[i].FamilyHistoryID == FamilyHistoryIDs[j])
flag = true;
}
if (!flag)
{
extend_FamilyHistory_bll.Delete(extend_FamilyHistory_father_old_models[i].FamilyHistoryID);
}
}
//母亲
List<Maticsoft.Model.extend_FamilyHistory> extend_FamilyHistory_mather_old_models = extend_FamilyHistory_bll.GetModelList("FH_Who = " + 2);
FamilyHistoryIDs = new List<int>();
jsonData = JsonMapper.ToObject(matherDisease_data.Value);
foreach (JsonData item in jsonData)
{
int FH_Type = (int)item["type"];
Maticsoft.Model.extend_FamilyHistory extend_FamilyHistory_model = extend_FamilyHistory_bll.GetModel(string.Format("FH_Type={0} and FH_UserID={1} and FH_Who={2}", FH_Type, UserID, 2));
if (extend_FamilyHistory_model == null)
{
extend_FamilyHistory_model = new Maticsoft.Model.extend_FamilyHistory();
extend_FamilyHistory_model.FamilyHistoryID = 0;
}
extend_FamilyHistory_model.FH_Type = FH_Type;
extend_FamilyHistory_model.FH_Who = 2;
extend_FamilyHistory_model.FH_UserID = UserID;
if (FH_Type == 11)
extend_FamilyHistory_model.FH_Note = mather_note.Value;
if (extend_FamilyHistory_model.FamilyHistoryID == 0)
extend_FamilyHistory_model.FamilyHistoryID = extend_FamilyHistory_bll.Add(extend_FamilyHistory_model);
else
extend_FamilyHistory_bll.Update(extend_FamilyHistory_model);
FamilyHistoryIDs.Add(extend_FamilyHistory_model.FamilyHistoryID);
}
//如果是取消的则要删除
for (int i = 0; i < extend_FamilyHistory_mather_old_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < FamilyHistoryIDs.Count; j++)
{
if (extend_FamilyHistory_mather_old_models[i].FamilyHistoryID == FamilyHistoryIDs[j])
flag = true;
}
if (!flag)
{
extend_FamilyHistory_bll.Delete(extend_FamilyHistory_mather_old_models[i].FamilyHistoryID);
}
}
//兄弟姐妹
List<Maticsoft.Model.extend_FamilyHistory> extend_FamilyHistory_brothers_old_models = extend_FamilyHistory_bll.GetModelList("FH_Who = " + 3);
FamilyHistoryIDs = new List<int>();
jsonData = JsonMapper.ToObject(brothersDisease_data.Value);
foreach (JsonData item in jsonData)
{
int FH_Type = (int)item["type"];
Maticsoft.Model.extend_FamilyHistory extend_FamilyHistory_model = extend_FamilyHistory_bll.GetModel(string.Format("FH_Type={0} and FH_UserID={1} and FH_Who={2}", FH_Type, UserID, 3));
if (extend_FamilyHistory_model == null)
{
extend_FamilyHistory_model = new Maticsoft.Model.extend_FamilyHistory();
extend_FamilyHistory_model.FamilyHistoryID = 0;
}
extend_FamilyHistory_model.FH_Type = FH_Type;
extend_FamilyHistory_model.FH_Who = 3;
extend_FamilyHistory_model.FH_UserID = UserID;
if (FH_Type == 11)
extend_FamilyHistory_model.FH_Note = brothers_note.Value;
if (extend_FamilyHistory_model.FamilyHistoryID == 0)
extend_FamilyHistory_model.FamilyHistoryID = extend_FamilyHistory_bll.Add(extend_FamilyHistory_model);
else
extend_FamilyHistory_bll.Update(extend_FamilyHistory_model);
FamilyHistoryIDs.Add(extend_FamilyHistory_model.FamilyHistoryID);
}
//如果是取消的则要删除
for (int i = 0; i < extend_FamilyHistory_brothers_old_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < FamilyHistoryIDs.Count; j++)
{
if (extend_FamilyHistory_brothers_old_models[i].FamilyHistoryID == FamilyHistoryIDs[j])
flag = true;
}
if (!flag)
{
extend_FamilyHistory_bll.Delete(extend_FamilyHistory_brothers_old_models[i].FamilyHistoryID);
}
}
//子女
List<Maticsoft.Model.extend_FamilyHistory> extend_FamilyHistory_children_old_models = extend_FamilyHistory_bll.GetModelList("FH_Who = " + 4);
FamilyHistoryIDs = new List<int>();
jsonData = JsonMapper.ToObject(childrenDisease_data.Value);
foreach (JsonData item in jsonData)
{
int FH_Type = (int)item["type"];
Maticsoft.Model.extend_FamilyHistory extend_FamilyHistory_model = extend_FamilyHistory_bll.GetModel(string.Format("FH_Type={0} and FH_UserID={1} and FH_Who={2}", FH_Type, UserID, 4));
if (extend_FamilyHistory_model == null)
{
extend_FamilyHistory_model = new Maticsoft.Model.extend_FamilyHistory();
extend_FamilyHistory_model.FamilyHistoryID = 0;
}
extend_FamilyHistory_model.FH_Type = FH_Type;
extend_FamilyHistory_model.FH_Who = 4;
extend_FamilyHistory_model.FH_UserID = UserID;
if (FH_Type == 11)
extend_FamilyHistory_model.FH_Note = children_note.Value;
if (extend_FamilyHistory_model.FamilyHistoryID == 0)
extend_FamilyHistory_model.FamilyHistoryID = extend_FamilyHistory_bll.Add(extend_FamilyHistory_model);
else
extend_FamilyHistory_bll.Update(extend_FamilyHistory_model);
FamilyHistoryIDs.Add(extend_FamilyHistory_model.FamilyHistoryID);
}
//如果是取消的则要删除
for (int i = 0; i < extend_FamilyHistory_children_old_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < FamilyHistoryIDs.Count; j++)
{
if (extend_FamilyHistory_children_old_models[i].FamilyHistoryID == FamilyHistoryIDs[j])
flag = true;
}
if (!flag)
{
extend_FamilyHistory_bll.Delete(extend_FamilyHistory_children_old_models[i].FamilyHistoryID);
}
}
//生活环境
Maticsoft.BLL.extend_Environment extend_Environment_bll = new Maticsoft.BLL.extend_Environment();
//厨房排风设施
int kind1 = 1;
List<Maticsoft.Model.extend_Environment> extend_Environment_kind1_models = extend_Environment_bll.GetModelList(string.Format("E_UserID = {0} and E_Kind={1}", UserID, kind1));
List<int> kindIDs = new List<int>();
for (int i = 0; i < E_Kind1.Items.Count; i++)
{
Maticsoft.Model.extend_Environment extend_Environment_model = null;
if (E_Kind1.Items[i].Selected)
{
extend_Environment_model = extend_Environment_bll.GetModel(string.Format("E_Kind = {0} and E_Type={1} and E_UserID={2}", kind1, E_Kind1.Items[i].Value, UserID));
if (extend_Environment_model == null)
{
extend_Environment_model = new Maticsoft.Model.extend_Environment();
extend_Environment_model.EnvironmentID = 0;
}
extend_Environment_model.E_Kind = kind1;
extend_Environment_model.E_Type = Convert.ToInt32(E_Kind1.Items[i].Value);
extend_Environment_model.E_UserID = UserID;
if (extend_Environment_model.EnvironmentID == 0)
extend_Environment_model.EnvironmentID = extend_Environment_bll.Add(extend_Environment_model);
else
extend_Environment_bll.Update(extend_Environment_model);
kindIDs.Add(extend_Environment_model.EnvironmentID);
}
}
//如果是取消的则要删除
for (int i = 0; i < extend_Environment_kind1_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < kindIDs.Count; j++)
{
if (extend_Environment_kind1_models[i].EnvironmentID == kindIDs[j])
flag = true;
}
if (!flag)
{
extend_Environment_bll.Delete(extend_Environment_kind1_models[i].EnvironmentID);
}
}
//燃料类型
int kind2 = 2;
List<Maticsoft.Model.extend_Environment> extend_Environment_kind2_models = extend_Environment_bll.GetModelList(string.Format("E_UserID = {0} and E_Kind={1}", UserID, kind2));
kindIDs = new List<int>();
for (int i = 0; i < E_Kind2.Items.Count; i++)
{
Maticsoft.Model.extend_Environment extend_Environment_model = null;
if (E_Kind2.Items[i].Selected)
{
extend_Environment_model = extend_Environment_bll.GetModel(string.Format("E_Kind = {0} and E_Type={1} and E_UserID={2}", kind2, E_Kind2.Items[i].Value, UserID));
if (extend_Environment_model == null)
{
extend_Environment_model = new Maticsoft.Model.extend_Environment();
extend_Environment_model.EnvironmentID = 0;
}
extend_Environment_model.E_Kind = kind2;
extend_Environment_model.E_Type = Convert.ToInt32(E_Kind2.Items[i].Value);
extend_Environment_model.E_UserID = UserID;
if (extend_Environment_model.EnvironmentID == 0)
extend_Environment_model.EnvironmentID = extend_Environment_bll.Add(extend_Environment_model);
else
extend_Environment_bll.Update(extend_Environment_model);
kindIDs.Add(extend_Environment_model.EnvironmentID);
}
}
//如果是取消的则要删除
for (int i = 0; i < extend_Environment_kind2_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < kindIDs.Count; j++)
{
if (extend_Environment_kind2_models[i].EnvironmentID == kindIDs[j])
flag = true;
}
if (!flag)
{
extend_Environment_bll.Delete(extend_Environment_kind2_models[i].EnvironmentID);
}
}
//饮水
int kind3 = 3;
List<Maticsoft.Model.extend_Environment> extend_Environment_kind3_models = extend_Environment_bll.GetModelList(string.Format("E_UserID = {0} and E_Kind={1}", UserID, kind3));
kindIDs = new List<int>();
for (int i = 0; i < E_Kind3.Items.Count; i++)
{
Maticsoft.Model.extend_Environment extend_Environment_model = null;
if (E_Kind3.Items[i].Selected)
{
extend_Environment_model = extend_Environment_bll.GetModel(string.Format("E_Kind = {0} and E_Type={1} and E_UserID={2}", kind3, E_Kind3.Items[i].Value, UserID));
if (extend_Environment_model == null)
{
extend_Environment_model = new Maticsoft.Model.extend_Environment();
extend_Environment_model.EnvironmentID = 0;
}
extend_Environment_model.E_Kind = kind3;
extend_Environment_model.E_Type = Convert.ToInt32(E_Kind3.Items[i].Value);
extend_Environment_model.E_UserID = UserID;
if (extend_Environment_model.EnvironmentID == 0)
extend_Environment_model.EnvironmentID = extend_Environment_bll.Add(extend_Environment_model);
else
extend_Environment_bll.Update(extend_Environment_model);
kindIDs.Add(extend_Environment_model.EnvironmentID);
}
}
//如果是取消的则要删除
for (int i = 0; i < extend_Environment_kind3_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < kindIDs.Count; j++)
{
if (extend_Environment_kind3_models[i].EnvironmentID == kindIDs[j])
flag = true;
}
if (!flag)
{
extend_Environment_bll.Delete(extend_Environment_kind3_models[i].EnvironmentID);
}
}
//厕所
int kind4 = 4;
List<Maticsoft.Model.extend_Environment> extend_Environment_kind4_models = extend_Environment_bll.GetModelList(string.Format("E_UserID = {0} and E_Kind={1}", UserID, kind4));
kindIDs = new List<int>();
for (int i = 0; i < E_Kind4.Items.Count; i++)
{
Maticsoft.Model.extend_Environment extend_Environment_model = null;
if (E_Kind4.Items[i].Selected)
{
extend_Environment_model = extend_Environment_bll.GetModel(string.Format("E_Kind = {0} and E_Type={1} and E_UserID={2}", kind4, E_Kind4.Items[i].Value, UserID));
if (extend_Environment_model == null)
{
extend_Environment_model = new Maticsoft.Model.extend_Environment();
extend_Environment_model.EnvironmentID = 0;
}
extend_Environment_model.E_Kind = kind4;
extend_Environment_model.E_Type = Convert.ToInt32(E_Kind4.Items[i].Value);
extend_Environment_model.E_UserID = UserID;
if (extend_Environment_model.EnvironmentID == 0)
extend_Environment_model.EnvironmentID = extend_Environment_bll.Add(extend_Environment_model);
else
extend_Environment_bll.Update(extend_Environment_model);
kindIDs.Add(extend_Environment_model.EnvironmentID);
}
}
//如果是取消的则要删除
for (int i = 0; i < extend_Environment_kind4_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < kindIDs.Count; j++)
{
if (extend_Environment_kind4_models[i].EnvironmentID == kindIDs[j])
flag = true;
}
if (!flag)
{
extend_Environment_bll.Delete(extend_Environment_kind4_models[i].EnvironmentID);
}
}
//禽畜栏
int kind5 = 5;
List<Maticsoft.Model.extend_Environment> extend_Environment_kind5_models = extend_Environment_bll.GetModelList(string.Format("E_UserID = {0} and E_Kind={1}", UserID, kind5));
kindIDs = new List<int>();
for (int i = 0; i < E_Kind5.Items.Count; i++)
{
Maticsoft.Model.extend_Environment extend_Environment_model = null;
if (E_Kind5.Items[i].Selected)
{
extend_Environment_model = extend_Environment_bll.GetModel(string.Format("E_Kind = {0} and E_Type={1} and E_UserID={2}", kind5, E_Kind5.Items[i].Value, UserID));
if (extend_Environment_model == null)
{
extend_Environment_model = new Maticsoft.Model.extend_Environment();
extend_Environment_model.EnvironmentID = 0;
}
extend_Environment_model.E_Kind = kind5;
extend_Environment_model.E_Type = Convert.ToInt32(E_Kind5.Items[i].Value);
extend_Environment_model.E_UserID = UserID;
if (extend_Environment_model.EnvironmentID == 0)
extend_Environment_model.EnvironmentID = extend_Environment_bll.Add(extend_Environment_model);
else
extend_Environment_bll.Update(extend_Environment_model);
kindIDs.Add(extend_Environment_model.EnvironmentID);
}
}
//如果是取消的则要删除
for (int i = 0; i < extend_Environment_kind5_models.Count; i++)
{
bool flag = false;
for (int j = 0; j < kindIDs.Count; j++)
{
if (extend_Environment_kind5_models[i].EnvironmentID == kindIDs[j])
flag = true;
}
if (!flag)
{
extend_Environment_bll.Delete(extend_Environment_kind5_models[i].EnvironmentID);
}
}
Maticsoft.BLL.record_UserBaseInfo record_UserBaseInfo_bll = new Maticsoft.BLL.record_UserBaseInfo();
Maticsoft.Model.record_UserBaseInfo record_UserBaseInfo_model = record_UserBaseInfo_bll.GetModel(UserID);
if (record_UserBaseInfo_model != null)
{
record_UserBaseInfo_model.U_Note = U_Note.Value;
record_UserBaseInfo_bll.Update(record_UserBaseInfo_model);
}
All_Title_Txt = CMD_Txt + App_Txt;
EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", UserID, All_Title_Txt), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.extend_Environment GetModel(int EnvironmentID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 EnvironmentID,E_Kind,E_Type,E_UserID from extend_Environment ");
strSql.Append(" where EnvironmentID=@EnvironmentID");
SqlParameter[] parameters = {
new SqlParameter("@EnvironmentID", SqlDbType.Int,4)
};
parameters[0].Value = EnvironmentID;
Maticsoft.Model.extend_Environment model=new Maticsoft.Model.extend_Environment();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}