/// <summary>
///[To_OrderRefunDetial]表查询实体的方法
/// </summary>
public static To_OrderRefunDetial getTo_OrderRefunDetialById(int id)
{
To_OrderRefunDetial to_orderrefundetial = null;
string sql = "select * from To_OrderRefunDetial where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
to_orderrefundetial = new To_OrderRefunDetial();
foreach (DataRow dr in dt.Rows)
{
to_orderrefundetial.Id = Convert.ToInt32(dr["id"]);
to_orderrefundetial.Orderid = Convert.ToInt32(dr["orderid"]);
to_orderrefundetial.Cusid = Convert.ToInt32(dr["cusid"]);
to_orderrefundetial.CusName = Convert.ToString(dr["cusName"]);
to_orderrefundetial.Money = Convert.ToDouble(dr["money"]);
to_orderrefundetial.RefundAmount = Convert.ToDouble(dr["refundAmount"]);
to_orderrefundetial.RefundStatus = Convert.ToString(dr["refundStatus"]);
to_orderrefundetial.Remark = Convert.ToString(dr["remark"]);
}
}
return(to_orderrefundetial);
}
/// <summary>
/// 得到订单id
/// </summary>
/// <param name="orderRetid">退款信息明细表id</param>
/// <returns></returns>
public string getOrderidRet(string orderRetid)
{
int id = 0;
int.TryParse(orderRetid, out id);
To_OrderRefunDetial model = To_OrderRefunDetialManager.getTo_OrderRefunDetialById(id);
if (model != null)
{
return(model.Orderid.ToString());
}
else
{
return("");
}
}
/// <summary>
///[To_OrderRefunDetial]表添加的方法
/// </summary>
public static int addTo_OrderRefunDetial(To_OrderRefunDetial to_orderrefundetial)
{
string sql = "insert into To_OrderRefunDetial([orderid],[cusid],[cusName],[money],[refundAmount],[refundStatus],[remark]) values (@orderid,@cusid,@cusName,@money,@refundAmount,@refundStatus,@remark)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@orderid", to_orderrefundetial.Orderid),
new SqlParameter("@cusid", to_orderrefundetial.Cusid),
new SqlParameter("@cusName", to_orderrefundetial.CusName),
new SqlParameter("@money", to_orderrefundetial.Money),
new SqlParameter("@refundAmount", to_orderrefundetial.RefundAmount),
new SqlParameter("@refundStatus", to_orderrefundetial.RefundStatus),
new SqlParameter("@remark", to_orderrefundetial.Remark)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[To_OrderRefunDetial]表修改的方法
/// </summary>
public static int updateTo_OrderRefunDetialById(To_OrderRefunDetial to_orderrefundetial)
{
string sql = "update To_OrderRefunDetial set orderid=@orderid,cusid=@cusid,cusName=@cusName,money=@money,refundAmount=@refundAmount,refundStatus=@refundStatus,remark=@remark where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", to_orderrefundetial.Id),
new SqlParameter("@orderid", to_orderrefundetial.Orderid),
new SqlParameter("@cusid", to_orderrefundetial.Cusid),
new SqlParameter("@cusName", to_orderrefundetial.CusName),
new SqlParameter("@money", to_orderrefundetial.Money),
new SqlParameter("@refundAmount", to_orderrefundetial.RefundAmount),
new SqlParameter("@refundStatus", to_orderrefundetial.RefundStatus),
new SqlParameter("@remark", to_orderrefundetial.Remark)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///根据SQL语句获取实体
/// </summary>
public static To_OrderRefunDetial getTo_OrderRefunDetialBySql(string sql)
{
To_OrderRefunDetial to_orderrefundetial = null;
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
to_orderrefundetial = new To_OrderRefunDetial();
foreach (DataRow dr in dt.Rows)
{
to_orderrefundetial.Id = Convert.ToInt32(dr["id"]);
to_orderrefundetial.Orderid = Convert.ToInt32(dr["orderid"]);
to_orderrefundetial.Cusid = Convert.ToInt32(dr["cusid"]);
to_orderrefundetial.CusName = Convert.ToString(dr["cusName"]);
to_orderrefundetial.Money = Convert.ToDouble(dr["money"]);
to_orderrefundetial.RefundAmount = Convert.ToDouble(dr["refundAmount"]);
to_orderrefundetial.RefundStatus = Convert.ToString(dr["refundStatus"]);
to_orderrefundetial.Remark = Convert.ToString(dr["remark"]);
}
}
return(to_orderrefundetial);
}
public static int addTo_OrderRefunDetial(To_OrderRefunDetial to_orderrefundetial)
{
return(To_OrderRefunDetialService.addTo_OrderRefunDetial(to_orderrefundetial));
}
public static int updateTo_OrderRefunDetial(To_OrderRefunDetial to_orderrefundetial)
{
return(To_OrderRefunDetialService.updateTo_OrderRefunDetialById(to_orderrefundetial));
}
