private void btnsave_Click(object sender, EventArgs e)
{
int bianhao = Convert.ToInt32(lblbianhao.Text);
if (txtNumNmae.Text == "")
{
MessageBox.Show("请输入名称", "提示");
return;
}
if (txtnumjob.Text == "")
{
MessageBox.Show("请输入职业", "提示");
return;
}
if (txtnumaddress.Text == "")
{
MessageBox.Show("请输入常住地址", "提示");
return;
}
if (txtnumlifestory.Text == "")
{
MessageBox.Show("请输入生平事迹", "提示");
return;
}
if (txttimeBirth.Text == "")
{
MessageBox.Show("请输入出生日期", "提示");
return;
}
if (!ValueJudge.IsDateTime(txttimeBirth.Text))
{
MessageBox.Show("请输入正确格式的出生日期", "提示");
return;
}
DateTime one = new DateTime();
if (txtdieDay.Text != "")
{
if (!ValueJudge.IsDateTime(txtdieDay.Text))
{
MessageBox.Show("请输入正确格式的死亡日期", "提示");
return;
}
one = Convert.ToDateTime(txttimeBirth.Text);
DateTime tcTwo = Convert.ToDateTime(txtdieDay.Text);
if (tcTwo <= one)
{
MessageBox.Show("日期错误！死亡日期与出生日期不符合常理", "警告");
return;
}
}
string sql =
String.Format("update Family.dbo.tblNumberInfo set [JobID]='{0}' ,NiName ='{1}' ,[NiBirthDay] ='{2}',NiDIeDay='{3}' ,NiAddress='{4}',[NiLifeStory]='{5}' where NiId ={6}",
txtnumjob.Text, txtNumNmae.Text, txttimeBirth.Text, txtdieDay.Text, txtnumaddress.Text, txtnumlifestory.Text, bianhao.ToString()
);
if (txtdieDay.Text != "")
{
sql =
String.Format("update Family.dbo.tblNumberInfo set [JobID]='{0}' ,NiName ='{1}' ,[NiBirthDay] ='{2}',NiDIeDay='{3}' ,NiAddress='{4}',[NiLifeStory]='{5}' , Nistate =40 where NiId ={6}",
txtnumjob.Text, txtNumNmae.Text, txttimeBirth.Text, txtdieDay.Text, txtnumaddress.Text, txtnumlifestory.Text, bianhao.ToString()
);
}
dbConnection db = new dbvwNumberInfo();
db.CarryOutSqlSentence(sql);
MessageBox.Show("修改成功", "成功");
EnableFalse();
btnsave.Visible = false;
button2.Visible = false;
lblDieDescription.Visible = false;
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtNumNmae.Text == "")
{
MessageBox.Show("请输入名称", "提示");
return;
}
if (txtnumjob.Text == "")
{
MessageBox.Show("请输入职业", "提示");
return;
}
if (dtpOne.IsNull())
{
MessageBox.Show("请输入出生日期", "提示");
return;
}
DateTime dtlast = new DateTime();
DateTime dt = Convert.ToDateTime(dtpOne.Text);
Rule Rle = new Rule();
bool iscan = Rle.CheckHavePeiOu(dt, GetID);
if (!iscan)
{
MessageBox.Show("配偶出生日期不符合配偶规则！（可查看具体规则）", "不符");
return;
}
string dieday = "NULL";
bool IsHaveDieDay = false;
if (txtDieDay.Text != "")
{
bool isdate = ValueJudge.IsDateTime(txtDieDay.Text);
if (!isdate)
{
MessageBox.Show("日期格式错诶!", "不符");
return;
}
dtlast = Convert.ToDateTime(txtDieDay.Text);
if (dtlast < dt)
{
MessageBox.Show("请输入正确时间", "提示");
return;
}
IsHaveDieDay = true;
dieday = dtlast.ToString();
}
else
{
}
if (txtnumaddress.Text == "")
{
MessageBox.Show("请输入地址", "提示");
return;
}
if (txtnumlifestory.Text == "")
{
MessageBox.Show("请输入生平事迹", "提示");
return;
}
string state = "";
if (cbxDieNow.SelectedIndex == 1)
{
state = "40";
}
else
{
state = "30";
}
if (IsHaveDieDay && cbxDieNow.SelectedIndex == 0)
{
MessageBox.Show("此人既有死亡日期！又被标定为健在！逻辑不符合", "错误");
return;
}
string sql = String.Format("insert into [Family].[dbo].[tblNumberInfo] " +
"( [JobID],[NiName],[NiSex],[NiSpouseId] ,[NiBirthDay],[NiDIeDay],[NiFatherId],[NiMotherId],[NiPicture],[NiAddress],[NiLifeStory],[Nistate]) " +
"values('{0}','{1}',{2},{3},cast('{4}' as datetime2),{5},{6},{7},NULL,'{8}','{9}',{10})", txtnumjob.Text, txtNumNmae.Text, PeiOuSex, GetID, dtpOne.Text, dieday, -1, -1, txtnumaddress.Text.Replace("\'", "\'\'"), txtnumlifestory.Text.Replace("\'", "\'\'"), state);
dbvwNumberInfo vw = new dbvwNumberInfo();
vw.CarryOutSqlSentence(sql);
dbConnection db = new dbConnection();
string ID = db.CarryOutSqlGetFirstColmun(String.Format(
"select NiId from [Family].[dbo].[tblNumberInfo] where JobID ='{0}' and NiName='{1}' and NiSpouseId={2} and NiFatherId =-1 and NiBirthDay ='{3}'",
txtnumjob.Text, txtNumNmae.Text, GetID, dtpOne.Text));
db.CarryOutSqlSentence("update [Family].[dbo].[tblNumberInfo] set NiSpouseId =" + ID + " where NiId= " + GetID);
MessageBox.Show("添加成功", "提示");
changeNull();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message + exception.StackTrace);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (txtNumNmae.Text == "")
{
MessageBox.Show("请输入名称", "提示");
return;
}
if (txtnumjob.Text == "")
{
MessageBox.Show("请输入职业", "提示");
return;
}
DateTime dt = Convert.ToDateTime(dtpOne.Text);
Rule esrRule = new Rule();
bool canhave = esrRule.CheckCanHaveSon(dt, id);
if (!canhave)
{
MessageBox.Show("孩子出生日期不符合孩子规则！（可查看具体规则）", "不符");
return;
}
DateTime dtlast;
if (txtDieDay.Text != "")
{
dtlast = Convert.ToDateTime(txtDieDay.Text);
if (dtlast < dt)
{
MessageBox.Show("请输入正确时间格式", "提示");
return;
}
}
else
{
txtDieDay.Text = "NULL";
}
if (cbxIsDie.SelectedIndex == 1 && txtDieDay.Text != "")
{
MessageBox.Show("此人健在无法添加死亡日期", "提示");
return;
}
if (txtnumaddress.Text == "")
{
MessageBox.Show("请输入地址", "提示");
return;
}
if (txtnumlifestory.Text == "")
{
MessageBox.Show("请输入生平事迹", "提示");
return;
}
string state = "";
if (cbxIsDie.SelectedIndex == 1)
{
state = "40";
}
else
{
state = "30";
}
string codesex = cbxSexName.SelectedIndex.ToString();
string strTime = dt.ToString();
string sql = "";
if (txtDieDay.Text != "")
{
sql = String.Format("insert into [Family].[dbo].[tblNumberInfo] " +
"( [JobID],[NiName],[NiSex],[NiSpouseId] ,[NiBirthDay],[NiDIeDay],[NiFatherId],[NiMotherId],[NiPicture],[NiAddress],[NiLifeStory],[Nistate]) " +
"values('{0}','{1}',{2},NULL,cast('{3}' as datetime2),{4},{5},{6},NULL,'{7}','{8}',{9})", txtnumjob.Text, txtNumNmae.Text, codesex, strTime, txtDieDay.Text, fatherId, motherId, txtnumaddress.Text, txtnumlifestory.Text, state);
}
else
{
sql = String.Format("insert into [Family].[dbo].[tblNumberInfo] " +
"( [JobID],[NiName],[NiSex],[NiSpouseId] ,[NiBirthDay],[NiDIeDay],[NiFatherId],[NiMotherId],[NiPicture],[NiAddress],[NiLifeStory],[Nistate]) " +
"values('{0}','{1}',{2},NULL,cast('{3}' as datetime2),cast('{4}' as datetime2),{5},{6},NULL,'{7}','{8}',{9})", txtnumjob.Text, txtNumNmae.Text, codesex, strTime, txtDieDay.Text, fatherId, motherId, txtnumaddress.Text, txtnumlifestory.Text, state);
}
dbvwNumberInfo vw = new dbvwNumberInfo();
vw.CarryOutSqlSentence(sql);
MessageBox.Show("添加成功", "提示");
ChengNull();
}
catch (Exception exception)
{
Console.WriteLine(exception);
throw;
}
}