public int EditServer_Refundlog(B2b_Rentserver_RefundLog server_refundlog) { using (var helper = new SqlHelper()) { int r = new InternalB2b_Rentserver_RefundLog(helper).EditServer_Refundlog(server_refundlog); return(r); } }
internal B2b_Rentserver_RefundLog GetServerRefundlog(int orderid, int rentserverid, int b2b_eticket_Depositid, int refundstate) { string sql = "select * from b2b_Rentserver_RefundLog where orderid=" + orderid + " and rentserverid=" + rentserverid + " and b2b_eticket_Depositid=" + b2b_eticket_Depositid + " and refundstate=" + refundstate; if (refundstate == -1) { sql = "select * from b2b_Rentserver_RefundLog where orderid=" + orderid + " and rentserverid=" + rentserverid + " and b2b_eticket_Depositid=" + b2b_eticket_Depositid; } var cmd = sqlHelper.PrepareTextSqlCommand(sql); using (var reader = cmd.ExecuteReader()) { B2b_Rentserver_RefundLog m = null; if (reader.Read()) { m = new B2b_Rentserver_RefundLog { id = reader.GetValue <int>("id"), orderid = reader.GetValue <int>("orderid"), rentserverid = reader.GetValue <int>("rentserverid"), rentservername = reader.GetValue <string>("rentservername"), ordertotalfee = reader.GetValue <decimal>("ordertotalfee"), refundfee = reader.GetValue <decimal>("refundfee"), subtime = reader.GetValue <DateTime>("subtime"), pay_com = reader.GetValue <string>("pay_com"), refundstate = reader.GetValue <int>("refundstate"), refundremark = reader.GetValue <string>("refundremark"), proid = reader.GetValue <int>("proid"), proname = reader.GetValue <string>("proname"), comid = reader.GetValue <int>("comid"), comname = reader.GetValue <string>("comname"), b2b_eticket_Depositid = reader.GetValue <int>("b2b_eticket_Depositid"), }; } return(m); } }
internal int EditServer_Refundlog(B2b_Rentserver_RefundLog m) { if (m.id > 0) { string sql = @"UPDATE [b2b_Rentserver_RefundLog] SET [orderid] = @orderid ,proid=@proid ,proname=@proname ,comid=@comid ,comname=@comname ,[rentserverid] = @rentserverid ,[rentservername] = @rentservername ,[ordertotalfee] = @ordertotalfee ,[refundfee] = @refundfee ,[subtime] = @subtime ,[pay_com] = @pay_com ,[refundstate] = @refundstate ,refundremark=@refundremark ,b2b_eticket_Depositid=@b2b_eticket_Depositid WHERE id=@id"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@id", m.id); cmd.AddParam("@orderid", m.orderid); cmd.AddParam("@rentserverid", m.rentserverid); cmd.AddParam("@rentservername", m.rentservername); cmd.AddParam("@ordertotalfee", m.ordertotalfee); cmd.AddParam("@refundfee", m.refundfee); cmd.AddParam("@subtime", m.subtime); cmd.AddParam("@pay_com", m.pay_com); cmd.AddParam("@refundstate", m.refundstate); cmd.AddParam("@refundremark", m.refundremark); cmd.AddParam("@proid", m.proid); cmd.AddParam("@proname", m.proname); cmd.AddParam("@comid", m.comid); cmd.AddParam("@comname", m.comname); cmd.AddParam("@b2b_eticket_Depositid", m.b2b_eticket_Depositid); cmd.ExecuteNonQuery(); return(m.id); } else { string sql = @"INSERT [b2b_Rentserver_RefundLog] ([orderid] ,proid ,proname ,comid ,comname ,[rentserverid] ,[rentservername] ,[ordertotalfee] ,[refundfee] ,[subtime] ,[pay_com] ,[refundstate] ,refundremark,b2b_eticket_Depositid) VALUES (@orderid ,@proid ,@proname ,@comid ,@comname ,@rentserverid ,@rentservername ,@ordertotalfee ,@refundfee ,@subtime ,@pay_com ,@refundstate,@refundremark,@b2b_eticket_Depositid);select @@identity;"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@orderid", m.orderid); cmd.AddParam("@rentserverid", m.rentserverid); cmd.AddParam("@rentservername", m.rentservername); cmd.AddParam("@ordertotalfee", m.ordertotalfee); cmd.AddParam("@refundfee", m.refundfee); cmd.AddParam("@subtime", m.subtime); cmd.AddParam("@pay_com", m.pay_com); cmd.AddParam("@refundstate", m.refundstate); cmd.AddParam("@refundremark", m.refundremark); cmd.AddParam("@proid", m.proid); cmd.AddParam("@proname", m.proname); cmd.AddParam("@comid", m.comid); cmd.AddParam("@comname", m.comname); cmd.AddParam("@b2b_eticket_Depositid", m.b2b_eticket_Depositid); object o = cmd.ExecuteScalar(); return(int.Parse(o.ToString())); } }