Exemple #1
0
        private void simpleButtonOK_Click(object sender, EventArgs e)
        {
            ConnDB conn = new ConnDB();
            string strsql, strsql2;
            int    rows;

            strsql  = "insert into cost_ems_hh_hours(cdate,hours) values('" + dateEditDate.Text.ToString() + "',ltrim(rtrim(" + textEditHours.Text.ToString() + ")))";
            strsql2 = "select cdate from cost_ems_hh_hours where cdate ='" + dateEditDate.Text.ToString() + "'";
            if (textEditHours.Text.ToString() != "")
            {
                rows = conn.ReturnRecordCount(strsql2);
                if (rows > 0)
                {
                    MessageBox.Show("此日期产出工时已经存在!");
                }
                else
                {
                    bool isok = conn.EditDatabase(strsql);
                    if (isok)
                    {
                        MessageBox.Show("添加成功!");
                        EmsHhHoursQuery.RefreshEX();
                    }
                }
            }
            else
            {
                MessageBox.Show("产出工时不能为空!");
            }
            conn.Close();
        }
Exemple #2
0
 public static EmsHhHoursQuery GetInstance()
 {
     if (ehqform == null || ehqform.IsDisposed)
     {
         ehqform = new EmsHhHoursQuery();
     }
     return(ehqform);
 }
Exemple #3
0
        private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e)
        {
            EmsHhHoursQuery Frm = EmsHhHoursQuery.GetInstance();

            Frm.TopLevel = false;
            Frm.Parent   = this;
            Frm.Show();
            Frm.BringToFront();
        }
Exemple #4
0
        private void SteelNetRate_Load(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Maximized;
            EmsHhHoursQuery Frm = EmsHhHoursQuery.GetInstance();

            Frm.TopLevel = false;
            Frm.Parent   = this;
            Frm.Show();
            Frm.BringToFront();
        }
Exemple #5
0
 private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e)
 {
     EmsHhHoursQuery.RefreshEX();
 }