public int Bus_Feeticket_pnoInsertOrUpdate(Bus_Feeticket_pno businfo)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalBus_Feeticket(sql);
int result = internalData.Bus_Feeticket_pnoInsertOrUpdate(businfo);
return(result);
}
catch
{
throw;
}
}
}
//导入大巴车免费券
internal int Bus_Feeticket_pnoInsertOrUpdate(Bus_Feeticket_pno businfo)
{
string sql = "insert Bus_Feeticket_pno (Busid,Pno,Num)values(@Busid,@Pno,@Num)";
if (businfo.Id != 0)//如果有ID不为0则为修改
{
sql = "update Bus_Feeticket_pno set Busid=@Busid,Pno=@Pno,Num=@Num where id =@id ";
}
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@id", businfo.Id);
cmd.AddParam("@Busid", businfo.Busid);
cmd.AddParam("@Pno", businfo.Pno);
cmd.AddParam("@Num", businfo.Num);
return(cmd.ExecuteNonQuery());
}