private void setParameter(iSqlParameter[] parms, CartitemInfo info) { try { int i = -1; parms[++i].Value = info.CartID; parms[++i].Value = info.ProductID; parms[++i].Value = info.Quantity; parms[++i].Value = info.Amount; parms[++i].Value = info.TemporaryID; parms[++i].Value = info.Id; return; } catch (Exception ex) { throw ex; } }
private CartitemInfo getDataReader(iSqlDataReader dar) { try { int i = -1; CartitemInfo info = new CartitemInfo(); info.CartID = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.ProductID = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Productname = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Quantity = dar.IsDBNull(++i) ? -1 : dar.GetInt32(i); info.Amount = dar.IsDBNull(++i) ? 0 : Math.Round(dar.GetFloat(i)); info.TemporaryID = dar.IsDBNull(++i) ? 0 : long.Parse(dar.GetValue(i).ToString()); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); return info; } catch (Exception ex) { throw ex; } }
private bool Saveitem(iSqlTransaction trans, CartitemInfo info) { try { if (trans == null || info == null) return false; string SQL = string.Empty; if (info.Id == 0) { SQL = SQL_INSERT; info.Id = (int)HELPER.getNewID(trans, TABLENAME); iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } else if (HELPER.isExist(trans, TABLENAME, info.Id)) { SQL = SQL_UPDATE; iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } else { SQL = SQL_INSERT; info.Id = (int)HELPER.getNewID(trans, TABLENAME); iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } return true; } catch (Exception ex) { throw ex; } }
private CartitemInfo AssigntoCartItem(int ProductID) { ProductInfo info = (new CProduct(LANG)).Getinfo(ProductID); CartitemInfo cartitem = new CartitemInfo(); cartitem.TemporaryID = DateTime.Now.Ticks; cartitem.Quantity = 1; cartitem.ProductID = ProductID; cartitem.Productname = info.Name; cartitem.Amount = info.Price; cartitem.iProduct = info; return cartitem; }