/// <summary>
/// 获取一条记录
/// </summary>
/// <param name="infoId">记录编号</param>
/// <returns>数据对象</returns>
public XYECOM.Model.DissentInfo GetItem(int infoId)
{
XYECOM.Model.DissentInfo model = null;
SqlParameter[] Parame = new SqlParameter[]
{
new SqlParameter("@Top","0"),
new SqlParameter("@Columns",""),
new SqlParameter("@Table","XY_Dissent"),
new SqlParameter("@Where","Id = " + infoId.ToString()),
new SqlParameter("@Order","")
};
using (SqlDataReader rdr = XYECOM.Core.Data.SqlHelper.ExecuteReader(CommandType.StoredProcedure, "XYP_CommonSelect", Parame))
{
if (rdr.Read())
{
model = new XYECOM.Model.DissentInfo();
model.Id = Convert.ToInt32(rdr["Id"].ToString());
model.OrderId = Convert.ToInt32(rdr["OrderId"].ToString());
model.DissentType = rdr["DissentType"].ToString();
model.Description = rdr["Description"].ToString();
model.RefundMoney = Convert.ToDecimal(rdr["RefundMoney"].ToString());
model.GoodsOrInvoice = rdr["GoodsOrInvoice"].ToString();
model.InsertTime = Convert.ToDateTime(rdr["InsertTime"].ToString());
}
}
return model;
}
/// <summary>
///
/// </summary>
/// <param name="orderid"></param>
/// <param name="goodsorinvoice"></param>
/// <returns></returns>
public XYECOM.Model.DissentInfo GetItem(string orderid, string goodsorinvoice)
{
XYECOM.Model.DissentInfo model = null;
//SqlParameter[] Parame = new SqlParameter[]
//{
// new SqlParameter("@Top","1"),
// new SqlParameter("@Columns","*"),
// new SqlParameter("@Table","XY_Dissent"),
// new SqlParameter("@Where","((OrderId=" + orderid + ") and (GoodsOrInvoice='" + goodsorinvoice + "'))"),
// new SqlParameter("@Order","")
//};
string sql = string.Format( "select * from XY_Dissent where OrderId={0} and GoodsOrInvoice='{1}'",orderid,goodsorinvoice);
using (SqlDataReader rdr = XYECOM.Core.Data.SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
model = new XYECOM.Model.DissentInfo();
model.Id = Convert.ToInt32(rdr["Id"].ToString());
model.OrderId = Convert.ToInt32(rdr["OrderId"].ToString());
model.DissentType = rdr["DissentType"].ToString();
model.Description = rdr["Description"].ToString();
model.RefundMoney = Convert.ToDecimal(rdr["RefundMoney"].ToString());
model.GoodsOrInvoice = rdr["GoodsOrInvoice"].ToString();
model.InsertTime = Convert.ToDateTime(rdr["InsertTime"].ToString());
}
}
return model;
}
/// <summary>
/// 根据订单编号，订单类型，异议类型获取异议信息
/// </summary>
/// <param name="orderid">订单编号</param>
/// <param name="goodsorinvoice">异议类型</param>
/// <param name="orderType">订单类型</param>
/// <returns>异议信息</returns>
public XYECOM.Model.DissentInfo GetItem(string orderid, string goodsorinvoice,int orderType)
{
XYECOM.Model.DissentInfo model = null;
string sql = string.Format("select * from XY_Dissent where OrderId={0} and GoodsOrInvoice='{1}' and ordertype = {2}", orderid, goodsorinvoice,orderType);
using (SqlDataReader rdr = XYECOM.Core.Data.SqlHelper.ExecuteReader(sql))
{
if (rdr.Read())
{
model = new XYECOM.Model.DissentInfo();
model.Id = Convert.ToInt32(rdr["Id"].ToString());
model.OrderId = Convert.ToInt32(rdr["OrderId"].ToString());
model.DissentType = rdr["DissentType"].ToString();
model.Description = rdr["Description"].ToString();
model.RefundMoney = Convert.ToDecimal(rdr["RefundMoney"].ToString());
model.GoodsOrInvoice = rdr["GoodsOrInvoice"].ToString();
model.InsertTime = Convert.ToDateTime(rdr["InsertTime"].ToString());
}
}
return model;
}