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()); }