Exemplo n.º 1
0
        public bool SavePoMain(Po po)
        {
            string strSql = "insert into Po(soId,vendorName,contact,pa,paDate,vendorNumber,poDate,poNo,paymentTerms,shipMethod,freight,shipToLocation,billTo,shipTo,poStates) " +
                            string.Format(" values({0},'{1}','{2}',{3},'{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}',0)", po.soId, po.vendorName, po.contact, po.pa, po.paDate.ToShortDateString(), po.vendorNumber, po.poDate.ToShortDateString(), po.poNo, po.paymentTerms, po.shipMethod, po.freight, po.shipToLocation, po.billTo, po.shipTo, po.poStates);

            if (db.ExecDataBySql(strSql) == 1)
            {
                return(true);
            }

            return(false);
        }
Exemplo n.º 2
0
        public bool SavePoMain(Po po)
        {
            string strSql = "insert into Po(soId,vendorName,contact,pa,paDate,vendorNumber,poDate,poNo,paymentTerms,shipMethod,freight,shipToLocation,billTo,shipTo,poStates) "+
               string.Format(" values({0},'{1}','{2}',{3},'{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}',0)", po.soId, po.vendorName, po.contact, po.pa, po.paDate.ToShortDateString(), po.vendorNumber, po.poDate.ToShortDateString(), po.poNo, po.paymentTerms, po.shipMethod, po.freight, po.shipToLocation, po.billTo, po.shipTo, po.poStates);

               if (db.ExecDataBySql(strSql) == 1)
               return true;

               return false;
        }