Exemplo n.º 1
0
        private void btnSelectDepart_Click(object sender, EventArgs e)
        {
            frmPubSelectDepart frm = new frmPubSelectDepart(false);

            if (frm.ShowDialog() == DialogResult.OK)
            {
                txtDepart.Tag = frm.DepartSysID;
            }
        }
Exemplo n.º 2
0
        private void btnSelectDepart1_Click(object sender, EventArgs e)
        {
            frmPubSelectDepart frm = new frmPubSelectDepart();

            if (frm.ShowDialog() == DialogResult.OK)
            {
                txtDepart1.Text = frm.DepartName;
                txtDepart1.Tag  = frm.DepartID;
            }
        }
Exemplo n.º 3
0
        private void btnSelectDepart_Click(object sender, EventArgs e)
        {
            frmPubSelectDepart frm = new frmPubSelectDepart();

            if (frm.ShowDialog() == DialogResult.OK)
            {
                txtDepart.Text = frm.DepartName;
                if ((departFlag == 2) || (departFlag == 3))
                {
                    txtDepart.Tag = frm.DepartID;
                }
                else
                {
                    txtDepart.Tag = frm.DepartName;
                }
            }
        }
Exemplo n.º 4
0
        private void btnParentDepart_Click(object sender, EventArgs e)
        {
            frmPubSelectDepart frm = new frmPubSelectDepart(false);

            if (frm.ShowDialog() == DialogResult.OK)
            {
                string s  = frm.DepartSysID;
                string s1 = frm.DepartID;
                string s2 = frm.DepartName;
                if (s == SysID)
                {
                    Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", ""));
                    return;
                }
                string s3 = db.GetDepartChildSysIDBySysID(SysID);
                if (s3 != "")
                {
                    string[] tmp = s3.Split(',');
                    for (int i = 0; i < tmp.Length; i++)
                    {
                        if (tmp[i] == "")
                        {
                            continue;
                        }
                        s3 = tmp[i].Substring(1);
                        s3 = s3.Substring(0, s3.Length - 1);
                        if (s3 == s)
                        {
                            Pub.ShowErrorMsg(Pub.GetResText(formCode, "Error001", ""));
                            return;
                        }
                    }
                }
                ParentDepartGUID = s;
                ParentDepartInfo = "[" + s1 + "]" + s2;
                txtParent.Text   = ParentDepartInfo;
            }
        }
Exemplo n.º 5
0
        private void dataGrid_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            frmPubSelectDepart frmDepart;
            frmPubSelectEmp    frmEmp;
            frmPubSelectIDName frmID;

            if ((e.RowIndex < 0) || (e.ColumnIndex != 5))
            {
                return;
            }
            string title = dataGrid[2, e.RowIndex].Value.ToString();

            switch (dataGrid[7, e.RowIndex].Value.ToString().ToLower())
            {
            case "empno":
                frmEmp = new frmPubSelectEmp();
                if (frmEmp.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmEmp.EmpNo;
                    dataGrid[8, e.RowIndex].Value = frmEmp.EmpNo;
                }
                break;

            case "empname":
                frmEmp = new frmPubSelectEmp();
                if (frmEmp.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmEmp.EmpName;
                    dataGrid[8, e.RowIndex].Value = frmEmp.EmpNo;
                }
                break;

            case "departid":
                frmDepart = new frmPubSelectDepart();
                if (frmDepart.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmDepart.DepartID;
                    dataGrid[8, e.RowIndex].Value = frmDepart.DepartID;
                }
                break;

            case "departname":
                frmDepart = new frmPubSelectDepart();
                if (frmDepart.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmDepart.DepartName;
                    dataGrid[8, e.RowIndex].Value = frmDepart.DepartID;
                }
                break;

            case "cardsectorno":
            case "cardno":
                frmEmp = new frmPubSelectEmp();
                if (frmEmp.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmEmp.CardSectorNo;
                    dataGrid[8, e.RowIndex].Value = frmEmp.CardSectorNo;
                }
                break;

            case "cardphysicsno10":
                frmEmp = new frmPubSelectEmp();
                if (frmEmp.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmEmp.CardPhysicsNo10;
                    dataGrid[8, e.RowIndex].Value = frmEmp.CardPhysicsNo10;
                }
                break;

            case "cardphysicsno8":
                frmEmp = new frmPubSelectEmp();
                if (frmEmp.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmEmp.CardPhysicsNo8;
                    dataGrid[8, e.RowIndex].Value = frmEmp.CardPhysicsNo8;
                }
                break;

            case "sftypeid":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "501" }), "SFTypeID", "SFTypeName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectID;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectID;
                }
                break;

            case "sftypename":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "501" }), "SFTypeID", "SFTypeName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectName;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectName;
                }
                break;

            case "sfmealtypeid":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "502" }), "SFMealTypeID", "SFMealTypeName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectID;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectID;
                }
                break;

            case "sfmealtypename":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "502" }), "SFMealTypeID", "SFMealTypeName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectName;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectName;
                }
                break;

            case "cardstatusid":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "503" }), "CardStatusID", "CardStatusName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectID;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectID;
                }
                break;

            case "cardstatusname":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "503" }), "CardStatusID", "CardStatusName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectName;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectName;
                }
                break;

            case "syopterid":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "504" }), "SYOpterID", "SYOpterName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectID;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectID;
                }
                break;

            case "syoptername":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "504" }), "SYOpterID", "SYOpterName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectName;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectName;
                }
                break;

            case "cardtypeid":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "203" }), "CardTypeID", "CardTypeName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectID;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectID;
                }
                break;

            case "cardtypename":
                frmID = new frmPubSelectIDName(Column13.HeaderText + "[" + dataGrid[1, e.RowIndex].Value.ToString() + "]",
                                               Pub.GetSQL(DBCode.DB_000001, new string[] { "203" }), "CardTypeID", "CardTypeName");
                if (frmID.ShowDialog() == DialogResult.OK)
                {
                    dataGrid[4, e.RowIndex].Value = frmID.SelectName;
                    dataGrid[8, e.RowIndex].Value = frmID.SelectName;
                }
                break;
            }
            string v = "";

            v = dataGrid[2, e.RowIndex].Value.ToString();
            int index = _FieldText.IndexOf(v);

            if (index < 0)
            {
                return;
            }
            DateTime d = new DateTime();

            switch (_FieldType[index])
            {
            case GRFieldType.grftDateTime:
                DateTime.TryParse(dataGrid[3, e.RowIndex].Value.ToString(), out d);
                if (Pub.GetSelectDate(_ShowTime, ref d))
                {
                    if (_ShowTime)
                    {
                        dataGrid[4, e.RowIndex].Value = d.ToString(SystemInfo.SQLDateTimeFMT);
                    }
                    else
                    {
                        dataGrid[4, e.RowIndex].Value = d.ToString(SystemInfo.SQLDateFMT);
                    }
                    dataGrid[8, e.RowIndex].Value = dataGrid[4, e.RowIndex].Value;
                }
                break;
            }
        }