public int Bus_feeticket_ProInsert(Bus_feeticket_Pro businfo)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalBus_Feeticket(sql);
int result = internalData.Bus_feeticket_ProInsert(businfo);
return(result);
}
catch
{
throw;
}
}
}
//设定可用的大巴车产品
internal int Bus_feeticket_ProInsert(Bus_feeticket_Pro businfo)
{
string sql = "insert Bus_feeticket_Pro (Busid,Proid)values(@Busid,@Proid)";
if (businfo.Id != 0)//如果有ID不为0则为修改
{
sql = "update Bus_feeticket_Pro set Busid=@Busid,Proid=@Proid where id =@id ";
}
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@id", businfo.Id);
cmd.AddParam("@Busid", businfo.Busid);
cmd.AddParam("@Proid", businfo.Proid);
return(cmd.ExecuteNonQuery());
}
