/// <summary>
/// 该商品是否还能进行申诉
/// </summary>
/// <param name="orderCode"></param>
/// <param name="sku"></param>
/// <returns></returns>
public bool IsCanRefund(string orderCode, string sku)
{
bool isCan = false;
string sql = @"select Quantity,RefundQuantity from OrderProducts where OrderCode=@OrderCode and sku=@sku";
var parameters = DbSFO2OMain.CreateParameterCollection();
parameters.Append("@OrderCode", orderCode);
parameters.Append("@sku", sku);
DataTable dt = DbSFO2ORead.ExecuteDataSet(CommandType.Text, sql, parameters).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
isCan = Convert.ToInt32(dt.Rows[0][0]) > Convert.ToInt32(dt.Rows[0][1]) ? true : false;
}
return(isCan);
}