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