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