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