private double UpdateProductBarcode(string UserID, BasketData bkData ) { bool ret = true; ProductBarcodeDAL bDAL = new ProductBarcodeDAL(); bDAL.GetDataByLOID(bkData.LOID, null); bDAL.ABBNAME = bkData.ABBNAME; bDAL.BARCODE = bkData.BARCODE; bDAL.UNIT = bkData.UNITBASKET; bDAL.COST = bkData.COST; bDAL.PRICE = bkData.PRICE; bDAL.ISVAT = bkData.ISVAT; bDAL.ISDISCOUNT = bkData.ISDISCOUNT; bDAL.ISREFUND = bkData.ISREFUND; bDAL.ACTIVE = bkData.ACTIVE; bDAL.STDPRICE = bkData.PRICE; bDAL.MULTIPLY = 1; ret = bDAL.UpdateCurrentData(UserID, null); if (ret == false) { _error = bDAL.ErrorMessage; return 0; } else { return bDAL.LOID; } }
public static string GetLotNo(string userID, double productLOID, OracleTransaction zTrans) { bool LetClose = false; string code = ""; OracleConnection zConn = null; if (zTrans == null) { LetClose = true; zConn = OracleDB.GetConnection(); zTrans = zConn.BeginTransaction(IsolationLevel.ReadCommitted); } ProductBarcodeDAL _bDAL = new ProductBarcodeDAL(); if (_bDAL.GetDataByLOID(productLOID, zTrans)) { ProductMasterDAL _dal = new ProductMasterDAL(); if (_dal.GetDataByLOID(_bDAL.PRODUCTMASTER, zTrans)) { if (_dal.YEAR == (DateTime.Now.Year + 543).ToString().Substring(2)) { if (_dal.RUNNING == "9") { _dal.RUNNING = "1"; switch (_dal.LOTNO) { case "A": _dal.LOTNO = "B"; break; case "B": _dal.LOTNO = "C"; break; case "C": _dal.LOTNO = "D"; break; case "D": _dal.LOTNO = "E"; break; case "E": _dal.LOTNO = "F"; break; case "F": _dal.LOTNO = "G"; break; case "G": _dal.LOTNO = "H"; break; case "H": _dal.LOTNO = "I"; break; case "I": _dal.LOTNO = "J"; break; case "J": _dal.LOTNO = "K"; break; case "K": _dal.LOTNO = "L"; break; case "L": _dal.LOTNO = "M"; break; case "M": _dal.LOTNO = "N"; break; case "N": _dal.LOTNO = "O"; break; case "O": _dal.LOTNO = "P"; break; case "P": _dal.LOTNO = "Q"; break; case "Q": _dal.LOTNO = "R"; break; case "R": _dal.LOTNO = "S"; break; case "S": _dal.LOTNO = "T"; break; case "T": _dal.LOTNO = "U"; break; case "U": _dal.LOTNO = "V"; break; case "V": _dal.LOTNO = "W"; break; case "W": _dal.LOTNO = "X"; break; case "X": _dal.LOTNO = "Y"; break; case "Y": _dal.LOTNO = "Z"; break; case "Z": _dal.LOTNO = "A"; break; default: _dal.LOTNO = "A"; break; } } else { _dal.RUNNING = (Convert.ToInt32(_dal.RUNNING == "" ? "0" : _dal.RUNNING) + 1).ToString().Trim(); } } else { _dal.LOTNO = "A"; _dal.RUNNING = "1"; _dal.YEAR = (DateTime.Now.Year + 543).ToString().Substring(2); } if (!_dal.UpdateCurrentData(userID, zTrans)) { if (LetClose) { zTrans.Commit(); zConn.Close(); } throw new ApplicationException(_dal.ErrorMessage); } else { code = (_dal.CODE.Length > 3 ? _dal.CODE.Substring(0, 3) : _dal.CODE) + " " + _dal.LOTNO + _dal.RUNNING + _dal.YEAR; } } } if (LetClose) { zTrans.Commit(); zConn.Close(); } return code.ToUpper(); }