private void OnAddFamilyExecute(ListBox list)
{
if (FamilyName != null & FamilyCardID != null & FamilyMark != null & FamilyRelationship != null & CBFBM != null)
{
CBF_JTCYModels Family = new CBF_JTCYModels();
Family.ID = CBFBM;
Family.Name = FamilyName;
if (FamilySex == "男")
{
Family.Sex = "1";
}
else
{
Family.Sex = "2";
}
// Family.CertificateType = PropertyCodeEnumModels.CertificateType.IDCard;
#region 设置证件类型枚举值
switch (CardType)
{
case "身份证":
Family.CertificateType = "1";
break;
case "军官证":
Family.CertificateType = "2";
break;
case "行政企事业单位机构代码证或法人代码证":
Family.CertificateType = "3";
break;
case "户口簿":
Family.CertificateType = "4";
break;
case "护照":
Family.CertificateType = "5";
break;
default:
Family.CertificateType = "其他";
break;
}
#endregion
//Family.CertificateType = CardType;
Family.CardNumber = FamilyCardID;
Family.RelationShip = FamilyRelationship;
Family.Note = FamilyMark;
Family.IsShared = SFGYR;
FamilyCollection.Add(Family);
FamilyCardID = null;
FamilyMark = null;
FamilyName = null;
FamilySex = null;
FamilyRelationship = null;
}
else
{
MessageBox.Show("天剑出错，请检查表单数据的完整性与正确性");
}
}
public ObservableCollection <CBF_JTCYModels> GetAllFamily(CBFModels model)
{
OracleConnection con = new OracleConnection(connectString);
string sql = string.Format("SELECT * FROM CBF_JTCY WHERE CBFBM='{0}'", model.ID);
OracleCommand cmd = new OracleCommand(sql, con);
ObservableCollection <CBF_JTCYModels> CBF = new ObservableCollection <CBF_JTCYModels>();
try
{
con.Open();
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CBF_JTCYModels CBF_JT = new CBF_JTCYModels();
CBF_JT.ID = reader["CBFBM"].ToString();
CBF_JT.Name = reader["CYXM"].ToString();
CBF_JT.Sex = reader["CYXB"].ToString();
#region 设置证件类型枚举值
switch (reader["CYZJLX"].ToString())
{
case "1":
CBF_JT.CertificateType = "身份证";
break;
case "2":
CBF_JT.CertificateType = "军官证";
break;
case "3":
CBF_JT.CertificateType = "行政企事业单位机构代码证或法人代码证";
break;
case "4":
CBF_JT.CertificateType = "户口簿";
break;
case "5":
CBF_JT.CertificateType = "护照";
break;
default:
CBF_JT.CertificateType = "其他";
break;
}
#endregion
CBF_JT.CardNumber = reader["CYZJHM"].ToString();
CBF_JT.RelationShip = reader["YHZGX"].ToString();
CBF_JT.Note = reader["CYBZ"].ToString();
CBF_JT.IsShared = reader["SFGYR"].ToString();
CBF.Add(CBF_JT);
}
return(CBF);
}
catch
{
MessageBox.Show("系统查询出错");
return(null);
}
finally
{
con.Close();
}
}
/// <summary>
/// 添加承包方家庭成员
/// </summary>
public void OnFamilyDeleteExecuted(CBF_JTCYModels model)
{
FamilyCollection.Remove(model);
}
