コード例 #1
0
        public String insert(XcustPorReqDistIntAll p)
        {
            String sql = "", chk = "";

            try
            {
                //if (p.OrpChtNum.Equals(""))
                //{
                //    return "";
                //}
                //p.RowNumber = selectMaxRowNumber(p.YearId);
                //p.Active = "1";
                sql = "Insert Into " + xCPRDIA.table + "(" + xCPRDIA.ATTRIBUTE1 + "," + xCPRDIA.ATTRIBUTE_DATE1 + "," + xCPRDIA.ATTRIBUTE_CATEGORY + "," +
                      xCPRDIA.ATTRIBUTE_NUMBER1 + "," + xCPRDIA.ATTRIBUTE_TIMESTAMP1 + "," + xCPRDIA.CHARGE_ACCOUNT_SEGMENT1 + "," +
                      xCPRDIA.CHARGE_ACCOUNT_SEGMENT2 + "," + xCPRDIA.CHARGE_ACCOUNT_SEGMENT3 + "," + xCPRDIA.CHARGE_ACCOUNT_SEGMENT4 + "," +
                      xCPRDIA.CHARGE_ACCOUNT_SEGMENT5 + "," + xCPRDIA.CHARGE_ACCOUNT_SEGMENT6 + "," + xCPRDIA.PO_LINE_NUMBER + "," +
                      xCPRDIA.PO_NUMBER + "," + xCPRDIA.PROCESS_FLAG + "," + xCPRDIA.Program_running + "," +
                      xCPRDIA.QTY + ") " +
                      "Values('" + p.ATTRIBUTE1 + "','" + p.ATTRIBUTE_DATE1 + "','" + p.ATTRIBUTE_CATEGORY + "','" +
                      p.ATTRIBUTE_NUMBER1 + "',now(),'" + p.CHARGE_ACCOUNT_SEGMENT1 + "','" +
                      p.CHARGE_ACCOUNT_SEGMENT2 + "','" + p.CHARGE_ACCOUNT_SEGMENT3 + "','" + p.CHARGE_ACCOUNT_SEGMENT4 + "','" +
                      p.CHARGE_ACCOUNT_SEGMENT5 + "','" + p.CHARGE_ACCOUNT_SEGMENT6 + "','" + p.PO_LINE_NUMBER + "','" +
                      p.PO_NUMBER + "','" + p.PROCESS_FLAG + "','" + p.Program_running + "','" +
                      p.QTY + "') ";
                chk = conn.ExecuteNonQueryAutoIncrement(sql, "kfc_po");
                //chk = p.RowNumber;
                //chk = p.Code;
            }
            catch (Exception ex)
            {
                //MessageBox.Show("Error " + ex.ToString(), "insert Doctor");
            }

            return(chk);
        }
コード例 #2
0
        private void insertXcustPorReqDistIntAll(DataRow row, String date, String time)
        {
            XcustPorReqDistIntAll xCPRDIA = new XcustPorReqDistIntAll();

            xCPRDIA.ATTRIBUTE1              = "";
            xCPRDIA.ATTRIBUTE_CATEGORY      = "";
            xCPRDIA.ATTRIBUTE_DATE1         = date;
            xCPRDIA.ATTRIBUTE_NUMBER1       = "";
            xCPRDIA.ATTRIBUTE_TIMESTAMP1    = date + " " + time;
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT1 = "";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT2 = "";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT3 = "";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT4 = "";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT5 = "";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT6 = "";
            xCPRDIA.PO_LINE_NUMBER          = row[xCLFPTDB.xCLFPT.LINE_NUMBER].ToString().Trim();
            xCPRDIA.PO_NUMBER       = row[xCLFPTDB.xCLFPT.PO_NUMBER].ToString().Trim();
            xCPRDIA.PROCESS_FLAG    = "N";
            xCPRDIA.Program_running = "";
            xCPRDIA.QTY             = row[xCLFPTDB.xCLFPT.QTY].ToString().Trim();
            xCPRDIADB.insert(xCPRDIA);
        }
コード例 #3
0
        private void initConfig()
        {
            xCPRDIA                         = new XcustPorReqDistIntAll();
            xCPRDIA.ATTRIBUTE1              = "ATTRIBUTE1";
            xCPRDIA.ATTRIBUTE_CATEGORY      = "ATTRIBUTE_CATEGORY";
            xCPRDIA.ATTRIBUTE_DATE1         = "ATTRIBUTE_DATE1";
            xCPRDIA.ATTRIBUTE_NUMBER1       = "ATTRIBUTE_NUMBER1";
            xCPRDIA.ATTRIBUTE_TIMESTAMP1    = "ATTRIBUTE_TIMESTAMP1";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT1 = "CHARGE_ACCOUNT_SEGMENT1";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT2 = "CHARGE_ACCOUNT_SEGMENT2";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT3 = "CHARGE_ACCOUNT_SEGMENT3";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT4 = "CHARGE_ACCOUNT_SEGMENT4";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT5 = "CHARGE_ACCOUNT_SEGMENT5";
            xCPRDIA.CHARGE_ACCOUNT_SEGMENT6 = "CHARGE_ACCOUNT_SEGMENT6";
            xCPRDIA.PO_LINE_NUMBER          = "PO_LINE_NUMBER";
            xCPRDIA.PO_NUMBER               = "PO_NUMBER";
            xCPRDIA.PROCESS_FLAG            = "PROCESS_FLAG";
            xCPRDIA.Program_running         = "Program_running";
            xCPRDIA.QTY                     = "QTY";

            xCPRDIA.pkField = "";
            xCPRDIA.table   = "xcust_por_req_dist_int_all";
        }