Пример #1
0
        private void GetStory()
        {
            dbConnection db = new dbConnection();
            DataTable    Tt = db.CarryOutSqlGeDataTable(
                "select top 1 NiLifeStory ,NiName from  [Family].[dbo].[tblNumberInfo] where LEN(NiLifeStory)>30 order by newid()");

            txtStroyFamily.Text = "    " + Tt.Rows[0]["NiName"].ToString() + ":" + Tt.Rows[0]["NiLifeStory"].ToString();
        }
Пример #2
0
        /// <summary>
        /// 配偶的出生日期必须在本人的健在时间段内
        /// </summary>
        /// <param name="dtPeiOuBirth"></param>
        /// <param name="FatherId"></param>
        /// <returns></returns>
        public bool CheckHavePeiOu(DateTime dtPeiOuBirth, int FatherId)
        {
            dbConnection Get = new dbConnection();
            //父亲出生日期
            DateTime dt             = Convert.ToDateTime(Get.CarryOutSqlGetFirstColmun(String.Format("  select NiBirthDay from [Family].[dbo].[tblNumberInfo] where NiId ={0}", FatherId)));
            int      NianLingFather = Convert.ToInt32(Get.CarryOutSqlGetFirstColmun(String.Format("select 年龄 from [Family].[dbo].[vwNumberInfo] where NiId ={0}", FatherId)));
            //年龄
            DateTime dtmin = dt.AddYears(0);
            DateTime max   = dt.AddYears(NianLingFather);

            if (dtPeiOuBirth > max || dtPeiOuBirth < dtmin)
            {
                return(false);
            }
            return(true);
        }
Пример #3
0
 private void DeleteAllDateTSM_Click(object sender, EventArgs e)
 {
     if (IsCan == 20)
     {
         MessageBox.Show("你暂时未有此项权限", "提示");
         return;
     }
     if (System.Windows.Forms.MessageBox.Show("你确定要删除所有数据吗?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
     {
         if (System.Windows.Forms.MessageBox.Show("请你再次慎重考虑是否重建家谱!", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK)
         {
             dbConnection db = new dbConnection();
             db.CarryOutSqlSentence("  truncate table [Family].[dbo].[tblNumberInfo]");
             MessageBox.Show("已经清空!", "提示");
         }
     }
 }
Пример #4
0
 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);
     }
 }
Пример #5
0
        private void getListData(string sql)
        {
            dbConnection db = new dbConnection();

            dgvList.DataSource = db.CarryOutSqlGeDataTable(sql);
        }
Пример #6
0
        private void ShowData()
        {
            dbConnection con            = new dbConnection();
            string       AllPeople      = con.CarryOutSqlGetFirstColmun("select count(*) from  [Family].[dbo].[tblNumberInfo]");
            double       countAllPeople = Convert.ToDouble(AllPeople);

            RsAllPeopleCount.Height = 200;
            RsAllPeopleCount.Width  = 25;
            lblAll.Text             = "总人数:" + countAllPeople;
            dbvwNumberInfo num                = new dbvwNumberInfo();
            DataTable      td                 = num.GetAllDataFrom_vwNumberInfo();
            int            sexCountGirl       = 0;
            int            sexCountBoy        = 0;
            int            weichengnian       = 0;
            int            lblLifeCount       = 0; //当前健在人口
            int            lblTillNowDieCount = 0; /*目前为止先祖人口*/
            int            lblNowDanCount     = 0; /*当前单身人数*/
            int            lblJiaZuJiCount    = 0; /*未记载*/
            int            BoyNowStillLfe     = 0;
            int            GirlNowLifeStill   = 0;
            int            JianZiaWeicheng    = 0;

            for (int i = 0; i < td.Rows.Count; i++)
            {
                if (td.Rows[i]["NiSex"].ToString() == "True")
                {
                    sexCountGirl++;
                }
                else
                {
                    sexCountBoy++;
                }
                if (Convert.ToInt32(td.Rows[i]["年龄"]) < 18)
                {
                    weichengnian++;
                }

                /*统计健在人口*/
                if (td.Rows[i]["Nistate"].ToString() == "30")
                {
                    lblLifeCount++;
                }
                /*统计死亡人口*/
                if (td.Rows[i]["Nistate"].ToString() == "40")
                {
                    lblTillNowDieCount++;
                }
                if (td.Rows[i]["配偶"].ToString() == "未记载" && td.Rows[i]["Nistate"].ToString() == "30")
                {
                    lblNowDanCount++;
                }
                if (td.Rows[i]["NiLifeStory"].ToString() == "" || td.Rows[i]["NiLifeStory"].ToString().Length < 50)
                {
                    lblJiaZuJiCount++;
                }
                if (td.Rows[i]["Nistate"].ToString() == "30" && td.Rows[i]["性别"].ToString() == "男")
                {
                    BoyNowStillLfe++;
                }
                if (td.Rows[i]["Nistate"].ToString() == "30" && td.Rows[i]["性别"].ToString() == "女")
                {
                    GirlNowLifeStill++;
                }
                if (Convert.ToInt32(td.Rows[i]["年龄"]) < 18 && td.Rows[i]["Nistate"].ToString() == "30")
                {
                    JianZiaWeicheng++;
                }
            }
            lblLifeCountNow.Text       = lblLifeCount.ToString();       /*显示健在总人口*/
            lblTillNowDieCountNow.Text = lblTillNowDieCount.ToString(); //显示死亡人口
            lblNowDanCountNow.Text     = lblNowDanCount.ToString();     /*单身人数*/
            lblJiZaiWithOut.Text       = lblJiaZuJiCount.ToString();    /*记载*/
            lblLifeGrilNow.Text        = GirlNowLifeStill.ToString();
            lblLifeBoyNow.Text         = BoyNowStillLfe.ToString();
            lblWhouChengNian.Text      = JianZiaWeicheng.ToString();
            lblWEichengnian.Text       = "未成年:" + weichengnian;
            lblGirl.Text          = "女生:" + sexCountGirl;
            lblBoy.Text           = "男生:" + sexCountBoy;
            RSGrilCount.Height    = Convert.ToInt32((sexCountGirl / countAllPeople) * 200);
            RSBoyCount.Height     = Convert.ToInt32((sexCountBoy / countAllPeople) * 200);
            CRWeichengNain.Height = Convert.ToInt32((weichengnian / countAllPeople) * 200);
            GetDate();
        }