//修改电子票票纸号 internal int InsertOrUpdateB2b_eticket_Deposit(b2b_eticket_Deposit eticketDeposit) { string sql = ""; if (eticketDeposit.id == 0) { sql = "insert b2b_eticket_Deposit (eticketid,sid,saleprice,Depositprice,Depositorder,Backdepositstate) values(@eticketid,@sid,@saleprice,@Depositprice,@Depositorder,@Backdepositstate);select @@identity;"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@id", eticketDeposit.id); cmd.AddParam("@eticketid", eticketDeposit.eticketid); cmd.AddParam("@sid", eticketDeposit.sid); cmd.AddParam("@saleprice", eticketDeposit.saleprice); cmd.AddParam("@Depositprice", eticketDeposit.Depositprice); cmd.AddParam("@Depositorder", eticketDeposit.Depositorder); cmd.AddParam("@Backdepositstate", eticketDeposit.Backdepositstate); object o = cmd.ExecuteScalar(); int newId = o == null ? 0 : int.Parse(o.ToString()); return(newId); } else { sql = "update b2b_eticket_Deposit set eticketid=@eticketid,sid=@sid,saleprice=@saleprice,Depositprice=@Depositprice,Depositorder=@Depositorder,Backdepositstate=@Backdepositstate where id=@id"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@id", eticketDeposit.id); cmd.AddParam("@eticketid", eticketDeposit.eticketid); cmd.AddParam("@sid", eticketDeposit.sid); cmd.AddParam("@saleprice", eticketDeposit.saleprice); cmd.AddParam("@Depositprice", eticketDeposit.Depositprice); cmd.AddParam("@Depositorder", eticketDeposit.Depositorder); cmd.AddParam("@Backdepositstate", eticketDeposit.Backdepositstate); return(cmd.ExecuteNonQuery()); } }
//查询押金状态 internal b2b_eticket_Deposit GetB2b_eticket_DepositByid(int id) { string sql = @"SELECT * FROM [b2b_eticket_Deposit] where id=@id"; var cmd = sqlHelper.PrepareTextSqlCommand(sql); cmd.AddParam("@eid", id); using (var reader = cmd.ExecuteReader()) { b2b_eticket_Deposit r = null; if (reader.Read()) { r = new b2b_eticket_Deposit { id = reader.GetValue <int>("id"), eticketid = reader.GetValue <int>("eticketid"), sid = reader.GetValue <int>("sid"), saleprice = reader.GetValue <decimal>("saleprice"), Depositprice = reader.GetValue <decimal>("Depositprice"), Depositorder = reader.GetValue <int>("Depositorder"), Backdepositstate = reader.GetValue <int>("Backdepositstate") }; } return(r); } }
public int InsertOrUpdateB2b_eticket_Deposit(b2b_eticket_Deposit eticketDeposit) { using (var helper = new SqlHelper()) { return(new InternalB2bEticket(helper).InsertOrUpdateB2b_eticket_Deposit(eticketDeposit)); } }