public override bool AddOrderLookupItem(OrderLookupItemInfo orderLookupItem) { DbCommand sqlStringCommand = database.GetSqlStringCommand("INSERT INTO Hishop_OrderLookupItems(LookupListId,[Name],IsUserInputRequired,UserInputTitle,AppendMoney,CalculateMode,Remark) VALUES(@LookupListId,@Name,@IsUserInputRequired,@UserInputTitle,@AppendMoney,@CalculateMode,@Remark)"); database.AddInParameter(sqlStringCommand, "LookupListId", DbType.Int32, orderLookupItem.LookupListId); database.AddInParameter(sqlStringCommand, "Name", DbType.String, orderLookupItem.Name); database.AddInParameter(sqlStringCommand, "IsUserInputRequired", DbType.Boolean, orderLookupItem.IsUserInputRequired); database.AddInParameter(sqlStringCommand, "UserInputTitle", DbType.String, orderLookupItem.UserInputTitle); database.AddInParameter(sqlStringCommand, "AppendMoney", DbType.Currency, orderLookupItem.AppendMoney); database.AddInParameter(sqlStringCommand, "CalculateMode", DbType.Int32, orderLookupItem.CalculateMode); database.AddInParameter(sqlStringCommand, "Remark", DbType.String, orderLookupItem.Remark); return (database.ExecuteNonQuery(sqlStringCommand) > 0); }
public static OrderLookupItemInfo PopulateOrderLookupItem(IDataRecord reader) { if (null == reader) { return null; } OrderLookupItemInfo info = new OrderLookupItemInfo(); info.LookupListId = (int) reader["LookupListId"]; info.LookupItemId = (int) reader["LookupItemId"]; info.Name = (string) reader["Name"]; info.IsUserInputRequired = (bool) reader["IsUserInputRequired"]; if (DBNull.Value != reader["UserInputTitle"]) { info.UserInputTitle = (string) reader["UserInputTitle"]; } if (DBNull.Value != reader["AppendMoney"]) { info.AppendMoney = new decimal?((decimal) reader["AppendMoney"]); } if (DBNull.Value != reader["CalculateMode"]) { info.CalculateMode = new int?((int) reader["CalculateMode"]); } if (DBNull.Value != reader["Remark"]) { info.Remark = (string) reader["Remark"]; } return info; }
public static bool UpdateOrderLookupItem(OrderLookupItemInfo orderLookupItem) { Globals.EntityCoding(orderLookupItem, true); return SalesProvider.Instance().UpdateOrderLookupItem(orderLookupItem); }
public override bool UpdateOrderLookupItem(OrderLookupItemInfo orderLookupItem) { DbCommand sqlStringCommand = database.GetSqlStringCommand("UPDATE Hishop_OrderLookupItems SET LookupListId = @LookupListId,[Name] = @Name, IsUserInputRequired = @IsUserInputRequired,UserInputTitle = @UserInputTitle, AppendMoney = @AppendMoney,CalculateMode = @CalculateMode,Remark=@Remark WHERE LookupItemId =@LookupItemId"); database.AddInParameter(sqlStringCommand, "LookupListId", DbType.Int32, orderLookupItem.LookupListId); database.AddInParameter(sqlStringCommand, "Name", DbType.String, orderLookupItem.Name); database.AddInParameter(sqlStringCommand, "IsUserInputRequired", DbType.Boolean, orderLookupItem.IsUserInputRequired); database.AddInParameter(sqlStringCommand, "UserInputTitle", DbType.String, orderLookupItem.UserInputTitle); database.AddInParameter(sqlStringCommand, "AppendMoney", DbType.Currency, orderLookupItem.AppendMoney); database.AddInParameter(sqlStringCommand, "CalculateMode", DbType.Int32, orderLookupItem.CalculateMode); database.AddInParameter(sqlStringCommand, "Remark", DbType.String, orderLookupItem.Remark); database.AddInParameter(sqlStringCommand, "LookupItemId", DbType.Int32, orderLookupItem.LookupItemId); return (database.ExecuteNonQuery(sqlStringCommand) > 0); }
decimal CalculateOrderOptionPrice(OrderLookupItemInfo item) { if (item.CalculateMode.Value == 2) { return ((this.GetCartTotalPrice() * decimal.Parse(item.AppendMoney.ToString())) / 100M); } return decimal.Parse(item.AppendMoney.ToString()); }
public abstract bool AddOrderLookupItem(OrderLookupItemInfo orderLookupItem);
public abstract bool UpdateOrderLookupItem(OrderLookupItemInfo orderLookupItem);
private OrderLookupItemInfo GetLookupItem() { OrderLookupItemInfo info = new OrderLookupItemInfo(); info.Name = txtName.Text.Trim(); info.CalculateMode = new int?(radlCalculateMode.SelectedValue); info.UserInputTitle = txtUserInputTitle.Text.Trim(); if (!((radlCalculateMode.SelectedValue != 1) || string.IsNullOrEmpty(txtAppendMoney.Text.Trim()))) { info.AppendMoney = new decimal?(decimal.Parse(txtAppendMoney.Text.Trim())); } if (!((radlCalculateMode.SelectedValue != 2) || string.IsNullOrEmpty(txtPercentage.Text.Trim()))) { info.AppendMoney = new decimal?(decimal.Parse(txtPercentage.Text.Trim())); } info.Remark = txtRemark.Text.Trim(); info.IsUserInputRequired = radlUserInput.SelectedValue; info.LookupListId = lookupListId; return info; }