private void BindChildNode(TreeNode tnTop)
{
dbvwNumberInfo vw = new dbvwNumberInfo();
dbtblNumberInfo num = new dbtblNumberInfo();
int i = Convert.ToInt32(tnTop.Tag.ToString());
int t_sex = num.GetPersonSex(i);
if (t_sex == 1)//女族人
{
DataTable db = num.MotherGetChilDataTable(i);
for (int j = 0; j < db.Rows.Count; j++)
{
TreeNode node = new TreeNode();
node.Tag = db.Rows[j]["NiId"];
if (num.GetPersonSex(Convert.ToInt32(db.Rows[j]["NiId"])) == 1)
{
node.Text = "女:" + db.Rows[j]["NiName"].ToString();
}
else
{
node.Text = "男:" + db.Rows[j]["NiName"].ToString();
}
tnTop.Nodes.Add(node);
if (num.GetChildCount(i) != 0)
{
BindChildNode(node);
}
}
}
else if (t_sex == 0)//女族人
{
DataTable db = num.FatherGetChilDataTable(i);
for (int j = 0; j < db.Rows.Count; j++)
{
TreeNode node = new TreeNode();
node.Tag = db.Rows[j]["NiId"];
if (num.GetPersonSex(Convert.ToInt32(db.Rows[j]["NiId"])) == 1)
{
node.Text = "女:" + db.Rows[j]["NiName"].ToString();
}
else
{
node.Text = "男:" + db.Rows[j]["NiName"].ToString();
}
tnTop.Nodes.Add(node);
if (num.GetChildCount(i) != 0)
{
BindChildNode(node);
}
}
}
}
private void Delete(int i)
{
dbtblNumberInfo num = new dbtblNumberInfo();
int t_sex = num.GetPersonSex(i);
num.CarryOutSqlSentence("delete from [Family].[dbo].[tblNumberInfo] where NiId=" + i);
num.CarryOutSqlSentence("delete from [Family].[dbo].[tblNumberInfo] where NiSpouseId = " + i);
if (t_sex == 1) //女族人
{
DataTable db = num.MotherGetChilDataTable(i);
for (int j = 0; j < db.Rows.Count; j++)
{
if (num.GetChildCount(j, t_sex) != 0)
{
Delete(Convert.ToInt32(db.Rows[j]["NiId"]));
}
num.CarryOutSqlSentence("delete from [Family].[dbo].[tblNumberInfo] where NiId=" + db.Rows[j]["NiId"].ToString());
num.CarryOutSqlSentence("delete from [Family].[dbo].[tblNumberInfo] where NiSpouseId = " + db.Rows[j]["NiId"].ToString());
}
}
else
{
DataTable db = num.FatherGetChilDataTable(i);
for (int j = 0; j < db.Rows.Count; j++)
{
if (num.GetChildCount(j, t_sex) != 0)
{
Delete(Convert.ToInt32(db.Rows[j]["NiId"]));
}
num.CarryOutSqlSentence("delete from [Family].[dbo].[tblNumberInfo] where NiId=" + db.Rows[j]["NiId"].ToString());
num.CarryOutSqlSentence("delete from [Family].[dbo].[tblNumberInfo] where NiSpouseId = " + db.Rows[j]["NiId"].ToString());
}
}
}
public void ShowEditPeiOu()
{
int i = Convert.ToInt32(lblbianhao.Text);
FrmEdit frmcheck = new FrmEdit();
frmcheck.GetID = Convert.ToInt32(lblbianhao.Text);
dbtblNumberInfo num = new dbtblNumberInfo();
if (num.GetPersonSex(i) == 1)
{
frmcheck.PeiOuSex = 0;
}
else
{
frmcheck.PeiOuSex = 1;
}
frmcheck.ShowORAdd = 2;
frmcheck.Show();
}
public void ShowForm2_Add()
{
int i = Convert.ToInt32(lblbianhao.Text);
frmCheckSpuse frmcheck = new frmCheckSpuse();
frmcheck.GetID = Convert.ToInt32(lblbianhao.Text);
dbtblNumberInfo num = new dbtblNumberInfo();
if (num.GetPersonSex(i) == 1)
{
frmcheck.PeiOuSex = 0;
}
else
{
frmcheck.PeiOuSex = 1;
}
frmcheck.ShowORAdd = 1;
frmcheck.Show();
}
public void ShowForm2()
{
if (txtnumpeiou.Text == "未婚配" || txtnumpeiou.Text == "")
{
MessageBox.Show("此人未有婚配", "提示");
return;
}
int i = Convert.ToInt32(lblbianhao.Text);
frmCheckSpuse frmcheck = new frmCheckSpuse();
frmcheck.GetID = Convert.ToInt32(lblbianhao.Text);
dbtblNumberInfo num = new dbtblNumberInfo();
if (num.GetPersonSex(i) == 1)
{
frmcheck.PeiOuSex = 0;
}
else
{
frmcheck.PeiOuSex = 1;
}
frmcheck.ShowORAdd = 2;
frmcheck.Show();
}
