//修改电子票票纸号
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));
}
}
