Example #1
0
        public string makeEmpinsertQuery(DetailUnit _du)
        {
            string preString    = "insert into EMP  ";
            string whereString  = "";
            string valuesString = "values (  ";


            if (_du.getEmpID().Equals(""))
            {
                return(null);
            }

            whereString = "";


            valuesString = valuesString + "'" + _du.getName() + "'";
            valuesString = valuesString + ", '" + _du.getName() + "'";
            valuesString = valuesString + ", '" + _du.getName() + "'";

            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + "'" + _du.getSsno() + "'";


            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + "" + _du.getDepartment();


            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + " " + _du.getDivision();


            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + "" + _du.getTitle();


            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + " '" + _du.getTel() + "'";


            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + " '" + _du.getEmail() + "'";



            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + " '" + _du.getAddress() + "'";



            valuesString = valuesString + ", getdate()";


            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + " " + getCastString(getDate(_du.getBirth()));


            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + " " + _du.getGender();

            if (!valuesString.Equals(""))
            {
                valuesString = valuesString + ", ";
            }
            valuesString = valuesString + " " + _du.getFpNum();

            valuesString = valuesString + ",'','','','','','','')";



            if (valuesString.Equals(""))
            {
                return(null);
            }



            return(preString + valuesString + whereString);
        }
Example #2
0
        public string makeEmpUpdateQuery(DetailUnit _du)
        {
            string preString   = "update EMP set ";
            string whereString = "";
            string setString   = "";


            if (_du.getEmpID().Equals(""))
            {
                return(null);
            }

            whereString = " where ID = " + _du.getEmpID();

            if (!_du.getName().Equals(""))
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "NAME_1 = '" + _du.getName() + "'";
            }
            if (_du.getBirth() != new DateTime(1000, 1, 1))
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "BIRTH_DATE = " + getCastString(getDate(_du.getBirth()));
            }
            if (!_du.getGender().Equals(""))
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "GENDER = " + _du.getGender();
            }
            if (!_du.getSsno().Equals(""))
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "SSNO = '" + _du.getSsno() + "'";
            }
            if (_du.getDepartment() != -1)
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "DEPARTMENT = " + _du.getDepartment();
            }
            if (_du.getDivision() != -1)
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "DIVISION = " + _du.getDivision();
            }
            if (_du.getTitle() != -1)
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "TITLE = " + _du.getTitle();
            }
            if (!_du.getEmail().Equals(""))
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "EMAIL = '" + _du.getEmail() + "'";
            }
            if (!_du.getTel().Equals(""))
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "TEL = '" + _du.getTel() + "'";
            }
            if (!_du.getAddress().Equals(""))
            {
                if (!setString.Equals(""))
                {
                    setString = setString + ", ";
                }
                setString = setString + "ADDRESS = '" + _du.getAddress() + "'";
            }

            if (setString.Equals(""))
            {
                return(null);
            }

            setString = setString + ", MODIFY_DATE = GETDATE()";

            return(preString + setString + whereString);
        }