/// <summary>
///根据SQL语句获取实体
/// </summary>
public static To_OrderPayDetial getTo_OrderPayDetialBySql(string sql)
{
To_OrderPayDetial to_orderpaydetial = null;
DataTable dt = DBHelper.GetDataSet(sql);
if (dt.Rows.Count > 0)
{
to_orderpaydetial = new To_OrderPayDetial();
foreach (DataRow dr in dt.Rows)
{
to_orderpaydetial.Id = Convert.ToInt32(dr["id"]);
to_orderpaydetial.Orderid = Convert.ToInt32(dr["orderid"]);
to_orderpaydetial.Factid = Convert.ToInt32(dr["factid"]);
to_orderpaydetial.SupName = Convert.ToString(dr["supName"]);
to_orderpaydetial.Money = Convert.ToDouble(dr["money"]);
to_orderpaydetial.PayConfirm = Convert.ToString(dr["payConfirm"]);
to_orderpaydetial.PayStatus = Convert.ToString(dr["payStatus"]);
to_orderpaydetial.PayAmount = Convert.ToDouble(dr["payAmount"]);
to_orderpaydetial.PayType = Convert.ToString(dr["payType"]);
to_orderpaydetial.LinkID = Convert.ToInt32(dr["linkID"] == DBNull.Value ? 0 : dr["linkID"]);
to_orderpaydetial.LinkName = Convert.ToString(dr["linkName"]);
to_orderpaydetial.Remark = Convert.ToString(dr["remark"]);
to_orderpaydetial.PayNum = Convert.ToInt32(dr["payNum"]);
to_orderpaydetial.PayChildNum = Convert.ToInt32(dr["payChildNum"]);
}
}
return(to_orderpaydetial);
}
/// <summary>
/// 得到订单id
/// </summary>
/// <param name="orderPayid">付款信息明细表id</param>
/// <returns></returns>
public string getOrderidpay(string orderPayid)
{
int id = 0;
int.TryParse(orderPayid, out id);
To_OrderPayDetial model = To_OrderPayDetialManager.getTo_OrderPayDetialById(id);
if (model != null)
{
return(model.Orderid.ToString());
}
else
{
return("");
}
}
/// <summary>
///[To_OrderPayDetial]表添加的方法
/// </summary>
public static int addTo_OrderPayDetial(To_OrderPayDetial to_orderpaydetial)
{
string sql = "insert into To_OrderPayDetial([orderid],[factid],[supName],[money],[payConfirm],[payStatus],[payType],[linkID],[linkName],[remark],[payNum],[payChildNum]) values (@orderid,@factid,@supName,@money,@payConfirm,@payStatus,@payType,@linkID,@linkName,@remark,@payNum,@payChildNum)";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@orderid", to_orderpaydetial.Orderid),
new SqlParameter("@factid", to_orderpaydetial.Factid),
new SqlParameter("@supName", to_orderpaydetial.SupName),
new SqlParameter("@money", to_orderpaydetial.Money),
new SqlParameter("@payConfirm", to_orderpaydetial.PayConfirm),
new SqlParameter("@payStatus", to_orderpaydetial.PayStatus),
new SqlParameter("@payType", to_orderpaydetial.PayType),
new SqlParameter("@linkID", to_orderpaydetial.LinkID),
new SqlParameter("@linkName", to_orderpaydetial.LinkName),
new SqlParameter("@remark", to_orderpaydetial.Remark),
new SqlParameter("@payNum", to_orderpaydetial.PayNum),
new SqlParameter("@payChildNum", to_orderpaydetial.PayChildNum)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[To_OrderPayDetial]表修改的方法
/// </summary>
public static int updateTo_OrderPayDetialById(To_OrderPayDetial to_orderpaydetial)
{
string sql = "update To_OrderPayDetial set orderid=@orderid,factid=@factid,supName=@supName,money=@money,payConfirm=@payConfirm,payStatus=@payStatus,payAmount=@payAmount,payType=@payType,linkID=@linkID,linkName=@linkName,remark=@remark,payNum=@payNum,payChildNum=@payChildNum where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", to_orderpaydetial.Id),
new SqlParameter("@orderid", to_orderpaydetial.Orderid),
new SqlParameter("@factid", to_orderpaydetial.Factid),
new SqlParameter("@supName", to_orderpaydetial.SupName),
new SqlParameter("@money", to_orderpaydetial.Money),
new SqlParameter("@payConfirm", to_orderpaydetial.PayConfirm),
new SqlParameter("@payStatus", to_orderpaydetial.PayStatus),
new SqlParameter("@payAmount", to_orderpaydetial.PayAmount),
new SqlParameter("@payType", to_orderpaydetial.PayType),
new SqlParameter("@linkID", to_orderpaydetial.LinkID),
new SqlParameter("@linkName", to_orderpaydetial.LinkName),
new SqlParameter("@remark", to_orderpaydetial.Remark),
new SqlParameter("@payNum", to_orderpaydetial.PayNum),
new SqlParameter("@payChildNum", to_orderpaydetial.PayChildNum)
};
return(DBHelper.ExecuteCommand(sql, sp));
}
/// <summary>
///[To_OrderPayDetial]表查询实体的方法
/// </summary>
public static To_OrderPayDetial getTo_OrderPayDetialById(int id)
{
To_OrderPayDetial to_orderpaydetial = null;
string sql = "select * from To_OrderPayDetial where id=@id";
SqlParameter[] sp = new SqlParameter[]
{
new SqlParameter("@id", id)
};
DataTable dt = DBHelper.GetDataSet(sql, sp);
if (dt.Rows.Count > 0)
{
to_orderpaydetial = new To_OrderPayDetial();
foreach (DataRow dr in dt.Rows)
{
to_orderpaydetial.Id = Convert.ToInt32(dr["id"]);
to_orderpaydetial.Orderid = Convert.ToInt32(dr["orderid"]);
to_orderpaydetial.Factid = Convert.ToInt32(dr["factid"]);
to_orderpaydetial.SupName = Convert.ToString(dr["supName"]);
to_orderpaydetial.Money = Convert.ToDouble(dr["money"]);
to_orderpaydetial.PayConfirm = Convert.ToString(dr["payConfirm"]);
to_orderpaydetial.PayStatus = Convert.ToString(dr["payStatus"]);
to_orderpaydetial.PayAmount = Convert.ToDouble(dr["payAmount"] == DBNull.Value ? 0.00 : dr["payAmount"]);
to_orderpaydetial.PayType = Convert.ToString(dr["payType"]);
to_orderpaydetial.LinkID = Convert.ToInt32(dr["linkID"] == DBNull.Value ? 0 : dr["linkID"]);
to_orderpaydetial.LinkName = Convert.ToString(dr["linkName"]);
to_orderpaydetial.Remark = Convert.ToString(dr["remark"]);
to_orderpaydetial.PayNum = Convert.ToInt32(dr["payNum"]);
to_orderpaydetial.PayChildNum = Convert.ToInt32(dr["payChildNum"]);
}
}
return(to_orderpaydetial);
}
public static int addTo_OrderPayDetial(To_OrderPayDetial to_orderpaydetial)
{
return(To_OrderPayDetialService.addTo_OrderPayDetial(to_orderpaydetial));
}
public static int updateTo_OrderPayDetial(To_OrderPayDetial to_orderpaydetial)
{
return(To_OrderPayDetialService.updateTo_OrderPayDetialById(to_orderpaydetial));
}
