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);
}
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;
}